/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

1 vote311 views1 answer
How to find range of dates in between two dates unsing python
Python
2 votes370 views2 answers
Python selenium full screen
Python
0 vote315 views1 answer
Ignore nil rows value in openpyxl
Python
0 vote367 views1 answer
Python wifi moudel [WinError 2] The system cannot find the file specified
Python
0 vote330 views1 answer
Python input text in file
Python
22 votes317 views1 answer
Python test if number in string
Python
0 vote319 views1 answer
How to convert into grayscale opencv
Python
0 vote334 views1 answer
How to get csv file first row first column value in python
Python
0 vote356 views1 answer
Machine earning to predict sentimentanalysis python
Python
0 vote380 views1 answer
Python how to get current line number
Python