import pandas as pd data = pd.read_csv("Order.csv",sep=',',dtype={ 'order_num':str, 'price':int, 'date':str, 'shop_name':str, }) z = data[data['date']=='2022/6/18']['price'].sum() d = data.groupby('shop_name')['order_num'].count() print(z) print(d)
import pandas as pd data = pd.read_csv("Order.csv",sep=',',dtype={ 'order_num':str, 'price':int, 'date':str, 'shop_name':str, }) z = data[data['date']=='2022/6/18']['price'].sum() d = data.groupby('shop_name')['order_num'].count() print(z) print(d)