Pandas not in index error trying a scatter plot

Question

I was trying to do a scatter plot. I was trying with the next code

df = pd.DataFrame({'$a':[1,2], '$b': [10,20]})
df.columns = ['a', 'b']
df
df.plot.scatter(df['a'], df['b'])

I get the error

KeyError: '[1 2] not in index'

Any idea why this happens?

mech · Accepted Answer · 2018-01-15 23:37:45Z

3

This line is redundant:

df.plot.scatter(df['a'], df['b'])

Since you've already called df, you only need to refer to the column heading, like so:

df.plot.scatter('a', 'b')

mech

2,9336 gold badges32 silver badges39 bronze badges

answered Jan 15, 2018 at 23:02

Mike8

615 bronze badges

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

Comments

jezrael · Accepted Answer · 2017-07-11 19:14:04Z

1

First no problem you are new in python ;)

Need parameter x and y in DataFrame.plot.scatter:

df = pd.DataFrame({'$a':[1,2], '$b': [10,20]})
df.columns = ['a', 'b']

df.plot.scatter(x = 'a', y='b')

answered Jul 11, 2017 at 19:14

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges