import pandas as pd
text = """    saleid                              upc
0   155_02127453_20090616_135212_0021   02317639000000
1   155_02127453_20090616_135212_0021   00000000000888
2   155_01605733_20090616_135221_0016   00264850000000
3   155_01072401_20090616_135224_0010   02316877000000
4   155_01072401_20090616_135224_0010   05051969277205"""
df = pd.read_csv(StringIO(text), delim_whitespace=True, dtype=str)
df
Pandas сводная таблица продаж