教你使用Pandas直接核算Excel中快递费用

第教你使用Pandas直接核算Excel中快递费用一、确定核算规则

二、根据核算规则编写代码，生成核算列

#-*-coding:utf-8-*-

importpandasaspd

frommathimportceil

importos

defaccount(adress,weight):

ifadress=="湖南":

ifweight=3:

totel=2.5

elif(weight=3)and(weight=5):

totel=3.5+ceil((weight-3))*1

else:

totel=ceil(weight)*1

returntotel

elifadressin["河北","天津","山西","浙江","江苏","安徽","福建","山东","江西","广东","广西","河南","湖北","陕西","四川","重庆","云南","贵州"]:

ifweight=3:

totel=2.5

elif(weight=3)and(weight=5):

totel=3.5+ceil((weight-3))*1

else:

totel=ceil(weight)*2

returntotel

elifadressin["深圳","北京","上海"]:

ifweight=3:

totel=3.3

elif(weight=3)and(weight=5):

totel=3.5+ceil((weight-3))*1.5

else:

totel=ceil(weight)*2

returntotel

elifadressin["海南","辽宁","黑龙江","吉林"]:

ifweight=3:

totel=2.5

elif(weight=3)and(weight=5):

totel=3.5+ceil((weight-3))*2.5

else:

totel=ceil(weight)*3

returntotel

elifadressin["内蒙古","甘肃","宁夏","青海"]:

ifweight=1:

totel=9

else:

totel=9+ceil(weight-1)*6

returntotel

elifadress=="新疆":

ifweight=1:

totel=15

else:

totel=15+ceil(weight-1)*12

returntotel

elifadress=="西藏":

ifweight=1:

totel=16

else:

totel=15+ceil(weight-1)*18

returntotel

else:

print("你输入的省份不合法！！！")

file_path=input("请输入文件路径：")

sheet_name=input("请输入工作簿名称：")

pf=pd.read_excel(file_path,sheet_name=sheet_name)

#获取省份一列

pro=pf["省份"].values.tolist()

#获取重量一列

wt=pf["重量"].values.tolist()

totel=[]

forp,winzip(pro,wt):

print(p,w)

totel.append(account(p,w))

pf["最新核算结果"]=totel

file_name=os.path.basename(file_path)

pf.to_excel(os.path.join(os.path.dirname(file_path),os.path.basename(file_path).split(".")[0]+sheet_name+"最新核算结果"+".xlsx"))

三、输入账单，进行核算。

在脚本文件目录中执行pyinstaller-Fhesuan.py进行打包exe文件，如果为安装pyi