I try to retrieve for each row containing NaN values all the indices of the corresponding columns.
d=[[11.4,1.3,2.0, NaN],[11.4,1.3,NaN, NaN],[11.4,1.3,2.8, 0.7],[NaN,NaN,2.8, 0.7]]
df = pd.DataFrame(data=d, columns=['A','B','C','D'])
print df
A B C D
0 11.4 1.3 2.0 NaN
1 11.4 1.3 NaN NaN
2 11.4 1.3 2.8 0.7
3 NaN NaN 2.8 0.7
I've already done the following :
- add a column with the count of NaN for each row
- get the indices of each row containing NaN values
What I want (ideally the name of the column) is get a list like this :
[ ['D'],['C','D'],['A','B'] ]
Hope I can find a way without doing for each row the test for each column
if df.ix[i][column] == NaN:
I'm looking for a pandas way to be able to deal with my huge dataset.
Thanks in advance.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…