Forum Discussion
Data Reconciliation Assistance Needed – Time Range & Sum Matching
I have two sets of data that need to be reconciled. Specifically, I’m trying to identify which combinations of numbers from these datasets can sum up to a specific target value. Additionally, the re...
Python may help:
import itertools
import pandas as pd
# Load datasets
df1 = pd.read_excel("dataset1.xlsx")
df2 = pd.read_excel("dataset2.xlsx")
# Filter by time range
start = pd.Timestamp("2025-11-16 08:00")
end = pd.Timestamp("2025-11-17 22:00")
df1 = df1[(df1['timestamp'] >= start) & (df1['timestamp'] <= end)]
df2 = df2[(df2['timestamp'] >= start) & (df2['timestamp'] <= end)]
# Combine values
values = list(df1['amount']) + list(df2['amount'])
target = 1000 # example target sum
# Find combinations
for r in range(2, len(values)+1):
for combo in itertools.combinations(values, r):
if sum(combo) == target:
print(combo)