python plotting a dataframe

Question

I have a pandas dataframe in Python that looks like this:

  Jan 15   Feb 15   March 15   April 15
1   val      val      val       val
2   val      val      val       val 
3   val      val      val       nan
4   val      nan      val       nan
5   val      nan      nan       nan

I want to plot a graph as follows. The X axis is the months (Jan 15 | Feb 15 | March 15 | April 15), and the bars are like so:

Jan 15: 5
Feb 15: 3
March 15: 4
April 15: 2

^ this is the count of non-null values for each month.

Any help on how to plot it with matplotlib or anything else?

EDIT: the values in the df are tuples like so: (val1, val2).

jezrael · Accepted Answer · 2016-12-12 11:13:58Z

2

You need count with Series.plot.bar:

import matplotlib.pyplot as plt
df.count().plot.bar()
plt.show()

Solution with Series.plot:

import matplotlib.pyplot as plt
df.count().plot(kind='bar')
plt.show()

edited Dec 12, 2016 at 11:13

answered Dec 12, 2016 at 11:07

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

2 Comments

TheDaJon Over a year ago

is there a wat to make a tag cloud of it? for example, instead of a graph, plot in a tag cloud the months, and the largest font moth would be the one with the most data?

jezrael Over a year ago

Hmmm, in pandas it is not possible, I am not sure if in matplotlib. I found this solution, try it.

IanS · Accepted Answer · 2016-12-12 11:29:43Z

2

This will return a series with the data you want to plot:

df.count()

This will plot it:

df.count().plot.bar();  # the semicolon will suppress output in Jupyter

Edit: made it a bar chart.

edited Dec 12, 2016 at 11:29

answered Dec 12, 2016 at 11:03

IanS

16.3k9 gold badges64 silver badges87 bronze badges

7 Comments

TheDaJon Over a year ago

how do I plot the graph? it prints: <matplotlib.axes._subplots.AxesSubplot at 0x20e3fbc8ef0>

IanS Over a year ago

I assume you're in Jupyter. You have to enable inline charts by running %matplotlib inline once.

Julien Marrec Over a year ago

import matplotlib.pyplot as plt. Then after df.count().plot(), add plt.show(). If you're using jupyter notebook you can also use the magic %matplotlib inline. @IanS: add kind='bar' in your plot call

Julien Marrec Over a year ago

df.count().plot(kind='bar', stacked=True) is an alternative syntax. The stacked argument is worth knowing about too.

Julien Marrec Over a year ago

As far as I know, literally anywhere else than jupyter notebook with matplotlib inline. I made a habit of always including it. It also mutes down the classic output of a collection of axes when you plot without capturing the axes

|

Collectives™ on Stack Overflow

python plotting a dataframe

2 Answers 2

2 Comments

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related