import pandas as pd df= pd.read_csv('Order.csv',sep=',',dtype=object) date = df[(df['date'] == '2022/6/18')] print(pd.to_numeric(date['price']).sum()) print(pd.to_numeric(date.groupby('shop_name')['price'].mean())) # 很抽象,不算平均值直接提交也是通过的