Plot all pandas dataframe columns separately

Question

I have a pandas dataframe who just has numeric columns, and I am trying to create a separate histogram for all the features

ind group people value value_50
 1      1    5    100    1
 1      2    2    90     1
 2      1    10   80     1
 2      2    20   40     0
 3      1    7    10     0
 3      2    23   30     0

but in my real life data there are 50+ columns, how can I create a separate plot for all of them

I have tried

df.plot.hist( subplots = True, grid = True)

It gave me an overlapping unclear plot.

how can I arrange them using pandas subplots = True. Below example can help me to get graphs in (2,2) grid for four columns. But its a long method for all 50 columns

fig, [(ax1,ax2),(ax3,ax4)]  = plt.subplots(2,2, figsize = (20,10))

So it was an example of what you don't want. But what's what you want? How should the figure look like? — Stop harming Monica
– Stop harming Monica, Commented Apr 8, 2019 at 7:59
@goyo histogram graph for all the columns in a data frame, simple! In the above example, its 5 columns, in my real example it's 50. Can you write something generic? I am sure it can be done — Manu Sharma
– Manu Sharma, Commented Apr 8, 2019 at 8:06

ImportanceOfBeingErnest · Accepted Answer · 2019-04-08 09:59:24Z

76

Pandas subplots=True will arange the axes in a single column.

import numpy as np
import matplotlib.pyplot as plt
import pandas as pd

df = pd.DataFrame(np.random.rand(7,20))

df.plot(subplots=True)

plt.tight_layout()
plt.show()

Here, tight_layout isn't applied, because the figure is too small to arange the axes nicely. One can use a bigger figure (figsize=(...)) though.

In order to have the axes on a grid, one can use the layout parameter, e.g.

df.plot(subplots=True, layout=(4,5))

The same can be achieved if creating the axes via plt.subplots()

fig, axes = plt.subplots(nrows=4, ncols=5)
df.plot(subplots=True, ax=axes)

answered Apr 8, 2019 at 9:59

ImportanceOfBeingErnest

342k61 gold badges737 silver badges771 bronze badges

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

1 Comment

Girish Kumar Chandora Over a year ago

@ ImportanceOfBeingErnest Could you figure out how to handle X and Y axis scale in each plot? !Here's the question

annhak · Accepted Answer · 2019-08-29 09:25:45Z

15

If you want to plot them separately (which is why I ended up here), you can use

for i in df.columns:
    plt.figure()
    plt.hist(df[i])

answered Aug 29, 2019 at 9:25

annhak

6926 silver badges17 bronze badges

Comments

Ramon · Accepted Answer · 2020-04-06 20:05:29Z

11

An alternative for this task can be using the "hist" method with hyperparameter "layout". Example using part of the code provided by @ImportanceOfBeingErnest:

import numpy as np
import matplotlib.pyplot as plt
import pandas  as pd

df = pd.DataFrame(np.random.rand(7,20))

df.hist(layout=(5,4), figsize=(15,10))

plt.show()

answered Apr 6, 2020 at 20:05

Ramon

5387 silver badges16 bronze badges

Comments

Manuel · Accepted Answer · 2021-05-03 17:10:04Z

4

Using pandas.DataFrame I would suggest using pandas.DataFrame.apply. With a custom function, in this example plot(), you can print and save each figure seperately.

def plot(col):
 
    fig, ax = plt.subplots()
    ax.plot(col)
    plt.show()

df.apply(plot)

answered May 3, 2021 at 17:10

Manuel

2,5524 gold badges23 silver badges36 bronze badges

Comments

wwii · Accepted Answer · 2020-08-13 17:16:24Z

0

While not asked for in the question I thought I'd add that using the x parameter to plot would allow you to specify a column for the x axis data.

import numpy as np
import matplotlib.pyplot as plt
import pandas as pd

df = pd.DataFrame(np.random.rand(7,20),columns=list('abcdefghijklmnopqrst'))
df.plot(x='a',subplots=True, layout=(4,5))    

plt.tight_layout()
plt.show()

https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.plot.html

edited Aug 13, 2020 at 17:16

answered Aug 13, 2020 at 17:10

wwii

23.9k7 gold badges42 silver badges80 bronze badges

Collectives™ on Stack Overflow

Plot all pandas dataframe columns separately

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related