DataFrame not displaying all missing values

user_16620212 0
Viewed 173

my DataFrame has columns that have missing values. but only 4 columns show that I have missing values while other don't.

 0   Zone      15511 non-null  object   
 1   District  15511 non-null  object  
 2   id        15511 non-null  int64   
 3   Year      15511 non-null  int64   
 4   Sex       15511 non-null  object  
 5   OT        15511 non-null  object  
 6   Ext       15511 non-null  object   
 7   Irrg      15511 non-null  object   
 8   ST        15511 non-null  object    
 9   WS        15339 non-null  float64

for example OT column has missing value on my excel sheet but it does't appear to have missing values here.

what am I missing?

pandas machine-learning dataframe numpy python
1 Answers

what you can do is open the file and identify those values that represent a null value, for example an empty string you consider null but isn't actually a null object.

when you have identified those values that are representative of an absent value; you iterate through that column and test for that condition, if true replace it with a null object.

user_62426980
Related