教你使用Pandas直接核算Excel中的快遞費(fèi)用
# -*- coding:utf-8 -*- import pandas as pd from math import ceilimport osdef account(adress,weight):if adress == '湖南':if weight <= 3: totel = 2.5elif (weight >= 3) and (weight<=5): totel = 3.5 + ceil((weight-3))*1else: totel = ceil(weight)*1return totelelif adress in ['河北','天津','山西','浙江','江蘇','安徽','福建','山東','江西','廣東','廣西','河南','湖北','陜西','四川','重慶','云南','貴州']:if weight <= 3: totel = 2.5elif (weight >= 3) and (weight<=5): totel = 3.5 + ceil((weight-3))*1else: totel = ceil(weight)*2 return totelelif adress in ['深圳','北京','上海']:if weight <= 3: totel = 3.3elif (weight >= 3) and (weight<=5): totel = 3.5 + ceil((weight-3))*1.5else: totel = ceil(weight)*2return totelelif adress in ['海南','遼寧','黑龍江','吉林']:if weight <= 3: totel = 2.5elif (weight >= 3) and (weight<=5): totel = 3.5 + ceil((weight-3))*2.5else: totel = ceil(weight)*3return totel elif adress in ['內(nèi)蒙古','甘肅','寧夏','青海']:if weight <= 1: totel = 9else: totel = 9 + ceil(weight-1)*6 return totel elif adress == '新疆':if weight <= 1: totel = 15else: totel = 15 + ceil(weight-1)*12 return totel elif adress == '西藏':if weight <= 1: totel = 16else: totel = 15 + ceil(weight-1)*18 return totelelse:print('你輸入的省份不合法!!!') file_path = input('請(qǐng)輸入文件路徑:') sheet_name = input('請(qǐng)輸入工作簿名稱:')pf = pd.read_excel(file_path,sheet_name=sheet_name)#獲取省份一列pro = pf['省份'].values.tolist()#獲取重量一列wt = pf['重量'].values.tolist()#核算列totel = []for p,w in zip(pro,wt): print(p,w) totel.append(account(p,w))pf['最新核算結(jié)果'] = totelfile_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+'最新核算結(jié)果'+'.xlsx'))三、輸入賬單,進(jìn)行核算。
在腳本文件目錄中執(zhí)行pyinstaller -F hesuan.py 進(jìn)行打包exe文件,如果為安裝pyinstaller,使用pip install pyinstaller 安裝。點(diǎn)擊運(yùn)行打包后的exe文件,輸入文件的路徑名和sheet名,就可以進(jìn)行自動(dòng)核算,腳本運(yùn)行完成后會(huì)自動(dòng)保存一個(gè)新的Excel文件。
到此這篇關(guān)于教你使用Pandas直接核算Excel中快遞費(fèi)用的文章就介紹到這了,更多相關(guān)Pandas核算Excel中快遞費(fèi)用內(nèi)容請(qǐng)搜索好吧啦網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持好吧啦網(wǎng)!
相關(guān)文章: