Create stacked bar plot in pandas

Question

I am plotting the foll. dataframe using pandas:

╔═════════════════════════════════════════════════════════════════════════╗
║                       country_name              1960s      1970s        ║
╠═════════════════════════════════════════════════════════════════════════╣
║ functional_crop_type                                                    ║
║ C3annual              United States of America  48.226957  42.384590    ║
║ C3perennial           United States of America   1.377634   1.377971    ║
║ C4annual              United States of America  32.526747  32.833662    ║
║ C4perennial           United States of America   0.265062   0.289005    ║
║ N-fixing              United States of America  17.603600  23.114773    ║
╚═════════════════════════════════════════════════════════════════════════╝   
╔════════════════════════════════════════════════════════════════════╗
║                       1980s      1990s      2000s      2010s       ║
╠════════════════════════════════════════════════════════════════════╣
║ functional_crop_type                                               ║
║ C3annual              41.184368  39.085943  32.821374  28.767468   ║
║ C3perennial            1.413647   1.561404   1.657869   1.691046   ║
║ C4annual              31.260082  32.089138  33.705184  36.815154   ║
║ C4perennial            0.303626   0.367331   0.386495   0.359842   ║
║ N-fixing              25.838277  26.896184  31.429078  32.366490   ║
╚════════════════════════════════════════════════════════════════════╝

Using the foll. command:

out_dec_df = out_dec_df.set_index('functional_crop_type')
out_dec_df.plot(kind='bar',stacked=True)

However, I want the x-axis to be '1960s', '1970s'...'2010s' and the stacked bar plot to be composed of the functional crop types. How do I do this?

enter image description here

Jianxun Li · Accepted Answer · 2015-07-17 21:36:28Z

1

Try using transpose.

out_dec_df.drop('country_name', axis=1).T.plot(kind='bar',stacked=True)

edited Jul 17, 2015 at 21:36

answered Jul 17, 2015 at 21:31

Jianxun Li

24.9k10 gold badges64 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user308827 Over a year ago

I did try that earlier, but it tells me that there is no numeric data to plot

Jianxun Li Over a year ago

@user308827 can you upload the csv version of your df using out_dec_df.to_csv(), so that I can play with the real dataset?

Jianxun Li Over a year ago

@user308827 I guess that's because the column country_name is string, and after transposing, it has no numeric value. try drop that column and then transpose.

Collectives™ on Stack Overflow

Create stacked bar plot in pandas

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related