Research & documents
From messy rows to answers.
Check the input, reconcile the numbers and deliver files you can use.
Try this task ↓Make it yours
Start with this.
Provide an accessible CSV URL or a document already saved in Leafy. Replace the placeholder.
Analyse this public project-spending CSV: [paste the URL]. Validate columns and report missing, duplicate or conflicting records. Calculate spending by programme and month, keeping currencies separate. Identify the five biggest month-to-month changes. Do not guess ambiguous dates. Save a cleaned CSV and a concise report that reconciles input and output row counts, totals and exclusions.
What the work involves
- Inspect the data and define cleaning rules.
- Calculate totals and changes with explicit exclusions.
- Deliver the cleaned data and a report that reconciles the numbers.
What you should get
A cleaned CSV and an analysis report saved to Documents.
Large analysis may use a background job. A started job is not a finished report; check that the delivered files exist.