Excel Data Cleanup & Insight Extraction
Budget: $10 – $30 USD
I’m working with an Excel workbook that holds a mix of text fields and numerical columns. Before I can move forward with any decisions, the file needs to be professionally cleaned and explored. Here’s what I need from you:
• Removing duplicates and errors
• Data normalization and transformation
• Identifying patterns and insights
You’re welcome to use Power Query, Python (pandas), R, or any other reliable tool—as long as the end result is:
1. A fully cleaned Excel file with clear documentation of every change you made (so I can trace the workflow if needed).
2. A short summary—charts, pivot tables, or a brief narrative—highlighting the key trends and unexpected findings you uncover.
Send the final workbook plus any scripts or notebooks you used. If everything looks consistent (no duplicates, consistent data types, well-structured fields) and your insights are reproducible from the supplied code, I’ll consider the job complete.
• Removing duplicates and errors
• Data normalization and transformation
• Identifying patterns and insights
You’re welcome to use Power Query, Python (pandas), R, or any other reliable tool—as long as the end result is:
1. A fully cleaned Excel file with clear documentation of every change you made (so I can trace the workflow if needed).
2. A short summary—charts, pivot tables, or a brief narrative—highlighting the key trends and unexpected findings you uncover.
Send the final workbook plus any scripts or notebooks you used. If everything looks consistent (no duplicates, consistent data types, well-structured fields) and your insights are reproducible from the supplied code, I’ll consider the job complete.
Related categories:
Python
Data Processing
Excel
SPSS Statistics
Data Visualization
Data Analysis
Data Management
Pandas