/Python/Replace nan in pandas column with mode and printing it

Replace nan in pandas column with mode and printing it

def exercise4(df):
    df1 = df.select_dtypes(np.number)
    df2 = df.select_dtypes(exclude = 'float')
    mode = df2.mode()
    df3 = df1.fillna(df.mean())
    df4 = df2.fillna(mode.iloc[0,:])
    new_df = [df3,df4]
    df5 = pd.concat(new_df,axis=1)
    new_cols = list(df.columns)
    df6 = df5[new_cols]
    return df6

Source: stackoverflow.com

Similar codes

2 votes189 views3 answers
Django queryset to list
Python Django
0 vote107 views1 answer
Python image layers
Python
1 vote118 views1 answer
Ipython save session
Python
0 vote134 views1 answer
"api_view" is not defined django
Python Django
8 votes111 views3 answers
Linear search python
Python
0 vote106 views1 answer
B'string' python
Python
0 vote130 views1 answer
Plt text verticalalignment
Python
0 vote127 views1 answer
Check substring frequency in a text python
Python
0 vote117 views1 answer
Catch error in mongo query python
Python
17 votes126 views5 answers
Convert numpy array to tensor
Python