用pandas对数据表中的数据进行更新,这里推荐一个掩膜处理,具体代码如下
dataFieldAll['E'] = 0
dataFieldValGood = dataFieldVal[dataFieldVal[fieldIndex]<0.8)]
dataFieldValGood['N']=1
# print('dataFieldValGood',dataFieldValGood.shape[0])
dataFieldAll = pd.merge(dataFieldAll, dataFieldValGood, how='left')
# print(dataFieldVal)
nanMask = pd.isna(dataFieldAll['N'])
# print(nanMask)
dataFieldAll.loc[~nanMask, 'E'] = np.int64(dataFieldAll.loc[~nanMask, 'N'])