Pandas stack columns in dataframe an make a histogram

Question

I have a dataframe that looks like this:

df_vspd=df.ix[:,['VSPD1','VSPD2','VSPD3','VSPD4','VSPD5','VSPD6','VSPD7']]
df_vspd.head()


   VSPD1  VSPD2  VSPD3  VSPD4  VSPD5  VSPD6  VSPD7
0    NaN    NaN    NaN    NaN    NaN    NaN    NaN
1  21343  37140  30776  12961   1934     14      0
2   6428   9526   9760  12075   4262      0      0
3  11795  14188  16702  18917    612      0      0
4  43571  60684  41611  12168  11264     79      0

I would like to plot a histogram of the data. However I want to stack the columns and do the histogram. Seems like a simple task, however I can not do it!! Help please

What I want to do is stack the columns (VSPD1-VSPD7), and make them the index column. I tried:

cnames = list(df_vspd.columns)
df_test = df_vspd.set_index(cnames).

However it does not do me any good.

My simple idea is to pass a list of the column names to the pandas set_index function and then do the plot. But I'm not capable! — jonas
– jonas, Commented Aug 27, 2013 at 11:59
You should update the question with the code you tried out, cause it will probably be closed. SO rules. — Viktor Kerkez
– Viktor Kerkez, Commented Aug 27, 2013 at 12:08
I have included the dataframe above. What I want to do is stack the columns (VSPD1-VSPD7), and make them the index column. I tried: cnames=list(df_vspd.columns) df_test=df_vspd.set_index(cnames). However it does not do me any good. — jonas
– jonas, Commented Aug 27, 2013 at 12:12

Viktor Kerkez · Accepted Answer · 2013-08-27 12:20:16Z

1

Do you want:

df_vspd.stack(0).hist()

answered Aug 27, 2013 at 12:20

Viktor Kerkez

46.8k13 gold badges109 silver badges88 bronze badges

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

Collectives™ on Stack Overflow

Pandas stack columns in dataframe an make a histogram

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related