I will clean, merge and prepare your excel or CSV data for analysis
Data Analyst and Data Scientist
About this Gig
Get clean, consistent Excel or CSV data for reporting and analysis, with clear documentation of what changed.
Depending on your package, I can:
- Remove duplicates using agreed rules
- Standardize dates, numbers, text and categories
- Correct clearly defined inconsistencies
- Flag missing or ambiguous values for your review
- Merge tables using agreed columns or exact matching keys
You receive a cleaned file and a concise change summary. Premium includes a commented R or Python script and instructions to rerun it on files with the same structure.
Scope:
- Basic: 1 table, 100 rows, 10 columns, up to 3 cleaning rules.
- Standard: up to 2 tables, 2,000 rows, 20 columns, up to 5 rules.
- Premium: up to 3 tables, 5,000 rows, 30 columns, up to 5 rules.
1 item = 1 input data row, excluding headers. Row limits are totals across all input tables; column limits apply per table.
Based in Germany. Communication in English or German.
Please message me with your goal, cleaning rules and a fully anonymized sample before ordering.
My Portfolio
FAQ
Which file formats can I send?
I accept Excel (.xlsx) and CSV files. Each worksheet or CSV should contain one structured table. Please contact me before ordering if your files contain complex formulas, macros or a different format.
How are items, rows and columns counted?
One item means one input data row, excluding headers. Row limits count all input tables together, including reference tables. Column limits apply per table. Tables may be worksheets or separate CSV files.
What counts as one cleaning rule?
One rule is one agreed operation, such as trimming spaces in specified columns, standardizing a date format, deduplicating on an agreed key or flagging missing values. Basic includes up to 3 rules; Standard and Premium include up to 5.
How do you handle missing or ambiguous values?
Missing or unclear values are flagged for your review. Corrections follow agreed rules or reference data you provide. I deliver a separate cleaned file and a summary of changes and unresolved issues.
What do I receive with the Premium script?
You receive one commented R or Python script, agreed before work starts, and brief run instructions. It repeats the agreed cleaning steps on files with the same layout. Installation support, scheduling and ongoing maintenance require a separate scope.
What does a revision include?
A revision is one consolidated round of small adjustments to the agreed output within the booked scope. New files, extra rules or additional features need a separate quote. Errors in applying the agreed rules are corrected.
What should I send before ordering?
Please message me with your goal, file and table counts, row and column counts, desired output and cleaning rules. For the initial review, use fictional or fully anonymized sample data. I will confirm the suitable package and scope.

