How to search for a cell using the value and obtain the index number

Question

I have a pandas dataframe that has 4 columns. Let's say: Test_Name, Runtime, Memory, Location

I want to find all the Test_Name = 'my_test' and replace the Location value with 'my_test_location'

So, effectively, it should search for all the test_names that match my search query and in those rows, replace the location field with the string i'm giving as input.

I know i can do this by iterating over every row. I want to know if an inbuilt function exists that can do this.

Any help is appreciated.

Original Dataframe:

Find all testcases with name = 'peter' and replace location field with '/work/peter'

Final Dataframe:

`df.loc[df.Test_Name.eq('peter'),'Location']= '/work/peter'` — anky, Jun 20 '19 at 14:18
`df.loc[df['Test_Name'] == my_test, 'Location'] = my_test_location` — cs95, Jun 20 '19 at 14:18

Shivam Kotwalia · Answer 1 · 2019-06-20T14:28:21.347

1

Dude try .loc and .iloc

df.loc[df.Test_Name == "my_test", "Location"] = "my_test_location"

Adding doc for loc

edited Jun 20 '19 at 14:28

answered Jun 20 '19 at 14:18

Shivam Kotwalia

1,419
2
15
20

There's no `iloc` in your answer, Dude. – cs95 Jun 20 '19 at 14:24

How to search for a cell using the value and obtain the index number

1 Answers1