超市商品数据分析

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
order = pd.read_csv(r文件名称’,encoding=‘gbk’)

#哪些类别的商品比较畅销？

mask = order[‘销量’]<0

index = order.index[mask]

order.drop(labels=index,axis=0,inplace=True)

order_group1 = order[[‘类别ID’, ‘销量’]].groupby(by=‘类别ID’).sum().sort_values(by = ‘销量’,ascending=False)#sort_values表示排序，ascending=False表示倒序

order_group1 = order[[‘类别ID’, ‘销量’]].groupby(by=‘类别ID’).sum().reset_index()#reset_index重置行索引

print(order_group1)

哪些商品比较畅销？<