一、利用loc定位行,直接写入Excel(若切分后的表格比较多,可引入参数)
import pandas as pd
data=pd.read_excel(r'D:\tmp\data.xlsx')
da1=data.loc[0:10000,:]
da2=data.loc[10001:20000,:]
da3=data.loc[20001:,:]
da1.to_excel(r'D:\tmp\da1.xlsx')
da2.to_excel(r'D:\tmp\da2.xlsx')
da3.to_excel(r'D:\tmp\da3.xlsx')
二、利用条件切分,并将切分后的文件写入Excel
import pandas as pd
data=pd.read_excel(r'D:\tmp\data.xlsx')
list1=data['city'].tolist()
list1=list(set(list1))
for i in list1:
da=data[data['city']==i]
path=r'D:\tmp\%s.xlsx'%i
da.to_excel(path)
print('over')