Plotting Time Series using pandas

Question

I have a .csv file containing time series data with headers like Description, Date and Values. I am looking to make a line graph for this time series in such that 'Values' are in Y-axis and 'Date' in X-axis.

Sample data below:

Description     Date     Values
AGN_MXN_360     20190131   4.134
AGN_MXN_360     20190201   3.00
AGN_MXN_360     20190205   7.68
AGN_MXN_360     20190206   3.25
....
....
....
AGN_MXN_360     20190920   3.7941

It should look like the below:

Possible duplicate of Pandas: plot multiple time series DataFrame into a single plot — pissall
– pissall, Commented Sep 20, 2019 at 10:42

SCool · Accepted Answer · 2019-09-20 12:25:19Z

3

Try set your date columns as the index, then plot the values column.

import pandas as pd

# import the csv file
df = pd.read_csv('mycsvfile.csv')

# make sure the time column is actually time format
df['Date']=pd.to_datetime(df['Date'])

# set time as the index
df.set_index('Date',inplace=True)

# plot
df['values'].plot()

edited Sep 20, 2019 at 12:25

answered Sep 20, 2019 at 11:09

SCool

3,4366 gold badges31 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user12010260 Over a year ago

Thank you so much. Apologies but I am an apprentice for this. I used the above code and it seems like "undefined name df" does exist

SCool Over a year ago

Then instead of df put the name of your dataframe. For example if your dataframe is called hello replace df with hello.

Collectives™ on Stack Overflow

Plotting Time Series using pandas

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related