Data Cleanup and Integration
Budget: $10 – $30 USD
I need assistance with cleaning and merging attendance data from 2-3 Excel reports, and integrating it into the Master file. The goal is to track each person's activity at different locations, spot trends, and ensure the data is accurate and aligned with unique IDs.
Key tasks:
- Clean and merge attendance data from multiple reports
- Match names to IDS
- Integrate the cleaned data into a Master file
- Ensure data accuracy and alignment with unique IDs (clean up)
Unique IDs vary across reports, so the ideal candidate should be skilled in data analysis and Excel. Experience with data cleaning and integrating multiple data sources is a plus. Please note that the unique IDs are not consistent across all reports, which adds a layer of complexity to the task.
Key tasks:
- Clean and merge attendance data from multiple reports
- Match names to IDS
- Integrate the cleaned data into a Master file
- Ensure data accuracy and alignment with unique IDs (clean up)
Unique IDs vary across reports, so the ideal candidate should be skilled in data analysis and Excel. Experience with data cleaning and integrating multiple data sources is a plus. Please note that the unique IDs are not consistent across all reports, which adds a layer of complexity to the task.