Write a python pandas program to create data frame quarterly sales where each row contain the item category, item name and expenditure. Group the row by the category and print the total expenditure per category.
Program Logic:
Step1: Create Dictionary ‘Sales_data’
Step2: Create Dataframe ‘Sales_quartley’ using pd.DataFrame() method
Step 3: Display DataFrame ‘Sales_quartley’
Step2: Use group by function on column ‘Item category’ to calculate total expenditure item_category ‘wise
Step3:Apply aggreagate function sum() to calculate the total expenditure ‘Item category’ wise.
Step4: Display the resultant Dataframe
Below is implementation code/Source code :
Output:
<