统计销量 Counter

import pandas as pdfrom collections import Counterimport numpy as npdf = pd.read_csv("fb_viogi.csv",encoding="gbk")ebaynos = df.ebayno.valuesitem = Counter(ebaynos) #返回的是字典 #list中出现个数统计result = []for ebayno in item.keys():    sub_df = df[df.ebayno == ebayno]    title = sub_df.title.values[0] #选择第一个title    price = sub_df.price    mean = round(price.mean(),2) #计算平均价格，并四舍五入保留2位小数    result.append([ebayno,title , item[ebayno], mean])re = pd.DataFrame(result, columns=["ebayno","title","sale","price"])re.to_csv("result_sale.csv", index= False)