正文
pandas读取Excel
提示：扫一扫查出行【扫一扫了解最新限行尾号】
复制提示
time31 = pd.read_excel('F:/save_file/3问出车表.xlsx', sheetname='Sheet1')# 读取‘3问出车表.xlsx’中的Sheet1表单，
time32 = pd.read_excel('F:/save_file/3问出车表.xlsx', sheetname='Adjustment')# 读取‘3问出车表.xlsx'中的Adjustment表单
time31 = time31.replace('NaN',0)
time32 = time32.replace('NaN',0)
time_31 = time31.applymap(trans)
time_32 = time32.applymap(trans)
# 保存为'3问time出车表.xlsx'文件
with pd.ExcelWriter('F:/save_file/3问time出车表.xlsx') as writer:
time_31.to_excel(writer,sheet_name = 'Sheet_1')
time_32.to_excel(writer,sheet_name = 'Sheet_2')
writer.save()
