# -*- 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 ['內蒙古','甘肅','寧夏','青海']: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('請輸入文件路徑：') sheet_name = input('請輸入工作簿名稱：')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['最新核算結果'] = 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+'最新核算結果'+'.xlsx'))三、輸入賬單，進行核算。

在腳本文件目錄中執(zhí)行pyinstaller -F hesuan.py 進行打包exe文件，如果為安裝pyinstaller,使用pip install pyinstaller 安裝。點擊運行打包后的exe文件，輸入文件的路徑名和sheet名，就可以進行自動核算，腳本運行完成后會自動保存一個新的Excel文件。

到此這篇關于教你使用Pandas直接核算Excel中快遞費用的文章就介紹到這了,更多相關Pandas核算Excel中快遞費用內容請搜索好吧啦網以前的文章或繼續(xù)瀏覽下面的相關文章希望大家以后多多支持好吧啦網！