题解 | #不同等级会员的购买力#

import pandas as pd 
df=pd.read_csv('Order.csv',sep=",",dtype=object)
df0 = df[df['VIP_level'] =='0']
df1 = df[df['VIP_level'] =='1']
df2 = df[df['VIP_level'] =='2']
df3 = df[df['VIP_level'] =='3']

print('VIP_level')
print(df0['VIP_level'],df0['price'].astype(float).mean())
print(df1['VIP_level'],df1['price'].astype(float).mean())
print(df2['VIP_level'],df2['price'].astype(float).mean())
print(df3['VIP_level'],df3['price'].astype(float).mean())
print('VIP_level')
print(df0['VIP_level'],df0['shop_name'].value_counts())
print(df1['VIP_level'],df1['shop_name'].value_counts())
print(df2['VIP_level'],df2['shop_name'].value_counts())
print(df3['VIP_level'],df3['shop_name'].value_counts())