12.12企业智能对账购买

import pandas as pd

def auto_reconcile(transactions_df, invoices_df):
    # 合并交易和发票数据
    merged_df = pd.merge(transactions_df, invoices_df, on=['transaction_id', 'amount'], how='outer', indicator=True)
    
    # 筛选出未匹配的记录
    unmatched_transactions = merged_df[merged_df['_merge'] == 'left_only']
    unmatched_invoices = merged_df[merged_df['_merge'] == 'right_only']
    
    return unmatched_transactions, unmatched_invoices

# 示例数据
transactions = {
    'transaction_id': [1, 2, 3],
    'amount': [100, 200, 300]
}
invoices = {
    'transaction_id': [1, 2, 4],
    'amount': [100, 200, 400]
}

transactions_df = pd.DataFrame(transactions)
invoices_df = pd.DataFrame(invoices)

unmatched_transactions, unmatched_invoices = auto_reconcile(transactions_df, invoices_df)
print("Unmatched Transactions:\n", unmatched_transactions)
print("Unmatched Invoices:\n", unmatched_invoices)