Filter in python

Asked Oct 10 '21 at 06:05

Active Oct 10 '21 at 06:36

Viewed 24 times

I came accross to this python exercise with df as following:

   text_A             text_B 

0 LOVE it          love. it 
1 Make. It. Nice   make. it. (nice) 
2 Just do it       you can make it 
3 Just do it       you can make it

When i used this code : df[df.text_B == "love. It"], it will return as what I expected:

   text_A             text_B 

0 LOVE it          love. it

But, what if I want to filter the df based on column 'textB' values so that it will only return rows that have 'love. it' and 'make. it. (nice)' in the new df?

   text_A             text_B 

0 LOVE it          love. it 
1 Make. It. Nice   make. it. (nice)

I used df[df.text_B == "love. it|make. it. (nice)"], but it doesn't work, i think it has to do with the '(nice)'.

Any ideas to fix this problem?

Thank you in advance!

edited Oct 10 '21 at 06:36

asked Oct 10 '21 at 06:05

Tristan

1

You almost got it `df[df.text_B == "love. It" | df.text_B == "make. it. (nice)"]` – Ch3steR Oct 10 '21 at 06:09
You can also use: `df[df.text_B.isin(['love. it', 'make. it. (nice)'])]` – Muhammad Hassan Oct 10 '21 at 06:12
Take care of case: `"love. It"` is not the same as `"love. it"` – Corralien Oct 10 '21 at 06:13
Thanks all! @Ch3steR, i tried the suggested code in jupyter notebook but it gives me this error message:TypeError: Cannot perform 'ror_' with a dtyped [object] array and scalar of type [bool]. – Tristan Oct 10 '21 at 06:38
@Muhammad Hassan, the code only displays row for 'make. it. (nice)' not both. – Tristan Oct 10 '21 at 06:45
@Corralien, typo on my end, sorry. – Tristan Oct 10 '21 at 06:45
1

@MuhammadHassan, it works, earlier it did not work because of the typo. Thanks! – Tristan Oct 10 '21 at 06:49

Filter in python

0 Answers0