Iterate over queried dataframe (Pandas)

Asked May 11 '20 at 22:12

Active May 11 '20 at 22:49

Viewed 44 times

I'm trying to iterate over a queried Pandas dataframe: Column=ORIG_FID. So for every ORIG_FID (0, 1,2,...) I have two rows of (x,y).

Then I would like to use ax.plot(x,y) drawing a line that joins every pair of coordinates for every ORIG_FID.

So far I've tried this:

for i in df[df['ORIG_FID'].eq(i)]:
    ax.plot(df[df['x']].values.tolist()[i], df[df['y']].values.tolist()[i])

Note: Also, there is one particular dataframe that doesn't have two rows per ORIG_FID (it can have 2, 3 or whatever number of rows) but the idea is the same, I'd like to plot straight lines for every coordinate in every ORIG_FID value. Thanks in advance.

edited May 11 '20 at 22:49

asked May 11 '20 at 22:12

Juan Sebastián Osorno Bolívar

1

Please provide sample input and expected output data according to [How to make good pandas examples](https://stackoverflow.com/questions/20109391/how-to-make-good-reproducible-pandas-examples) to make a [mcve] – G. Anderson May 11 '20 at 22:26
there is something wrong in this line "for i in df[df['ORIG_FID'].eq(i)]:" "i" is repeated in the statement of the for loop – Mazziotti Raffaele May 11 '20 at 22:30
Check sample input image. Expected output data: ax.plot(x, y) for (x,y)-pair in every ORIG_FID. – Juan Sebastián Osorno Bolívar May 11 '20 at 22:52

Iterate over queried dataframe (Pandas)

0 Answers0