How to merge different data frames which include both identical and different row and column names

Question

Here is the example:

Sample data frame 1:

Sample data frame 1

Sample data frame 2:

Sample data frame 2

The output data frame should be something like this:

The output data frame

Max() of similar terms should be considered if the row - column value is repeating in data frames.

Can anyone help me with this?

Images dont help with reproducing your code. Please add code snippets instead. — Ishwar Venugopal
– Ishwar Venugopal, Commented Feb 12, 2021 at 10:54

Aravind Madhwa · Accepted Answer · 2021-02-17 04:26:37Z

Thankyou for the Help @Vignesh

pd.concat([df_A, df_B], axis=0).fillna(0).groupby('col').max() gives the required result

Bob · Accepted Answer · 2021-02-12 08:19:17Z

I think you can use pd.concat for this.

2 Answers 2