Column Date(INDEX?) pandas can not be set as y in matplot

Question

my simple code:

import pandas as pd
df = pd.DataFrame('data')

print(type(df))
print(df.columns)
print(df.head())

output:

<class 'pandas.core.frame.DataFrame'>
Index(['Value'], dtype='object')
             Value
Date              
2010-03-31  965.95
2010-04-01  974.99
2010-04-06  963.82
2010-04-07  968.23
2010-04-08  972.51

my question is, how can i access Date column? I would like to use it for matplot Y axis:

from matplotlib import pyplot as plt

plt.scatter(x, y = df['Date']))

The problem is, I can't access it. Thanks

Scott Boston · Accepted Answer · 2017-05-16 16:57:24Z

2

Let's try:

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

plt.scatter(df['Value'],df.index)

answered May 16, 2017 at 16:57

Scott Boston

154k15 gold badges160 silver badges207 bronze badges

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

Collectives™ on Stack Overflow

Column Date(INDEX?) pandas can not be set as y in matplot

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related