I will automate your repetitive excel and data work with a python script
About this Gig
You have a file that arrives every week, and someone opens it, cleans it the same way every time, and pastes the result somewhere else. It works until they are on leave, or a column moves.
I replace that with a Python script you own and can run yourself.
WHAT YOU GET
The script, commented so a non developer can follow it.
A test suite you run yourself, built from your own sample file, so you are not taking my word that it works.
Handling for the messy cases: blank rows, merged cells, changed column order, dates that arrive as text.
A one page runbook: how to run it, what can break, what to do about it.
WHY ME
I am an AI engineer at a regulated mortgage lender, where a wrong number is expensive and gets read by auditors. I have 5 releases on PyPI and I ship tests with everything I build.
HOW IT WORKS
Send a sample file and tell me what you do to it by hand.
I confirm the scope and a fixed price before you order.
You get the build, the tests, and one round of fixes.
I will tell you before you pay if I am not the right fit.
Technology:
Apache Spark
•
Excel
•
Google Sheets
•
Python
My Portfolio
FAQ
What do you need from me to start?
One sample file and a short description of what you currently do to it by hand. If the data is sensitive, send a dummy file with the same structure and column names.
Do I get the source code?
Yes, on every package. You own the script and can change it or hand it to another developer later. I do not lock anyone in.
Can you fix a script or macro someone else built?
Yes. Send the script or the workbook and the file that makes it fail. I reproduce the failure first, then fix it, then leave you a test that catches it if it ever comes back.

