Pandas在匹配字段上的查找

import pandas as pd

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

# 使用loc和条件语句查找满足条件的数据
result = df.loc[df['Name'] == 'Bob']

print(result)

  Name  Age   City
1  Bob   30  London

result = df.query("Name == 'Bob'")

print(result)

  Name  Age   City
1  Bob   30  London

result = df[df['Name'].isin(['Bob', 'David'])]

print(result)

    Name  Age    City
1    Bob   30  London
3  David   40   Tokyo