Python使用OR条件筛选行

Question

我有一个数据帧，我需要根据两个条件进行筛选： 如果名字='Aleshia'或姓氏='Andrade'

我正在尝试以下代码：

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)

但我得到了以下错误：

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

我做错了什么

Answer 1

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

Answer 2

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