怎么按商户横向按日期排列营业额啊

Question

就是要按照商户的名称横向排列每月（也就是每个工作表的名字）的营业额

Answer 1

大致如下：

import pandas as pd
df = pd.read_excel('d:\\done.xlsx', sheet_name=None)
dic = {}
for sheetname in df.keys():
    for lines in range(df[sheetname].shape[0]):
        k = df[sheetname].loc[lines][0]
        v = df[sheetname].loc[lines][1]
        dic[k] = dic.get(k,[])+[v]

print(' '*5,*df.keys())
for k,v in dic.items():
    print(k,*v)

'''out:
      9月 12月 1月
AAA 9100 12100 1100
BBB 9200 12200 1200
CCC 9300 12300 1300
DDD 9400 12400 1400
'''