import pandas as pd
import os
os.chdir(r'C:/Python39/jinsai/dataset/alltest/')
data = []
for excel in os.listdir('.'):
    data.append(pd.read_excel('C:/Python39/jinsai/dataset/alltest/'+ excel))
excel_all = pd.concat(data)
excel_all.to_csv('c:/python39/jinsai/dataset/alltest/汇总表.csv', index=False)

bb = df测评分值22['当前档位'].where(df测评分值22['当前档位'] == df测评分值22['上期档位'],"不同")
print(bb)
///////////////////////////////////////////////////////////////////////////////////
bb =np.where(df测评分值22['当前档位'] == df测评分值22['上期档位'],"相同","不同")
for i in bb:
    print(i)

max = df.groupby("客户")['商品'].apply(lambda x: x.value_counts().head(1))

dfto1['新加'] = dfto1['bv'].fillna(method='ffill')

dfto1['新加'] =dfto1['bv'].replace(["BV1jb411H7aa","BV1vb411K737","BV1Ut411p7xq","BV1Nb411h7bc","BV1Sb411G726"],["a1","a2","a3","a4","a5"],)
print(dfto1.head(5))