文章目录
例1
原来:
list_sorted = ['<=5', '>=6 and <=15', '>=16 and <25','>=25']
_['type'] = _['type'].astype('category').cat.set_categories(list_sorted)
_ = _.sort_values(by=['type'], ascending=True).set_index('type')
# 也聚合了
例2 - MIUI画像
city_list = ['一线城市','新一线城市','二线城市','三线城市','四线城市','五线城市']
city_df['current_city_type'] = city_df['current_city_type'].astype('category').cat.set_categories(city_list)
city_df = city_df.sort_values(by=['current_city_type'], ascending=True).set_index('current_city_type')