import pandas as pd
import numpy as np
data = pd.read_csv(r'Order.csv')
print(data.groupby('VIP_level')['price'].mean())
data1 = data.drop_duplicates(subset=['shop_name', 'VIP_level'], keep='first')
print(data1.groupby('VIP_level')['shop_name'].count())

京公网安备 11010502036488号