excel根据使用人筛选合适的数据

import pandas as pd
import os

excels = [
pd.read_excel(fname)
for fname in os.listdir("./")
if “test.xls” in fname
]
excels1 = [
pd.read_excel(fname)
for fname in os.listdir("./")
if “使用人.xls” in fname]
df = excels[0]
#filename = “E:\python-dir\每天处理\2020-12-11.xlsx”
#df = pd.read_excel(filename)
df1 = excels1[0]
dfnew= df1[‘姓名’]
list1=dfnew.tolist()
dfnew=[]
for i in range(0,df1.index.stop):
df_new = df[df[‘使用人’]== list1[i]]
dfnew.append(df_new)
result=dfnew[0]
for i in range(1,df1.index.stop):
result=result.append(dfnew[i])
result.to_excel(‘数据.xlsx’,index=None)