pandas - How do I access row in a dataframe by row Index

Question

I have a dataframe with 5 rows on which I am doing some validations. If the row does not pass validation, I am adding it to a second dataframe named ValidationFailedDataFrame.

It is OK for the first validation but for the second validation, I want to check if the particular row is already added to the ValidationFailedDataFrame or not and if it is, I want to grab that row and append the error message.

This is how my ValidationFailedDataFrame looks like:

As you can see in the picture, the row that failed the validation was 4th row in the original DataFrame.

How do I query ValidationFailedDataFrame saying give me 4th row of Original DataFrame if you have?

Is it necessary to make dataframe u can also use dictionary help in finding is the row exist or not — Rahim Khalid
– Rahim Khalid, Commented Jul 10, 2017 at 20:07
I would like to keep it dataframe as there are many other things I need to do on the ValidationFailedDataFrame — Asdfg
– Asdfg, Commented Jul 10, 2017 at 20:10
Possible duplicate of Pandas select row of data frame by integer index — cs95
– cs95, Commented Jul 10, 2017 at 20:12
df.iloc[3].tolist() gives me out-of-bound error as there is only one row in the dataframe. df.iloc[0].tolist() works but I would like to access it with df.iloc[4].tolist() — Asdfg
– Asdfg, Commented Jul 10, 2017 at 20:14

Asdfg · Accepted Answer · 2017-07-10 20:28:57Z

1

Got it.

ValidationFailedDataFrame.query('index == 4')

OR

ValidationFailedDataFrame.loc[[4]]

answered Jul 10, 2017 at 20:28

Asdfg

12.4k26 gold badges110 silver badges188 bronze badges

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

Collectives™ on Stack Overflow

pandas - How do I access row in a dataframe by row Index

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related