# encoding: utf-8 import arcpy import xlrd import pandas as pd path=r"D:\pyWork\resultAna\dl" day=29 while(day>28): pp=path+"\\ppday"+str(day)+".xls" cs = path + "\\csday" + str(day) + ".xls" #读取excel指定列名 datapp=pd.read_excel(pp,names=['id','score']) datacs=pd.read_excel(cs,names=['id','score']) #基于某列来连接两个dataframe jg=pd.merge(datapp,datacs,how = 'left',on='id') #添加一列 jg['per']=(jg['score_y'])/jg['score_x'] jg.to_excel("./all/day" + str(day) + ".xls") #jg['per']=jg.apply(lambda k: function((k.score_y-k.score_x)/k.score_x), axis = 1) day=day-1
python读取excel指定列名,dataframe连接,两列相减作为第三列的值
最新推荐文章于 2024-08-16 15:21:00 发布