Excel Numerical Data Cleanup

Замовник: AI | Опубліковано: 25.09.2025

I have several Excel spreadsheets containing purely numerical data that now need a thorough tidy-up. The core tasks are straightforward but essential: • Remove every duplicate record so each row is unique. • Identify and fill in any missing values using a clear, consistent method we agree on (mean, median, forward fill—happy to discuss what fits best). • Track down and correct obvious data-entry errors such as misplaced decimals, out-of-range values, or typos that break numeric consistency. Please keep the files in .xlsx format and, once complete, return both the cleaned sheets and a short change log summarising what you fixed and how many entries were affected. Accuracy is critical; I’ll spot-check the results by rerunning basic validation rules to be sure no duplicates remain, blanks are handled, and corrected numbers sit within expected ranges. If you prefer to work directly in Excel’s built-in tools, Power Query, or automate the job with Python/pandas, that’s fine—as long as the final deliverable is the cleaned Excel file plus your brief report.