how to plot histograms from dataframes in pandas

Question

I have a simple dataframe in pandas that has two numeric columns. I want to make a histogram out of the columns using matplotlib through pandas. The example below does not work:

In [6]: pandas.__version__
Out[6]: '0.14.1'

In [7]: df
Out[7]: 
   a   b
0  1  20
1  2  40
2  3  30
3  4  30
4  4   3
5  3   5

In [8]: df.plot(kind="hist")
---------------------------------------------------------------------------
ValueError                                Traceback (most recent call last)
<ipython-input-8-4f53176a4683> in <module>()
----> 1 df.plot(kind="hist")

/software/lib/python2.7/site-packages/pandas/tools/plotting.pyc in plot_frame(frame, x, y, subplots, sharex, sharey, use_index, figsize, grid, legend, rot, ax, style, title, xlim, ylim, logx, logy, xticks, yticks, kind, sort_columns, fontsize, secondary_y, **kwds)
   2095         klass = _plot_klass[kind]
   2096     else:
-> 2097         raise ValueError('Invalid chart type given %s' % kind)
   2098 
   2099     if kind in _dataframe_kinds:

ValueError: Invalid chart type given hist

why does it say invalid chart type? the columns are numeric and can be made into histograms.

Try reinstalling Pandas. That worked for me.

samthebrand
– samthebrand

2015-04-26 18:24:19 +00:00
Commented Apr 26, 2015 at 18:24 — samthebrand
– samthebrand, Commented Apr 26, 2015 at 18:24

JAB · Accepted Answer · 2017-05-07 22:30:27Z

16

DataFrame has its own hist method:

df =pd.DataFrame({'col1':np.random.randn(100),'col2':np.random.randn(100)})
df.hist(layout=(1,2))

draws a histogram for each valid column of the dataframe.

enter image description here

edited May 7, 2017 at 22:30

answered Feb 22, 2015 at 4:06

JAB

12.9k7 gold badges48 silver badges51 bronze badges

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

Comments

Bob Haffner · Accepted Answer · 2015-02-22 04:06:58Z

2

I don't believe 'hist' was a supported type in 0.14.1. Try df.hist() instead

answered Feb 22, 2015 at 4:06

Bob Haffner

8,5231 gold badge40 silver badges44 bronze badges

Collectives™ on Stack Overflow

how to plot histograms from dataframes in pandas

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related