I will automate excel and CSV tasks using python
Python Developer Data Science ML
Über diesen Service
Do you spend too much time performing repetitive Excel or CSV tasks?
I will create a customised Python automation script to help you process spreadsheet data faster, reduce manual work, and improve consistency.
WHAT I CAN AUTOMATE
- Combine multiple Excel or CSV files.
- Remove duplicate records.
- Handle missing values.
- Filter and sort spreadsheet data.
- Standardise column names and formats.
- Split large datasets into smaller files.
- Calculate totals, averages and summaries.
- Convert CSV files to Excel and Excel files to CSV.
- Generate organised Excel reports.
TOOLS I USE
- Python
- Pandas
- NumPy
- OpenPyXL
- Jupyter Notebook
WHAT YOU WILL RECEIVE
Depending on your selected package:
- Custom Python source code.
- Processed Excel or CSV output.
- Jupyter Notebook where included.
- Instructions explaining how to run the script.
- Sample output and documentation where included.
MY WORKING PROCESS
- Review your requirements and sample files.
- Confirm the automation scope.
- Develop the Python solution.
- Test the script using your supplied sample data.
- Deliver the source code and agreed output files.
BEFORE ORDERING
Please contact me before ordering if your task involves large files, complex formulas, multiple workbooks,
FAQ
Q1. What types of files do you support?
I primarily support CSV and Excel files (.xlsx). Please contact me before ordering if your file uses another format.
Q2. Will I receive the Python source code?
Yes. All packages include the Python source code so you can review and reuse the automation.
Q3. Can you combine multiple Excel files?
Yes. I can combine compatible Excel or CSV files according to your requirements and selected package.
Q4. Can you automate repetitive tasks?
Yes. I can develop scripts for agreed spreadsheet processing tasks, helping reduce repetitive manual work.
Q5. Can you work with very large files?
Please contact me first with your file size and a sample. I will check whether the task can be completed within the selected package.
Q6. Do you provide machine-learning models?
This Gig focuses on Excel and CSV automation. Machine-learning projects require a separate discussion and quotation.
Q7. Will you explain how to run the script?
Yes. I provide usage instructions, with additional documentation depending on the package.
