Data Processing Expert - Merge & Clean Multiple Excel Files into Structured Dataset
Budget: ₹12,500 – ₹37,500 INR
We have a large set of Excel files extracted from a third-party source. These files currently have no headers and inconsistent formatting. We require an experienced data professional to:
Scope of Work:
Analyze all Excel files and identify the correct column structure.
Add appropriate headers based on data patterns.
Merge all files into a single structured dataset.
Perform data cleaning and normalization:
Remove duplicates.
Standardize formats (emails, phone numbers, URLs, etc.).
Deliver the final dataset in a usable format (Excel, CSV, or database).
Provide scripts or documented steps for future processing.
Deliverables:
Cleaned and consolidated dataset.
Automation script or documented process.
Summary report of actions taken.
Skills Required:
Expertise in Excel/CSV handling and data cleaning.
Familiarity with database loading (MySQL/PostgreSQL) is a plus.
Additional Information:
NDA required.
Please include in your proposal:
Your approach to handling files without headers.
Tools and techniques you will use for efficient processing.
Estimated timeline and cost.
Scope of Work:
Analyze all Excel files and identify the correct column structure.
Add appropriate headers based on data patterns.
Merge all files into a single structured dataset.
Perform data cleaning and normalization:
Remove duplicates.
Standardize formats (emails, phone numbers, URLs, etc.).
Deliver the final dataset in a usable format (Excel, CSV, or database).
Provide scripts or documented steps for future processing.
Deliverables:
Cleaned and consolidated dataset.
Automation script or documented process.
Summary report of actions taken.
Skills Required:
Expertise in Excel/CSV handling and data cleaning.
Familiarity with database loading (MySQL/PostgreSQL) is a plus.
Additional Information:
NDA required.
Please include in your proposal:
Your approach to handling files without headers.
Tools and techniques you will use for efficient processing.
Estimated timeline and cost.
Related categories:
Data Processing
Data Entry
Excel
SQL
MySQL
Data Analysis
Database Management
Data Management