pandas.csv中的问题:如何将male和female两列的数据处理后生成新的一列gender 并分别返回整理后男性女性的行信息

Question

Answer 1

import pandas as pd
df1 = pd.read_csv("testgender.csv")
print(df1.head())
df1['gender'] = df1.apply(lambda x: 'Male' if x.male == 1 and x.female == 0 else  'Female' if  x.male == 0 and x.female == 1 else 'NA', axis=1)
print(df1.head())