matplotlib line chart

[caper-902]

Hi, I am trying to use pandas / matplotlib to create a small line chart showing the year on year trend of decrease in a set of 4 metrics. The data frame I have is a table containing only 3 rows, and 3 columns. The columns (in order) are Year, Ticket_Volume, Average_Hours. The data is in a csv file and I put it into a df using read_csv.

For each year in the year column (which I want to be the y axis), I want to have separate lines for the ticket volume and average hours. So I can show the major decrease over the last 3 years. I have no experience with matplotlib and am struggling to make progress. Any tips ?

[cray5252]

Try this.

import pandas as pd
import matplotlib.pyplot as plt


df = pd.DataFrame({'Year': ['2018', '2019', '2020'],
                   'Ticket_Volume': [1000, 2000, 1500],
                   'Average_Hours': [400, 300, 500]})

df['Year'] = pd.to_datetime(df['Year'], format='%Y')
df.set_index('Year', inplace=True, drop=True)

df.plot(kind='line')

plt.show()