Efficient Excel Automation with Python
Budget: ₹600 – ₹1,500 INR
I am looking for a skilled Python developer to create a robust program that will interact with an Excel file in CSV format. The main functionalities required are to read data from the file, manipulate the information based on specific criteria, and write the modified data back to the file. This process needs to be executed periodically, relying on a reliable and efficient scheduling mechanism.
### Ideal Skills and Experience:
- Proficiency in Python programming, with a strong grasp on working with CSV files and manipulating data.
- Experience with libraries like pandas for data manipulation and openpyxl or a similar library for reading and writing to Excel files.
- Ability to implement scheduling within the Python script, to automate periodic execution.
### Specific Requirements:
- **Read Data**: Extract data efficiently from a CSV file.
- **Manipulate Data**: Perform specified operations on the data extracted, such as sorting, filtering, and applying formulas.
- **Write Data**: Save the manipulated data back into the CSV file without losing any integrity.
- **Periodic Execution**: Set up a scheduling mechanism to run this script periodically, ensuring data is always up-to-date.
This project requires someone with a keen eye for automation, efficiency in coding, and a solid background in data manipulation. The ability to work independently and provide suggestions for improvements is highly valued. If you have experience in automating tasks with Python and have worked with Excel files extensively, your expertise could be perfect for this job.
### Ideal Skills and Experience:
- Proficiency in Python programming, with a strong grasp on working with CSV files and manipulating data.
- Experience with libraries like pandas for data manipulation and openpyxl or a similar library for reading and writing to Excel files.
- Ability to implement scheduling within the Python script, to automate periodic execution.
### Specific Requirements:
- **Read Data**: Extract data efficiently from a CSV file.
- **Manipulate Data**: Perform specified operations on the data extracted, such as sorting, filtering, and applying formulas.
- **Write Data**: Save the manipulated data back into the CSV file without losing any integrity.
- **Periodic Execution**: Set up a scheduling mechanism to run this script periodically, ensuring data is always up-to-date.
This project requires someone with a keen eye for automation, efficiency in coding, and a solid background in data manipulation. The ability to work independently and provide suggestions for improvements is highly valued. If you have experience in automating tasks with Python and have worked with Excel files extensively, your expertise could be perfect for this job.