Python之两个dataframe相除(二)
#可以以一列唯一的标识列作为index
# dataframe的每一列除以series
data = {'name':['cun1','cun2','cun3'],
'hah':[1,2,2],
'数量':[3,2,5],
'价格':[10,9,8]}
df = pd.DataFrame(data)
df.set_index(['name'],inplace=True)
print(df)
# dataframe的每一列除以series
data1 = {'name':['cun3','cun2','cun1'],
'hah':[1,2,2],
'数量':[3,2,5],
'价格':[10,9,8]}
df1 = pd.DataFrame(data1)
df1.set_index(['name'],inplace=True)
print(df1)
aa = df.div(df1,axis=0)