Pandas: select row if value is included in a predefined list

Asked Jan 18 '22 at 15:09

Active Jan 18 '22 at 15:09

Viewed 12 times

I want to solve a issue WITHOUT a for-loop. I have a a list keys which contains multiple strings. In the example 2 but inreality multiple hundreds. And I want to select all rows of df for which the value of df["a]" is included in keys.

keys = ["z","x"]
df =pd.DataFrame({"a": ["z", "y", "x"],
              "b": [15,85,23]})

I could write a for-loop which check for every row whether df.a.iloc[i] in keys but ther must be a way to directly index this. So what I am looking for is something along the lines of

df[df.a in keys]

which does not work.

asked Jan 18 '22 at 15:09

Janosch

`df[df['a'].isin(keys)]` – mozway Jan 18 '22 at 15:10
```isin``` instead of ```in``` – sophocles Jan 18 '22 at 15:11
Yeah thanks. I was so close yet sofar – Janosch Jan 18 '22 at 15:49

Pandas: select row if value is included in a predefined list

0 Answers0