import pandas as pd data = pd.read_csv("Order.csv",sep=',') data = data.groupby('shop_name')['price'].agg(['sum']).sort_values(by='sum',ascending=False) print(data)