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
You can do SQL-like joins on pandas dataframes with pandas.merge()
merged_dataframe = pd.merge(subtotal_dataframe, bankwithdrawal_dataframe)
You can specify what type of join with parameter how=, default is 'inner'; on default it uses common columns as keys for join, but you can specify it with on= parameter (or with left_on and right_on= if your keys are different).

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

Possibly Related Threads…
Thread Author Replies Views Last Post
  replace sets of values in an array without using loops paul18fr 7 669 Jun-20-2022, 08:15 PM
Last Post: paul18fr
  Data sets comparison Fraetos 0 876 Sep-14-2021, 06:45 AM
Last Post: Fraetos
  update values in one dataframe based on another dataframe - Pandas iliasb 2 5,928 Aug-14-2021, 12:38 PM
Last Post: jefsummers
  Pandas Data frame column condition check based on length of the value aditi06 1 1,744 Jul-28-2021, 11:08 AM
Last Post: jefsummers
  Mann Whitney U-test on several data sets rybina 2 1,412 Jan-05-2021, 03:08 PM
Last Post: rybina
  Dropping Rows From A Data Frame Based On A Variable JoeDainton123 1 1,581 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 3,482 Jul-15-2020, 06:20 PM
Last Post: pawanmtm
  Least-squares fit multiple data sets multiverse22 1 1,782 Jun-06-2020, 01:38 AM
Last Post: Larz60+
  Identifying consecutive masked values in a 3D data array chai0404 12 4,153 Feb-01-2020, 12:59 PM
Last Post: perfringo
  Help with Data Match Theory randor 2 1,466 Dec-25-2019, 05:57 PM
Last Post: randor

Forum Jump:

User Panel Messages

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