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   how  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  Thanks in advance

User · Answer

Try this   monthly mean plot y  A   use index True

User · Answer

monthly mean plot y  A    Uses index as x-axis by default

User · Answer

You can use reset index to turn the index back into a column   monthly mean reset index   plot x  index   y  A

User · Answer

Marius s answer worked perfectly for me  df reset index   sets the index as the first column  with the column label  quot index  quot  You can now use the index as an axis for plotting  as described in his answer  monthly mean reset index   plot x  index   y  A    However  this does not change the original dataframe  The original dataframe will be unchanged unless it is set using df   df reset index    example  df reset index   print df           COF    TSF    PSF 3 0   0 946  0 914  0 966 4 0   0 963  0 940  0 976 6 0   0 978  0 965  0 987 8 0   0 989  0 984  0 995 10 0  1 000  1 000  1 000 12 0  1 004  1 013  1 009 15 0  1 013  1 026  1 012 17 0  1 019  1 037  1 017 20 0  1 024  1 045  1 020 25 0  1 030  1 057  1 026 30 0  1 034  1 065  1 030 35 0  1 037  1 069  1 031 40 0  1 037  1 068  1 030 60 0  1 037  1 068  1 030  df   df reset index   print df       index    COF    TSF    PSF 0     3 0  0 946  0 914  0 966 1     4 0  0 963  0 940  0 976 2     6 0  0 978  0 965  0 987 3     8 0  0 989  0 984  0 995 4    10 0  1 000  1 000  1 000 5    12 0  1 004  1 013  1 009 6    15 0  1 013  1 026  1 012 7    17 0  1 019  1 037  1 017 8    20 0  1 024  1 045  1 020 9    25 0  1 030  1 057  1 026 10   30 0  1 034  1 065  1 030 11   35 0  1 037  1 069  1 031 12   40 0  1 037  1 068  1 030 13   60 0  1 037  1 068  1 030  See  DataFrame reset index and  DataFrame set index

User · Answer

Also   monthly mean plot x df index  y  A

[python] Use index in pandas to plot data

Examples related to python

Examples related to pandas