location_dict = { "A": "Los Angeles", "B": "Fresno", "C": "San Jose" } dataframe['Location_Mapped'] = dataframe['Location'].map(location_dict) data = dataframe.groupby(['Location_Mapped','Customer type','Gender','Product line'])['Total'].agg(['sum', 'mean', 'median']).round(2).reset_index() data