Automate CSV Cleanup & Recurring Business ReportsAsaf Dallal
Turn recurring CSV exports into a reporting workflow you can run again. I build a reusable Python process that applies your business rules, checks the results and produces clean data, a review log and the report you need.
Stop repeating the same cleanup
Combine exports with inconsistent names, dates, amounts or IDs.
Apply clear rules for duplicates, missing values and invalid records.
Generate the same weekly or monthly summary from each new batch of files.
Your handoff includes
A reusable Python workflow: readable source code and configuration for the agreed inputs and rules.
Clean data and a finished report: outputs with the columns, calculations and summaries defined in your brief.
A review log: questionable records flagged with source references and reasons, so decisions stay visible.
Validation and a run guide: checks for counts and totals, setup requirements, a sample command and instructions for the next batch.
Your original files are preserved. Ambiguous values are flagged for review instead of silently guessed or discarded.
See a working example
The linked fictional demonstration turns 12 input rows into nine unique valid orders and three review rows, then produces a paid-order summary of eight orders totaling $290.50. It preserves leading-zero IDs and includes checks for repeat runs. These are demonstration results, not a client case study.
Start with the report you want
Send a small anonymized input sample, your current manual steps and an example of the desired output. I confirm the business rules, fixed scope, quote, delivery date and acceptance checks in writing before building.
Five years of data engineering experience at Mobileye. The brief, updates and handoff are handled in writing. AI assistance is used where permitted, with outputs checked against the agreed rules and expected results.
FAQs
Example work
Contact for pricing
Duration1 week
Tags
Python
Automations
Data Engineer
Service provided by
Asaf Dallal Petah Tikva, Israel
Automate CSV Cleanup & Recurring Business ReportsAsaf Dallal
Contact for pricing
Duration1 week
Tags
Python
Automations
Data Engineer
Turn recurring CSV exports into a reporting workflow you can run again. I build a reusable Python process that applies your business rules, checks the results and produces clean data, a review log and the report you need.
Stop repeating the same cleanup
Combine exports with inconsistent names, dates, amounts or IDs.
Apply clear rules for duplicates, missing values and invalid records.
Generate the same weekly or monthly summary from each new batch of files.
Your handoff includes
A reusable Python workflow: readable source code and configuration for the agreed inputs and rules.
Clean data and a finished report: outputs with the columns, calculations and summaries defined in your brief.
A review log: questionable records flagged with source references and reasons, so decisions stay visible.
Validation and a run guide: checks for counts and totals, setup requirements, a sample command and instructions for the next batch.
Your original files are preserved. Ambiguous values are flagged for review instead of silently guessed or discarded.
See a working example
The linked fictional demonstration turns 12 input rows into nine unique valid orders and three review rows, then produces a paid-order summary of eight orders totaling $290.50. It preserves leading-zero IDs and includes checks for repeat runs. These are demonstration results, not a client case study.
Start with the report you want
Send a small anonymized input sample, your current manual steps and an example of the desired output. I confirm the business rules, fixed scope, quote, delivery date and acceptance checks in writing before building.
Five years of data engineering experience at Mobileye. The brief, updates and handoff are handled in writing. AI assistance is used where permitted, with outputs checked against the agreed rules and expected results.
FAQs
Example work
Contact for pricing