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
#3
(Mar-28-2017, 07:35 PM)Larz60+ Wrote: what are you summing? there are no numbers here
show a run-able snippet of code

Thanks for your interest.

I'm not sure how to add data frames to this post. So i have attached 'pmt' dataframe & 'withdrawal' dataframe.

I'm taking the subtotal of Amount column for each value in 'PVno' column.

Now i have to match the amounts resulted in above with the 'B.amount' column in 'withdrawal' dataframe & make a combined dataframe.

Expected dataframe (Resultcombined) is also attached.
Reply


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

Possibly Related Threads…
Thread Author Replies Views Last Post
  Supervised learning, tree based model - problems splitting data Pixel 0 673 May-16-2023, 05:25 PM
Last Post: Pixel
  Grouping Data based on 30% bracket purnima1 0 961 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 898 Dec-12-2022, 03:22 AM
Last Post: ill8
  replace sets of values in an array without using loops paul18fr 7 1,754 Jun-20-2022, 08:15 PM
Last Post: paul18fr
  Data sets comparison Fraetos 0 1,423 Sep-14-2021, 06:45 AM
Last Post: Fraetos
  update values in one dataframe based on another dataframe - Pandas iliasb 2 9,327 Aug-14-2021, 12:38 PM
Last Post: jefsummers
  Pandas Data frame column condition check based on length of the value aditi06 1 2,706 Jul-28-2021, 11:08 AM
Last Post: jefsummers
  Mann Whitney U-test on several data sets rybina 2 2,114 Jan-05-2021, 03:08 PM
Last Post: rybina
  Dropping Rows From A Data Frame Based On A Variable JoeDainton123 1 2,237 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,296 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