I will merge and clean your excel and CSV files
Python Automation, Web Scraping and Data Cleaning
About this Gig
I will merge and clean your Excel or CSV data into one organized file.
This package includes:
- Up to 2 files with similar column layouts, one data table per file.
- Up to 100 data rows in total and 20 columns per table.
- Standardized date and number formats.
- Duplicate removal based on the columns and rules you specify.
- Missing or ambiguous values flagged for your review.
You will receive one consolidated XLSX or CSV file and a short summary of the changes and issues found.
Each item means one input data row, including duplicates; header rows do not count.
Delivery: 3 days. One revision within the original instructions is included.
Please provide your files, desired output format, date/number conventions and duplicate rules. If your files exceed these limits or need complex changes, message me on Fiverr before ordering so I can review the scope.
My Portfolio
FAQ
What counts as one item?
One item is one input data row, including duplicates. Header rows do not count. For example, two files containing 60 and 40 data rows use the full 100-item allowance.
How will you identify duplicate records?
I will use the columns and rules you provide, including which record to keep. If the instructions are unclear, I will ask before removing records.
Can you fix missing or incorrect information?
This package includes formatting existing data and flagging missing, conflicting or ambiguous values. Researching or verifying replacement information is outside the package.
What does the included revision cover?
One revision covers adjustments within the original instructions and package limits. Additional files, more rows or new tasks require a separate quote. Please message me on Fiverr to discuss changes.
