plot graph from python dataframe

Question

i want to convert that dataframe into this dataframe and plot a matplotlib graph using date along x axis changed dataframe

Isn't this question a dupe of your previous question: stackoverflow.com/questions/40161665/…? — EdChum
– EdChum, Commented Oct 21, 2016 at 8:05
how can i convert the dataframe into the 'changed dataframe'. I tried transpose function.but then i cant able to plot that dataframe. — Manaf Mh
– Manaf Mh, Commented Oct 21, 2016 at 16:10

Kennet Celeste · Accepted Answer · 2016-10-21 16:18:23Z

1

Use df.T.plot(kind='bar'):

import pandas as pd
import matplotlib.pyplot as plt

df = pd.DataFrame.from_csv('./housing_price_index_2010-11_100.csv')

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

you can also assign the transpose to a new variable and plot that (what you asked in the comment):

import pandas as pd
import matplotlib.pyplot as plt

df = pd.DataFrame.from_csv('./housing_price_index_2010-11_100.csv')

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

both result the same:

edited Oct 21, 2016 at 16:18

answered Oct 21, 2016 at 13:43

Kennet Celeste

4,8113 gold badges28 silver badges34 bronze badges

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

3 Comments

Manaf Mh Over a year ago

how can i convert the dataframe into the 'changed dataframe'. I tried transpose function.but then i cant able to plot that dataframe.

Kennet Celeste Over a year ago

@ManafMh you may also "Accept" an answer when it fully answers your question

Kennet Celeste Over a year ago

@ManafMh no I mean if the answer addresses your question accept it by clicking on the check mark like this so that others notice it will work in the first look.

Collectives™ on Stack Overflow

plot graph from python dataframe

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related