Month,Year with Value Plot,Pandas and MatPlotLib

Question

i have DataFrame with Month,Year and Value and i want to do a TimeSeries Plot.

Sample:

month   year    Value
12      2016    0.006437804129357764
1       2017    0.013850880792606646
2       2017    0.013330349031207292
3       2017    0.07663058273768052
4       2017    0.7822831457266424
5       2017    0.8089573099244689
6       2017    1.1634845000200715

im trying to plot this Value data with Year and Month, Year and Month in X-Axis and Value in Y-Axis.

Possible duplicate of [Plotting timestamps (hour/minute/seconds) with Matplotlib](https://stackoverflow.com/questions/17709823/plotting-timestamps-hour-minute-seconds-with-matplotlib) — gehbiszumeis, Nov 12 '18 at 09:45

score 10 · Accepted Answer · answered Nov 12 '18 at 10:01

10

One way is this:

import pandas as pd
import matplotlib.pyplot as plt

df['date'] = df['month'].map(str)+ '-' +df['year'].map(str)
df['date'] = pd.to_datetime(df['date'], format='%m-%Y').dt.strftime('%m-%Y')
fig, ax = plt.subplots()
plt.plot_date(df['date'], df['Value'])
plt.show()

answered Nov 12 '18 at 10:01

Joe

12,057
5
39
55

This is the approach i thought of doing, but didn't know about using map function. – Sriram Arvind Lakshmanakumar Nov 12 '18 at 10:18
not all the month-year is visible in the x-axis!, some are hidden, is due to the graph size? – Sriram Arvind Lakshmanakumar Nov 12 '18 at 10:53
You can try to rotate them with `plt.xticks(rotation=90)` – Joe Nov 12 '18 at 10:55
can u post the image? – Joe Nov 12 '18 at 10:59
Try adding: `positions = [p for p in df['date']]` `labels = [l for l in positions]` `ax.set_xticks(positions)` `ax.set_xticklabels(labels)` – Joe Nov 12 '18 at 11:13

score 1 · Answer 2 · answered Nov 12 '18 at 10:00

You need to set a DateTime index for pandas to properly plot the axis. A one line modification for your dataframe (assuming you don't need year and month anymore as columns and that first day of each month is correct) would do:

df.set_index(pd.to_datetime({
    'day': 1,
    'month': df.pop('month'),
    'year': df.pop('year')
}), inplace=True)

df.Value.plot()

Month,Year with Value Plot,Pandas and MatPlotLib

2 Answers2