Pandas: filling missing values with another column Currently the dataframe is: Val1 Val2 Cambridge MA NAN FL Washington DC Washington NAN Miami FL NAN DC Washington DC Miami FL The desired output is: Val1 Val2 Cambridge MA Miami FL Washington DC Washington DC Miami FL Washington DC Washington DC Miami FL Thanks

Reputation: 101

Pandas: filling missing values with another column

Currently the dataframe is:

The desired output is:

Thanks

Upvotes: -1

Reputation: 81

Hope this helps:

df['Val1'] = df.groupby('Val2').bfill().ffill()
df['Val2'] = df.groupby('Val1').bfill().ffill()

Upvotes: 1