DataFrame某些列值替换的三种方式
通过自定义函数,对DataFrame数据的几列值进行替换。
import numpy as np
import pandas as pd
data = pd.read_csv(r'C:\Users\Administrator\Desktop\ASC_Model\service_loan.csv', encoding='gbk')
方法一
def dataprocess(data):
for columns in('EMAILADD','QQNO','WECHAT'):
data[columns] = data[columns].isnull().map({True:0,False:1})
return data
方法二
def dataprocess(data):
for col in ('EMAILADD','QQNO','WECHAT'):
data[col]=data[col].isnull()
data[col]=data[col].map({True:0,False:1})
return data
方法三
def dataprocess(data):
for col in ('EMAILADD','QQNO','WECHAT'):
data[col] = np.where(data[col].isnull(),0,1)
return data
data = dataprocess(data)
print(data[['EMAILADD','QQNO','WECHAT']].head(10))