How to iterate over the rows

Question

I want to iterate over the column "Name" which should have only "ROSE" and the next column should be "Fail" and should extract the column "places" corresponding to the FAIL and ROSE.

INPUT

Output :

OUTPUT

[How to make good reproducible pandas examples](https://stackoverflow.com/questions/20109391/how-to-make-good-reproducible-pandas-examples) — It_is_Chris, Jun 08 '21 at 14:53
@AnuragDabas I need to fecth the corresponding places as well — Gayathri K, Jun 08 '21 at 14:56
what do you mean by *'I need to fetch the corresponding places as well'*? — Anurag Dabas, Jun 08 '21 at 15:02
@AnuragDabas in this example I have to fetch only INDIA and USA. The name is ROSE and the condition is FALSE so I have to fetch the corresponding place. Pls look into the output snapshot once — Gayathri K, Jun 08 '21 at 15:04
try: `cond=(df['Name']=='Rose') & (df['Condition']=='Fail') & df['Place'].isin(['USA','India'])` finally `df[cond]` or `df.loc[cond]` — Anurag Dabas, Jun 08 '21 at 15:08
@AnuragDabas It can be anything X, Y , Z .. Not just USA , INDIA. based on the condition of column "Condition as FAIL" the corresponding value from the place column has be to fetched — Gayathri K, Jun 08 '21 at 15:14
have a look on the previous comment and read this line *I have to fetch only INDIA and USA* — Anurag Dabas, Jun 08 '21 at 15:26
@AnuragDabas The values in column "Place" is not constant.. It keeps changing — Gayathri K, Jun 08 '21 at 15:37

YuserT · Accepted Answer · 2021-06-08T15:18:11.673

0

df[(df["Name"] == "Rose") & (df["Condition"] == "Fail")]

Output

   Name   Status  Place
0  Rose     Fail  India
1  Rose     Fail    USA
2  Rose     Fail      X

To fetch only Place column as a list

df[(df["Name"] == "Rose") & (df["Condition"] == "Fail")]["Place"].tolist()

Output

   ['India', 'USA', 'X']

edited Jun 08 '21 at 15:18

answered Jun 08 '21 at 14:57

YuserT

16
2

The corresponding Places also has to be fetched – Gayathri K Jun 08 '21 at 14:58
Do you mean, you would like to have as output a list [India, USA] ? – YuserT Jun 08 '21 at 15:12
Based on the condition of ROSE , FAIL ... its corresponding value in the same row in the place column has to be fetched. It can be anything .. x,y.. not just india , usa.. – Gayathri K Jun 08 '21 at 15:16
1

The code above returns the PLACE column values (which can be anything not just india or usa) for the rows satisfying the (Rose and Fail) condition. – YuserT Jun 08 '21 at 15:19
Please accept my answer if it answered your question (https://stackoverflow.com/help/someone-answers) – YuserT Jun 08 '21 at 15:30
Thank You very much. – Gayathri K Jun 08 '21 at 15:43
Hey what if I am getting the Name column from the user. "Rose" should be from user input. all other things are same. @YuserT – Gayathri K Jun 09 '21 at 02:58
A code snippet of how you are getting the Name column from the user would be useful. – YuserT Jun 09 '21 at 08:13

How to iterate over the rows

1 Answers1