I want to plot changes in monthly values from dataset spanning over few years with matplot.pylib, pandas
It is much easier if you split Year/month columns to separate series for each year import pandas as pd import matplotlib.pyplot as plt fig, axes = plt.subplots(figsize=(6,4)) df = pd.read_csv(“data.csv”) df2 = pd.pivot_table(df, index=”Month”, columns=[“Year”]) df2 = df2.reindex([‘January’, ‘February’, ‘March’, ‘April’, ‘May’, ‘July’, ‘August’, ‘September’, ‘October’, ‘November’, ‘December’]) df2.plot(ax=axes) fig.savefig(“plot.png”)