/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

0 vote327 views1 answer
Saree
Python
0 vote360 views1 answer
Add variable in text python
Python
0 vote333 views1 answer
Dir template
Python
0 vote336 views2 answers
How to download file in python
Python
0 vote360 views1 answer
How to loop through pages of pdf using python
Python
3 votes362 views2 answers
Np load csv
Python
71 votes285 views1 answer
Small python projects for beginners
Python
5 votes359 views2 answers
TypeError: sequence item 0: expected str instance, int found
Python
0 vote334 views1 answer
Colorbar font size python
Python
3 votes327 views1 answer
How to close the window in pygame
Python