python 2.7 - Counting the columns with missing values in a pandas dataset -
i have feature set 30 columns , 100 rows , want count columns missing values. have seen csv file , there 2 rows no values under 1 column.
based on output below, shows me columns , count on how many values missing in each column.
traindata.isnull().sum(axis=0) [out:] f1 0 f2 0 f3 0 f4 0 f5 0 f6 0 f7 0 f8 0 f9 0 f10 0 f11 0 f12 0 f13 0 f14 0 f15 0 f16 0 f17 0 f18 0 f19 0 f20 0 f21 2 f22 0 f23 0 f24 0 f25 0 f26 0 f27 0 f28 0 f29 0 f30 0 dtype: int64
is there code show how many columns have missing values , specific column that? output should 1 , f21.
any appreciated. thanks!
Comments
Post a Comment