Clean Mixed Online Form Data
Budget: ₹1,250 – ₹2,500 INR
I have a collection of submissions that were captured through online forms and now sit in a raw export. The file combines free-text fields, numbers, dates, and the occasional special character, so it needs a careful pass to become analysis-ready.
Here is what I need from you:
• Identify and correct inconsistencies in spelling, casing, and punctuation.
• Standardise numerical fields (e.g., remove stray symbols, ensure uniform decimal precision, convert any text-numbers into numeric format).
• Flag and remedy obvious outliers or impossible values.
• Remove duplicate records while preserving a reference list of what was deleted.
• Deliver the cleaned dataset in both its original structure and a tidy Excel workbook, plus a short change log that explains every transformation step for transparency.
Accuracy is everything, so please use whatever mix of Excel functions, Python/Pandas, or specialised data-quality tools you’re most comfortable with—as long as the final file is spotless and easy to audit. I’m happy to answer any clarifying questions up front so we can get this done smoothly.
Here is what I need from you:
• Identify and correct inconsistencies in spelling, casing, and punctuation.
• Standardise numerical fields (e.g., remove stray symbols, ensure uniform decimal precision, convert any text-numbers into numeric format).
• Flag and remedy obvious outliers or impossible values.
• Remove duplicate records while preserving a reference list of what was deleted.
• Deliver the cleaned dataset in both its original structure and a tidy Excel workbook, plus a short change log that explains every transformation step for transparency.
Accuracy is everything, so please use whatever mix of Excel functions, Python/Pandas, or specialised data-quality tools you’re most comfortable with—as long as the final file is spotless and easy to audit. I’m happy to answer any clarifying questions up front so we can get this done smoothly.