I will automate excel or csv data processing with python scripts
About this Gig
Drowning in messy spreadsheets? Manually cleaning data for hours? I'll build a Python automation script that processes, cleans, merges, and transforms your Excel or CSV files saving you hours of repetitive work every week.
Whether you need to merge hundreds of files into one, clean duplicate entries, generate reports, or convert between formats, I create efficient, reusable Python scripts that do it in seconds.
What I Can Automate For You:
Data Cleaning remove duplicates, fix formatting, handle missing values
File Merging combine multiple CSV/Excel files into one master file
Report Generation create summary reports, pivot tables, charts
Format Conversion CSV to Excel, Excel to JSON, JSON to CSV, etc.
Automated Delivery email the processed file to you on schedule
Filtering & Sorting extract specific data based on your criteria
Data Analysis calculate totals, averages, trends, and statistics
Tools & Technologies:
Python (Pandas, OpenPyXL, xlrd, xlwt)
Excel (.xlsx, .xls)
CSV (any delimiter)
JSON, XML (if needed)
SQLite (for larger datasets)
Operating system:
Windows
Also delivering:
Documentation
My Portfolio
FAQ
What format should my data be in?
Any common format — Excel (.xlsx, .xls), CSV, JSON, or even plain text. I can work with whatever you have.
