Pandas plotting issue

Question

I have the following dataframe:

Price,Volume
6550,18
6551,5
6552,2
6553,13
......
......
......
7001,3
7002,21

I want price along one axis and volume along the other. Since this is a pandas dataframe I am under the impression I can just plot it as follows:

df.plot(kind='bar')
plt.show()

However it is plotting both columns along the same axis. I want each column on a separate axis. I have tried the following which does not work:

df.plot(kind='bar', xticks=df['Price'], yticks=df['Volume'])

Any suggestions on what i'm doing wrong would be appreciated.

Ffisegydd · Accepted Answer · 2015-03-23 15:26:26Z

1

When you plot using df.plot(kind='bar') it will use the Index for the x-axis and then plot all columns in the DataFrame as y-values.

df.plot(x='Price', y='Volume', kind='bar')

See here for more examples of plotting using pandas.

answered Mar 23, 2015 at 15:26

Ffisegydd

54k16 gold badges151 silver badges125 bronze badges

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

Comments

sedavidw · Accepted Answer · 2015-03-23 15:26:52Z

1

Specify the x and y you desire by label:

df.plot(x='Price', y='Volume', kind='bar')

Here is the complete documentation:

answered Mar 23, 2015 at 15:26

sedavidw

11.8k18 gold badges70 silver badges103 bronze badges