pandas分割excel
import pandas as pd
import math
path = r'C:\Users\lenovo\Desktop\目标数据.xlsx'
df = pd.read_excel(path)
tem = 0
# ceil向上取整
for i in range(math.ceil(175127/10000)):
name = str(i) + '.xlsx'
df[tem:tem+10000].to_excel(name,index=False)
print(f'第{i}个Excel完成')
tem += 10000