import pandas as pd df= pd.read_csv('Order.csv',sep=',') print(df.groupby('VIP_level')['price'].mean()) print(df.groupby('VIP_level')['shop_name'].nunique())