Data Consolidation Across Multiple Sheets and Uploading on Server Using Python
Budget: ₹1,500 – ₹12,500 INR
I have multiple sheets, each containing a single worksheet with a common unique identifier (Unique ID). I need to merge all the data into one consolidated workbook, prioritizing the Unique ID from the first workbook (Sheet1) as the primary reference.
Key Requirements:
- Data Consolidation: Merge all data from other sheets (Sheet2, Sheet3, etc.) based on the Unique ID found in Sheet1.
- Data Completeness: Capture all relevant columns and rows from the source sheets into the output sheet.
- Dynamic Handling: The solution should dynamically manage an arbitrary number of worksheets and variations in row counts across sheets.
- At last want to upload on server, based on some condition using python
The ideal candidate for this project should have:
- Extensive experience in data manipulation and Excel
- Ability to create dynamic Excel solutions
- Strong attention to detail
- Proficient in Python , SQL
Looking forward to your proposals.
Key Requirements:
- Data Consolidation: Merge all data from other sheets (Sheet2, Sheet3, etc.) based on the Unique ID found in Sheet1.
- Data Completeness: Capture all relevant columns and rows from the source sheets into the output sheet.
- Dynamic Handling: The solution should dynamically manage an arbitrary number of worksheets and variations in row counts across sheets.
- At last want to upload on server, based on some condition using python
The ideal candidate for this project should have:
- Extensive experience in data manipulation and Excel
- Ability to create dynamic Excel solutions
- Strong attention to detail
- Proficient in Python , SQL
Looking forward to your proposals.