Pandas中的SQL "WHERE IN“等效项

import pandas as pd

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

# 使用isin()方法筛选数据
selected_data = df[df['City'].isin(['Paris', 'London'])]

print(selected_data)

      Name  Age    City
1      Bob   30   Paris
2  Charlie   35  London