用于' and‘和'or’子句的Pandas数据帧过滤器

import pandas as pd

# 创建一个示例数据帧
data = {'Name': ['Alice', 'Bob', 'Charlie', 'David'],
        'Age': [25, 30, 35, 40],
        'City': ['New York', 'Paris', 'London', 'Tokyo']}
df = pd.DataFrame(data)

# 使用'and'子句进行过滤
filtered_df = df[(df['Age'] > 30) & (df['City'] == 'London')]
print(filtered_df)

      Name  Age    City
2  Charlie   35  London

import pandas as pd

# 创建一个示例数据帧
data = {'Name': ['Alice', 'Bob', 'Charlie', 'David'],
        'Age': [25, 30, 35, 40],
        'City': ['New York', 'Paris', 'London', 'Tokyo']}
df = pd.DataFrame(data)

# 使用'or'子句进行过滤
filtered_df = df[(df['Age'] > 30) | (df['City'] == 'Paris')]
print(filtered_df)

      Name  Age      City
1      Bob   30     Paris
2  Charlie   35    London
3    David   40     Tokyo