scatter plot pandas one variable on x axis and y axis is dataframe index

Question

I want to make a scatter plot in pandas the x axis is the mean and the y axis should be the index of data frame , but I couldn't proceed this is my code I got a lot of errors .

y=list(range(len(df.index)))    
df.plot(kind='scatter', x='meandf', y  )    
error : SyntaxError: positional argument follows keyword argument

The error is essentially saying it doesn't know what to do with the variable `y` after you've used keyword args. Try the following: `df.plot(kind='scatter', x='meandf', y=y )` — Andrew L, May 28 '17 at 19:37
Thanks , Now I got another error :IndexError: indices are out-of-bounds — sunny, May 28 '17 at 19:46

Andrew L · Accepted Answer · 2017-05-28T20:24:42.853

2

Try the following:

y=list(range(len(df.index)))

df.meandf.plot(x='meandf', y=y)

Or more concisely since you're plotting a Series:

df.meandf.plot(y=y)

If you need to maintain kind = 'scatter' you'll need to pass a dataframe:

df['y'] = y # create y column for the list you created
df.plot(x='a', y='y', kind='scatter', marker='.')
df.drop('y', axis=1, inplace=True)

edited May 28 '17 at 20:24

answered May 28 '17 at 19:55

Andrew L

6,618
3
26
30

Thanks, it's working well, another question if I want to have a dot for each point, I have to put kind=' ' ? – sunny May 28 '17 at 20:12
@sunny Also added note realizing you were intentionally using `kind='scatter'`. See edits now. – Andrew L May 28 '17 at 20:25
1

Thanks ! It's very well. – sunny May 28 '17 at 20:44

scatter plot pandas one variable on x axis and y axis is dataframe index

1 Answers1