def checkFSXvalsAgainstADNIMERGE(tadpoleDF, mriADNI1FileFSX, otherSSvisCodeStr, ssNameTag,
ignoreMissingCols = False):
nrRows, nrCols = tadpoleDF.shape
colListOtherSS = list(ssDF.columns.values)
colListTadpoleDF = list(tadpoleDF.columns.values)
tadpoleDF[['Hippocampus', 'ST29SV%s' % ssNameTag, 'ST88SV%s' % ssNameTag]] = \
tadpoleDF[['Hippocampus', 'ST29SV%s' % ssNameTag, 'ST88SV%s' % ssNameTag]].apply(pd.to_numeric, errors='coerce')
tadpoleDF['HIPPOSUM'] = tadpoleDF['ST29SV%s' % ssNameTag] + tadpoleDF['ST88SV%s' % ssNameTag]
for r in range(nrRows):
valsNan = np.isnan(tadpoleDF['Hippocampus'][r]) or (np.isnan(tadpoleDF['ST29SV%s' % ssNameTag][r]) and \
np.isnan(tadpoleDF['ST88SV%s' % ssNameTag][r]))
if valsNan:
continue
valsNotEq = tadpoleDF['Hippocampus'][r] != (tadpoleDF['ST29SV%s' % ssNameTag][r] + tadpoleDF['ST88SV%s' % ssNameTag][r])
if valsNotEq:
print('entries dont match\n ', tadpoleDF[['RID','VISCODE', 'Hippocampus', 'ST29SV%s' % ssNameTag,\
'ST88SV%s' % ssNameTag, 'HIPPOSUM']].iloc[r])
# Conclusion: the reason why entries above don't match is because UCSFFSX has duplicate entries for the same subject and viscode.
评论列表
文章目录