python学习系列5

import pandas as pd
import datetime
#from datetime import datetime as dt
f1=r'E:\\xx清单\\202302xx清单\\xx清单\\xxxx明细2.6-20230206-105458.xlsx'
df1=pd.read_excel(f1,sheet_name='xx明细信息',usecols=[0,6,10,11,12,13,14,15,16,18,19,22,25,27],dtype={0:'str'})
df1=df1.dropna(subset=['xx编号'])
df1['天数差']=pd.to_datetime(df1['xx日期'])-pd.to_datetime(df1['上次xx日期'])
df1['天数差']=df1['天数差'].map(lambda x:x.days)
#df1['xx日期']=df1['xx日期'].dt.strftime('%Y-%m-%d')#时间格式转化
#df1['上次xx日期']=df1['上次xx日期'].dt.strftime('%Y-%m-%d')#时间格式转化
#df1.insert(14,"xx单号","","xx类型","xxx")#插入列
df1['xx单号'],df1['xx类型'],df1['支付类型'],\
df1['xx年月'],\
df1['xx类型'],\
df1['本期日均xx'],\
df1['x损xx'],df1['x损xx'], df1['xx减免费用'], df1['xx减免'],df1['其他费用调整'],\
df1['不含税金额'],\
df1['xx编码'],df1['xx名称'], df1['xxxxx'], df1['xxxxxxx'],\
df1['备注1'],df1['备注2']\
    = ["", 'xxx',"xx",
       "202301",#每月变更对应账期信息
       "增值税专用发票13%",
       df1['总xx']/df1['天数差'],
       0,0,0,0,0,
       df1['应收xx']/1.13,
       "", "", "", "",#手动更新xx，xx名称，xx，xx
       "2023",""]
df1['xx日期2'] = df1['xx日期'] + datetime.timedelta(days=-1)
df1=df1.iloc[:,[13,0,27,28,29,30,15,16,17,18,1,19,2,3,4,5,20,7,6,8,9,21,22,23,24,25,10,11,12,26,33,14,31,32]]
df1.to_excel('E:\\学会Python\\测试文件夹\\测试保存14.xlsx',index=True,index_label="序号")