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

0 vote291 views1 answer
TypeError: unhashable type: 'list' drop duplicates
Python
0 vote301 views1 answer
Qmenubar pyqt
Python
0 vote286 views1 answer
Pytorch rolling window
Python
0 vote319 views2 answers
Generate random token or id in django
Python Django
1 vote292 views1 answer
Get only first 10 columns pandas
Python
0 vote320 views1 answer
Mylist = [“hello”, “bye”,”see ya”,”later”] phrase = mylist[1]
Python
7 votes261 views1 answer
Program python factorial
Python
1 vote281 views1 answer
Python string math
Python
0 vote304 views1 answer
Can only concatenate str (not "ImageFieldFile") to str
Python
8 votes276 views3 answers
Data type
Python