pandas df.plot.scatter fails but df.plot produces plot

Question

I want to produce scatter plots of data from a pandas df, sample below. I can produce line plots with:

ax = df_stats.plot(x = 't', y = 't_TI_var_ws')
ax1 = ax.twinx()
df_stats.plot(x='t',y='t_TI_var_pwr',ax=ax1, color='g')

but when I try to use .scatter to plot the same data as a scatter plot I get the error KeyError: 't'

ax = df_stats.plot.scatter(x = 't', y = 't_TI_var_ws')
ax1 = ax.twinx()
df_stats.plot.scatter(x='t',y='t_TI_var_pwr',ax=ax1, color='g')

what happens if you do: df_stats.plot(x='t',y='t_TI_var_pwr',ax=ax1, color='g', kind='scatter') — YOLO
– YOLO, Commented Jan 21, 2020 at 17:21
@YOLO type('t') returns 'str', t is listed as datetime in the variable explorer — squar_o
– squar_o, Commented Jan 21, 2020 at 18:16

Saravana · Accepted Answer · 2020-01-23 15:31:09Z

1

It seems that your column to is a timestamp. To use scatter it must be a float. You can plot scatter plot with:

ax = df_stats.plot(x = 't', y='t_TI_var_pwr',style='o')

Saravana

41k20 gold badges110 silver badges112 bronze badges

answered Jan 21, 2020 at 18:56

user1885349

3921 gold badge2 silver badges11 bronze badges

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

1 Answer 1