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.

ID do Projeto: 40151532