Plotting using Pandas and datetime format

EDIT 2 after seeing more people ending up here. To be clear for new people to python, you should first import pandas for the codes bellow to work:

import pandas as pd

EDIT 1: (short quick answer)

If³ you don't want to drop your original index (this makes sense after reading the original and long answer bellow) you could:

df[['Date','ClosingPrice']].plot('Date', figsize=(15,8))

Original and long answer:

Try setting your index as your Datetime column first:

df.set_index('Date', inplace=True, drop=True)

Just to be sure, try setting the index dtype (edit: this probably wont be needed as you did it previously):

df.index = pd.to_datetime(df.index)

And then plot it

df.plot()

If this solves the issue it's because when you use the .plot() from DataFrame object, the X axis will automatically be the DataFrame's index.

If² your DataFrame had a Datetimeindex and 2 other columns (say ['Currency','pct_change_1']) and you wanted to plot just one of them (maybe pct_change_1) you could:

# single [ ] transforms the column into series, double [[ ]] into DataFrame
df[['pct_change_1']].plot(figsize=(15,8)) 

Where figsize=(15,8) you're setting the size of the plot (width, height).