python pandas 数据groupby处理后排序

python pandas 数据groupby处理后排序

---

import pandas as pd

data_csv = pd.read_csv('./static/task1_1_A.csv', encoding='gbk')

#打印前10行数据
print(data_csv.head(10))

#每个课程的次数
data_count_list = data_csv['price'].groupby(data_csv['course_id']).count()
print(data_count_list)

#groupby后的数据进行排序
sort_list = data_count_list.reset_index().sort_values('price',ascending = False).set_index('course_id')

print(sort_list)