Match two data sets based on item values

[zivoni]

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).