Python - Filtering rows using OR condition

Question

I've a dataframe and I need to make filter based on two conditions: If first_name = 'Aleshia' OR if last_name = 'Andrade'

I was trying with the code below:

import pandas as pd

df = pd.read_csv('https://s3-eu-west-1.amazonaws.com/shanebucket/downloads/uk-500.csv')
data_new = df[df.first_name == 'Aleshia' or df.last_name  == 'Andrade']
print(data_new)

But I am getting the following error:

ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().

What I am doing wrong?

`df[(df.first_name == 'Aleshia') | (df.last_name == 'Andrade')]` — It_is_Chris, Apr 09 '20 at 19:10
https://pandas.pydata.org/docs/user_guide/indexing.html?ndexing#boolean-indexing — dimitris_ps, Apr 09 '20 at 19:12

score 0 · Accepted Answer · answered Apr 09 '20 at 19:10

0

data_new = df[(df.first_name == 'Aleshia') | (df.last_name  == 'Andrade')]

answered Apr 09 '20 at 19:10

Mayank Porwal

33,470
8
37
58

It gives me this "TypeError: Cannot perform 'ror_' with a dtyped [object] array and scalar of type [bool]" – Apr 09 '20 at 19:14
I guess you are missing parantheses`()` in the command. Please check. – Mayank Porwal Apr 09 '20 at 19:17

score 0 · Answer 2 · answered Apr 09 '20 at 19:16

0

data_new = df.loc[(df.first_name == 'Aleshia') | (df.last_name  == 'Andrade'), :]

answered Apr 09 '20 at 19:16

David Smolinski

514
3
13

Python - Filtering rows using OR condition

2 Answers2