Pandas Plot: scatter plot with index

Question

I am trying to create a scatter plot from pandas dataframe, and I dont want to use matplotlib plt for it. Following is the script

df:
group people value
   1    5    100
   2    2    90
   1    10   80
   2    20   40
   1    7    10

I want to create a scatter plot with index on x axis, only using pandas datframe

df.plot.scatter(x = df.index, y = df.value)

it gives me an error

Int64Index([0, 1, 2, 3, 4], dtype='int64') not in index

I dont want to use

plt.scatter(x = df.index, y = df.value)

how to perfom this plot with pandas dataframe

Try df.plot.scatter(x = df.index.tolist(), y = df.value) – Sheldore Mar 14 '19 at 18:35 — Sheldore, Mar 14 '19 at 18:35

score 15 · Answer 1 · answered Mar 14 '19 at 18:29

15

You can try and use:

df.reset_index().plot.scatter(x = 'index', y = 'value')

answered Mar 14 '19 at 18:29

anky

74,114
11
41
70

score 2 · Answer 2 · answered Mar 14 '19 at 18:34

You are mixing two styles, matplotlib and the pandas interface to it. Either do it like @anky_91 suggested in their answer, or use matplotlib directly:

import matplotlib.pyplot as plt

plt.scatter(df.index, df.value)
plt.xlabel("index")
plt.ylabel("value")
plt.show()

Pandas Plot: scatter plot with index

2 Answers2