/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

4 votes176 views1 answer
Python unlist flatten nested lists
Python
0 vote213 views1 answer
Sorts this RDD by the given keyfunc
Python
0 vote170 views1 answer
Python set workspace dir
Python
0 vote182 views1 answer
Screen.blit() arguments
Python
0 vote174 views1 answer
Pandas replace zero with blank
Python
0 vote136 views1 answer
Flask restful api post example
Python
0 vote182 views1 answer
Created by and updated by in django
Python
0 vote171 views1 answer
Python how to turn a word into a list
Python
0 vote205 views1 answer
Run python script from repl
Python
31 votes166 views5 answers
How to loop through files in a directory python
Python