1

I am visualizing my data in bar, column, line and scatter chart using matplotlib for the first time. I am getting an error whenever I am mentioning the x and y axis. Here is my code below for all charts,

df.plot.bar(pd.DatetimeIndex(df['date']), y=df[value])
df.plot.bar(pd.DatetimeIndex(df['date']), y=df[value])
df.plot.line(pd.DatetimeIndex(df['date']), y=df[value])
df.plot.scatter(x=pd.DatetimeIndex(df['date']), y=df[value])
plt.show()

I have found similar issue in datetime index KeyError: 'the label [2000-01-03 00:00:00] is not in the [index]'. But it is not solving my problem.

Mahbub
  • 317
  • 2
  • 9
  • 27
  • You're not meant to give the complete data to the `x` and `y` arguments, but the names of the columns you want to use. Else you might want to use matplotlib directly, `plt.plot()` or `plt.bar()` – ImportanceOfBeingErnest Mar 22 '19 at 02:57
  • Thanks, I know it. But I need to mention it for more uses in future. I mean my x axis will always refer date column, but y-axis will be changed. – Mahbub Mar 22 '19 at 07:42

1 Answers1

0

I found my mistake what I did. I need to define the x and y axis by the column name without mentioning like df['date']. However, I have visualized the scatter plot using scatter_matrix. So the workable code is,

df.plot.bar(pd.DatetimeIndex(x='date', y='value')
df.plot.bar(pd.DatetimeIndex(x='date', y='value')
df.plot.line(pd.DatetimeIndex(x='date', y='value')
scatter_matrix(df, alpha=0.2, figsize=(6, 6), diagonal='kde')
plt.show()
Mahbub
  • 317
  • 2
  • 9
  • 27