CODEWITHSUNDEEP
pythonpandas
Rookie
Rookie

Reputation: 37

Merging two pandas data frame with common columns

I have a lower triangular matrix and then I transpose it and I have the transpose of it. I am trying to merge them together

lower triangular:

 Data : 
     0         1         2      3        
0  1         0         0        0
1  0.21      0         0        0   
2  0.31      0.32      0        0
3  0.41      0.42      0.43     0
4  0.51      0.52      0.53     0.54

transpose triangular:

 Data : 
     0         1         2      3      
0  1         0.21      0.31     0.41   
1  0         0         0.32     0.52 
2  0         0         0        0.53
3  0         0         0        0.54
4  0         0         0        0

Merged matrix:

 Data : 
     0         1         2      3      4      
0  1         0.21      0.31     0.41   0.51
1  0.21         0      0.32     0.42   0.52
2  0.31      0.32      0        0.43   0.53
3  0.41      0.42      0.43     0      0.54
4  0.51      0.52     0.53      0.54   0

I tried using pd.merge but I couldn't get it to work

Upvotes: 0

Views: 45

Answers (2)

BENY
BENY

Reputation: 323226

Let us using combine_first after mask 

df.mask(df==0).T.combine_first(df).fillna(0)
Out[1202]: 
      0     1     2     3     4
0  1.00  0.21  0.31  0.41  0.51
1  0.21  0.00  0.32  0.42  0.52
2  0.31  0.32  0.00  0.43  0.53
3  0.41  0.42  0.43  0.00  0.54
4  0.51  0.52  0.53  0.54  0.00

Upvotes: 1

RenauV
RenauV

Reputation: 383

How about just adding the two dataframes?

df3 = df1.add(df2, fill_value=0)

BR

Upvotes: 1

Related Questions