Element-wise mathematical operations in multiple pandas dataframe

Question

I have two dataframes with similar structure like follows:

df0
No. Name    PropNO  PropAmt
1   XYZ     -       - 
2   ABC     1077    34.90
3   GHI     -       - 
    Total   1077    34.90

df1
No. Name    PropNO  PropAmt
1   XYZ     2       0.6 
2   ABC     23      0.1
3   GHI     5       0.3 
    Total   30      1.0

I want output like:

No. Name    PropNO  PropAmt
1   XYZ     2       0.6 
2   ABC     1100    35.0
3   GHI     5       0.3 
    Total   1107    35.9

I have .add() but it also merge the Name column as well. Is there a better way to do it?

jezrael · Accepted Answer · 2021-06-23 12:06:08Z

0

Use concat with aggregate sum:

dfs = [df1, df2]
#if necessary
#dfs = [df.replace('-', np.nan) for df in dfs]
df = pd.concat(dfs).groupby('Name', as_index=False).sum()

answered Jun 23, 2021 at 12:06

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Subbu VidyaSekar · Accepted Answer · 2021-06-23 12:06:18Z

0

Use this method:

pd.concat([df1, df2]).groupby(['Name']).sum().reset_index()

answered Jun 23, 2021 at 12:06

Subbu VidyaSekar

2,6413 gold badges26 silver badges45 bronze badges

Collectives™ on Stack Overflow

Element-wise mathematical operations in multiple pandas dataframe

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related