creating stacked histogram with pandas dataframes data python

Question

I am trying to create a stacked histogram with data from 2 or more uneven pandas dataframes? So far I can get them to graph on top of each other but not stack.

import pandas as pd
import matplotlib.pyplot as plt

df = pd.read_csv('dert.csv', encoding = "ISO-8859-1", index_col=0)

df1['text'] = df['text'].dropna(subset=['five'])
df2['printed'] = df['text2']
ax = df1['text'].hist( bins=100, range=(1,100), stacked=True, color = 'r')
ax = df2['printed'].hist(bins=100, range=(1,100), stacked=True, color = 'g')

plt.setp(ax.get_xticklabels(),  rotation=45)
plt.show()

How do I get them to stack?

I found a solution but it does not use pandas dataframes Matplotlib, creating stacked histogram from three unequal length arrays

Have you tried using the same method as that link you posted? Using regular matplotlib, just passing the DataFrame columns you want to plot, should work. At most, you can create a list of each column's values. — RJT
– RJT, Commented Jul 6, 2014 at 9:44

smci · Accepted Answer · 2015-08-28 07:30:52Z

28

The method in that post should work:

plt.hist([df1['text'],df2['printed']],
          bins=100, range=(1,100), stacked=True, color = ['r','g'])

edited Aug 28, 2015 at 7:30

smci

34.2k21 gold badges118 silver badges152 bronze badges

answered Jul 6, 2014 at 15:26

Happy001

6,4032 gold badges26 silver badges17 bronze badges

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

1 Comment

Josiah Yoder Over a year ago

Be sure to remove nan's before using this.

Collectives™ on Stack Overflow

creating stacked histogram with pandas dataframes data python

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related