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 vote269 views1 answer
How to get csv file first row first column value in python
Python
53 votes268 views3 answers
Python publishing exe
Python
13 votes290 views6 answers
Django orm
Python
0 vote271 views1 answer
Pandas crosstab function(counting) frequencies
Python
5 votes252 views2 answers
How to check if text is lower in python
Python
0 vote305 views1 answer
ConversionofDatatypes-I
Python
0 vote257 views1 answer
Get the factorial of a number on python
Python
5 votes259 views1 answer
Get request body flask
Python
1 vote284 views1 answer
Task timed out after 3.00 seconds aws lambda python
Python
0 vote254 views1 answer
How to pairwise permute in python
Python