财务 费用审计 代理

import pandas as pd, json

def audit_expenses(expenses):
    df = pd.DataFrame(expenses)
    flags = []
    for i, e in df.iterrows():
        if e['amt'] > 5000:
            flags.append({'idx':i,'flag':'High','action':'Review'})
        elif df.duplicated(subset=['amt']).any():
            flags.append({'idx':i,'flag':'Duplicate','action':'Void'})
    return {'total':len(df),'flagged':len(flags),'save':sum(f['amt'] for f in flags if f['action']=='Void')}

report = audit_expenses(expData)
print(json.dumps(report))