Python Developer for Task Automation

We are seeking a skilled freelancer to automate the process of sending student data to school coordinators via WhatsApp. The task involves parsing a large Excel sheet containing student data, splitting it into smaller sheets based on schools, and sending each school's data to the corresponding coordinator's WhatsApp number.

The main tasks include:

Data Parsing: The freelancer will need to parse the provided Excel sheet containing student data. The data includes student names, grades, schools, coordinator names, coordinator WhatsApp numbers, and student codes.
Data Splitting: The freelancer will develop a Python script to split the large Excel sheet into smaller sheets based on schools. Each smaller sheet should contain data for students from a single school.
WhatsApp Integration: The freelancer will integrate Twilio's WhatsApp API into the script to send the smaller Excel sheets to the WhatsApp numbers of school coordinators. Each coordinator's WhatsApp number is provided in the Excel sheet.
Error Handling: The script should include error handling mechanisms to manage any potential issues during data parsing, splitting, and WhatsApp message sending.
Documentation: The freelancer will provide documentation detailing how to run the script, including any necessary configurations and dependencies.
Deliverables:

Python script for automating the process, including data parsing, splitting, and WhatsApp integration.
Documentation on script usage and configuration.
Skills Required:

Proficiency in Python programming language.
Experience with data manipulation using pandas library.
Familiarity with Twilio's APIs, specifically WhatsApp API.
Strong communication and problem-solving skills.
Timeline:
The project should be completed within [1 day] from the date of awarding the contract.