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

img

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())

img

删除列的问题,可以这样处理
del df1['male']
del df1['female']

UTF8 的问题
增加encoding='utf-8'
类似这样
df1 = pd.read_csv(r'jymb.csv', sep=',', encoding='utf-8')