读取文本内容,计算销售总额,列出销售额最高/最低的商品编码和销售额
文本文件内容如下:
商品编码,销售单价,销售数量
10001,12.5,30
10002,15.8,40
10005,200,20
10001,12.5,87
10002,28.7,66
代码如下:
import pandas as pd
dates = pd.read_csv('productinfo.txt') # 获取数据
#print(dates)
#print(dates.loc[:,1].sum())
#print(type(dates["danjia"]))
dates["heji"]=dates["danjia"]*dates["shul"]
he=dates["heji"].sum(axis=0)#指定列列求和
print("销售合计:",he)
dates.loc['axis_0']=dates.loc[:,['danjia','shul']].apply(lambda x:x.sum()) #多列求和
#print(dates)
df = dates.groupby(['biaohao'])['heji'].sum()
#print(type(df))
#print(len(df))
for i in df:
print(i)
#df.sort_values('biaohao',ascending=True)
print("编号","销售额")
print(df)
#ad_min = dates.groupby('biaohao').apply(lambda t: t[t.danjia==t.danjia.min()])
#print(ad_min)
#print("最大销售:",df.idmax())
#print("最低销售:",df.idmin())
现在是销售总额可以得出,但是不知道怎么输出销售额最高/最低的商品编码和销售额