I am using this data for forecasting and I will have to create three datasets (three different categories) for it. After doing the aggregation, my dataframe turned out to have multiple levels - df['payment_value']['count'] and I can't figure out how to select my product category. The following is what I did before aggregating but it does not work anymore:
df[(df['product_category_english'] == 'party_supplies')]
#I have also tried but did not work.
df[(df['payment_value']['count']['product_category_english'] == 'party_supplies')]
