Pandas 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

Dataframe fillna with 0

df['column'] = df['column'].fillna(0)

Pandas fillna with mode

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

Source: stackoverflow.com

Similar codes

1 vote278 views1 answer
Convert arrary to int
Python
0 vote287 views1 answer
How to instal django cities
Python Django
0 vote253 views2 answers
Pdf to word
Python
-2 votes258 views1 answer
What is xbox live called now
Python
0 vote248 views1 answer
Append to a ldictionary value list
Python
24 votes293 views6 answers
How to save a pickle file
Python
9 votes260 views2 answers
Run linux command using python
Python
0 vote251 views1 answer
Can i change color of text in jupyter notebook
Python
0 vote263 views1 answer
Scrapy get raw html content of selector innerhtml
Python
1 vote282 views4 answers
Tkinter icon
Python