Python Pandas -使用.loc对多个列使用AND和OR进行选择

import pandas as pd

# 创建一个示例DataFrame
data = {'Name': ['Tom', 'Nick', 'John', 'Sam'],
        'Age': [20, 25, 30, 35],
        'City': ['New York', 'Paris', 'London', 'Tokyo']}
df = pd.DataFrame(data)

# 选择年龄大于25岁且城市为'London'的行
result = df.loc[(df['Age'] > 25) & (df['City'] == 'London')]
print(result)

  Name  Age    City
2  John   30  London

import pandas as pd

# 创建一个示例DataFrame
data = {'Name': ['Tom', 'Nick', 'John', 'Sam'],
        'Age': [20, 25, 30, 35],
        'City': ['New York', 'Paris', 'London', 'Tokyo']}
df = pd.DataFrame(data)

# 选择年龄大于25岁或城市为'London'的行
result = df.loc[(df['Age'] > 25) | (df['City'] == 'London')]
print(result)

  Name  Age      City
2  John   30    London
3   Sam   35     Tokyo