Financial & Clinical Data Aggregation

I have several spreadsheets that separately track our financial figures and our clinical metrics, and I need them pulled together into a single, reliable dataset. The job is straightforward: extract every column, normalise formats (dates, currency, codes), de-duplicate any overlapping records, and output a master file we can analyse in one place.

All source material is Excel/CSV, but please structure your solution so that adding other sources later—such as a database or API feed—would be painless. A lightweight Python or R script is fine, as long as it is clearly commented and I can rerun it whenever new spreadsheets come in.

Deliverables
• Cleaned, consolidated dataset (Excel and CSV)
• Re-usable aggregation script with inline documentation
• Brief README outlining setup, required libraries, and how to extend to new data sources

Acceptance criteria
• Every original row is represented once and only once in the final file
• All monetary values carry the same currency symbol and two-decimal precision
• Clinical codes match our existing reference list (I will provide it)
• Script runs from a single command without manual tweaks

If you’ve handled mixed financial and clinical data before, let me know—that context will help us hit the ground running.