I will automate CSV cleaning and excel reports with python


About this gig
I will build a reusable local Python script to clean flat CSV or XLSX tables and create agreed output. Message me with a redacted sample and expected result before ordering.
Basic: 1 file, 1000 rows, 20 columns and 2 rules. Standard: up to 3 same-schema files, 5000 total rows, 30 columns and 4 rules, including merge. Premium: 5 files, 10000 total rows, 40 columns, 6 rules and one count OR sum summary grouped by one column. Each batch: 20 MB maximum; one flat sheet per file.
Rules may trim text, remove agreed duplicates or standardise one named column. Missing values follow your instructions, never guesses. CSV or new XLSX output; XLSX header styling, filter and frozen header included.
All packages include source, run guide, sample output and actual validation notes on one agreed OS. Originals stay unchanged. One revision adjusts agreed rules. Completion means delivery against agreed sample checks.
No macros, formulas, charts, dashboards, XLS, workbook preservation/repair, scraping, APIs or hosting. Use authorised, redacted data; agree confidentiality and AI-tool restrictions before sharing.
Get to know Jitender Joshi
Flutter Developer for UI Fixes and App Improvements
- FromNew Zealand
- Member sinceNov 2026
Languages
English, Hindi, Punjabi
FAQ
What counts as one cleaning rule?
One agreed operation, such as trimming one named column, standardising one named column, or removing duplicates using an agreed key. Confirm the full rule list before ordering. Missing values are flagged or handled only using your explicit instructions.
What Excel files and output formats do you support?
Flat CSV or XLSX data, one sheet per file. Multi-file inputs must share column names and types. Output is CSV or a new XLSX with header styling, filter and frozen header. No XLS, macros, formulas, charts or preservation of existing workbook features.
What will I receive and what does a revision cover?
Every tier includes reusable Python source, dependency/run instructions, processed sample output and actual test notes on one agreed OS. Python is required; no installer or remote setup. One revision adjusts agreed rules. New rules, files or formats require separate scope.
Can I send confidential data or request complex integrations?
Start with redacted or synthetic data. Agree confidentiality, retention and AI-tool restrictions before sharing files. No passwords, sensitive records, scraping, APIs or external hosting are included. The delivered script processes files locally; no guarantee covers unseen data.
