I have a dataframe with 5 columns: salesman
, vendor
, product1
, product2
and product3
. The dataframe is similar to below:
I want to groupby salesman
, loop through 'salesman'
index and create a separate stacked bar chart for each salesman. For each stacked bar chart, I want x-axis to be the vendor
and y-axis to stack on column values (i.e. product1/2/3 sales amount). Desired output:
Have tried several methods combined with for loop but keep getting error. Appreciate any guidance on this one! Thank you.