import pandas as pd data = pd.read_csv('Order.csv',sep=',',dtype={ 'order_num':str, 'price':int, 'date':str, 'shop_name':str, 'VIP_level':int, }) x = data.groupby('VIP_level')['price'].mean() y = data.groupby('VIP_level')['order_num'].count() print(x) print(y)