Python -根据条件和查询构建pandas数据框的列

import pandas as pd

df = pd.DataFrame()

condition = (df['age'] >= 18) & (df['gender'] == 'female')

df['new_column'] = np.where(condition, 'True', 'False')

import pandas as pd
import numpy as np

# 创建一个空的数据框
df = pd.DataFrame()

# 假设已有age和gender两列数据
df['age'] = [15, 20, 25, 30, 35]
df['gender'] = ['male', 'female', 'female', 'male', 'female']

# 定义条件和查询
condition = (df['age'] >= 18) & (df['gender'] == 'female')

# 根据条件和查询构建新的列
df['new_column'] = np.where(condition, 'True', 'False')

# 打印输出数据框
print(df)

   age  gender new_column
0   15    male      False
1   20  female       True
2   25  female       True
3   30    male      False
4   35  female       True