Jun-03-2020, 01:48 AM
Hi,
I am merging 2 dataframes (DF1 and DF2) with many to many relationships.
The merge works fine but the result duplicates the "Amount" values in every row. How can I avoid this?
[DF3 = pd.merge(DF1,DF2, on=['Project No'],how='left',suffixes=('_left','_right'))]
Any help would be great. Thanks
P.S - Not sure how to attach a sample workbook (excel)
I am merging 2 dataframes (DF1 and DF2) with many to many relationships.
The merge works fine but the result duplicates the "Amount" values in every row. How can I avoid this?
[DF3 = pd.merge(DF1,DF2, on=['Project No'],how='left',suffixes=('_left','_right'))]
Any help would be great. Thanks
P.S - Not sure how to attach a sample workbook (excel)