pandas - How to apply nested group by in python

Question

I have the dataset in the below format enter image description here

I would like to group the dataset in such a way that the "Department" column is removed and combine(Sum) "weekly_sales" data for each "Date" for each "Store". Below is the format in which I would like to reshape the above data into. enter image description here

question from:https://stackoverflow.com/questions/65908832/how-to-apply-nested-group-by-in-python

Answer 1

Waitting for answers