Python fillna with mode

Fill na with mode and mean python

cateogry_columns=df.select_dtypes(include=['object']).columns.tolist()
integer_columns=df.select_dtypes(include=['int64','float64']).columns.tolist()

for column in df:
    if df[column].isnull().any():
        if(column in cateogry_columns):
            df[column]=df[column].fillna(df[column].mode()[0])
        else:
            df[column]=df[column].fillna(df[column].mean)

Python fillna with mode

data['Native Country'] = data['Native Country'].fillna(data['Native Country'].mode()[0])

Source: stackoverflow.com

Similar codes

6 votes175 views2 answers
Numpy from csv
Python
0 vote183 views1 answer
How to get input from user in python with out press enter
Python
81 votes327 views10 answers
Python get current directory
Python
21 votes187 views6 answers
Python remove key from dict
Python
1 vote180 views1 answer
Save screenshot of screen in pygame
Python
0 vote189 views1 answer
Dataframe time index convert tz naive to tz aware
Python
31 votes185 views5 answers
Python day from date
Python
17 votes336 views4 answers
Flask render_template
Python Flask
37 votes175 views6 answers
If list element contains string python
Python
0 vote249 views1 answer
Python developer salary
Python