Python Forum
Match two data sets based on item values
Thread Rating:
  • 1 Vote(s) - 4 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Match two data sets based on item values
#1
I have two data frames, which i want to combine usinga left join or similar.
PV number wise subtotal of the amount column of the dataframe (Pmt) has to be match with the second table (BankWithdrawal).
If such sub total matches then join that row of second table with the relevant first table rows. Resultant table with the other two tables attached.

Get the sub totals in PVNo wise from Pmt dataframe
subtotal=pmt[["PVNo.","Amount"]].groupby('PVNo.').sum()
Great if someone can help me to achive the resultant table.

Attached Files

.xlsx   Pmt.xlsx (Size: 8.5 KB / Downloads: 84)
.xlsx   BankWithdrawal.xlsx (Size: 8.19 KB / Downloads: 102)
.xlsx   ResultCombined.xlsx (Size: 8.66 KB / Downloads: 78)
Reply


Messages In This Thread
Match two data sets based on item values - by klllmmm - Mar-28-2017, 06:44 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Supervised learning, tree based model - problems splitting data Pixel 0 667 May-16-2023, 05:25 PM
Last Post: Pixel
  Grouping Data based on 30% bracket purnima1 0 955 Feb-16-2023, 07:14 PM
Last Post: purnima1
  Make unique id in vectorized way based on text data column with similarity scoring ill8 0 889 Dec-12-2022, 03:22 AM
Last Post: ill8
  replace sets of values in an array without using loops paul18fr 7 1,716 Jun-20-2022, 08:15 PM
Last Post: paul18fr
  Data sets comparison Fraetos 0 1,415 Sep-14-2021, 06:45 AM
Last Post: Fraetos
  update values in one dataframe based on another dataframe - Pandas iliasb 2 9,255 Aug-14-2021, 12:38 PM
Last Post: jefsummers
  Pandas Data frame column condition check based on length of the value aditi06 1 2,692 Jul-28-2021, 11:08 AM
Last Post: jefsummers
  Mann Whitney U-test on several data sets rybina 2 2,094 Jan-05-2021, 03:08 PM
Last Post: rybina
  Dropping Rows From A Data Frame Based On A Variable JoeDainton123 1 2,218 Aug-03-2020, 02:05 AM
Last Post: scidam
  Filter data based on a value from another dataframe column and create a file using lo pawanmtm 1 4,282 Jul-15-2020, 06:20 PM
Last Post: pawanmtm

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020