How to MatPlotLib Plot two DataFrames?

Question

I have two DataFrame north and south. Each has same rows and columns. I would like to plot the speed columns of both DataFrames in one figure as bar chart. I am trying this:

ax = south['speed'].plot(kind='bar', color='gray')
north['speed'].plot(kind = 'bar', color='red', ax=ax)
plt.show()

But it plots only the last dataframe , i.e. only the north DataFrame. Can you help me?

Serenity · Accepted Answer · 2018-12-10 03:57:03Z

1

1) If you would like to plot just 'speed' column, you have to concatenate dataframes like:

df = pd.concat([north, south])

or

df = north.append(south)

2) If you would like to compare 'speed' column of both dataframes, you have to join dataframes along axis=1 like:

df = pd.concat([north, south], axis=1, ignore_index=True)

and the call plot method of df.

For more info: https://pandas.pydata.org/pandas-docs/stable/merging.html

answered Dec 10, 2018 at 3:57

Serenity

37.1k21 gold badges125 silver badges117 bronze badges

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

2 Comments

King D Anonymous Over a year ago

Thank you for the perfect answer. But, still have one question. I would like to compare the speed and the index of the north and south are dateIndex. If the rows are same but the value of index are not then, then what I can do?

Serenity Over a year ago

I can not figure out short answer for this problem. May be make group by speed values and then compare data in a group?

Collectives™ on Stack Overflow

How to MatPlotLib Plot two DataFrames?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related