/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

24 votes136 views6 answers
Python sort dictionary by key
Python
14 votes147 views3 answers
How to get id of user discord.py
Python
0 vote141 views2 answers
Matplotlib grid in background
Python
0 vote148 views1 answer
How to calculate the variance of all columns in python
Python
5 votes131 views1 answer
Python-binance
Python
0 vote145 views1 answer
Write yaml file without deleting content
Python
-1 vote138 views1 answer
Decimal conversion python
Python
2 votes131 views2 answers
How to add time with time delta in python
Python
8 votes144 views4 answers
Check cuda version python
Python
-1 vote132 views1 answer
Python __new__
Python