-1

I am reading huge csv file using pandas module.

filename = pd.read_csv(filepath)

Converted to Dataframe,

df = pd.DataFrame(filename, index=None)

From the csv file, I am concerned with the three columns of name country, year, and value. I have groupby the country names and sum the values of it as in the following code and plot it as a bar graph.

df.groupby('country').value.sum().plot(kind='bar')

where, x axis is country and y axis is value.

Now, I want to make this bar graph as a stacked bar and used the third column year with different color bars representing each year. Looking forward for an easy way. Note that, year column contains years from 2000 to 2019. Thanks.

sodmzs
  • 184
  • 1
  • 16

1 Answers1

1

from what i understand you should try something like :

df.groupby(['country', 'Year']).value.sum().unstack().plot(kind='bar', stacked=True)

Benoit de Menthière
  • 713
  • 4
  • 13