Use index in pandas to plot data

Question

I have a pandas-Dataframe and use resample() to calculate means (e.g. daily or monthly means). Here is a small example.

import pandas as pd   import numpy as np  dates = pd.date_range('1/1/2000', periods=100) df = pd.DataFrame(np.random.randn(100, 1), index=dates, columns=['A'])  monthly_mean = df.resample('M').mean() 

How do I plot the monthly_mean now?

How do I manage to use the index of my new created DataFrame monthly_mean as the x-axis?

Answer 1

Try this,

monthly_mean.plot(y='A', use_index=True)