DevelopmentPayment protectionDetails
- Revisions within the package are free.
- If you do not respond within 3 days of delivery, the work is accepted automatically.
The money is reserved when you pay and released only once you accept the work.

Example result
Merging the monthly sales files of 9 shops into one Excel report
How it is run
python merge_sales.py --month 2026-10
2026-11-02 09:14:03 INFO Folder: sales/2026-10, 9 files found
2026-11-02 09:14:03 INFO shop-01.csv: 1,284 rows
2026-11-02 09:14:04 INFO shop-02.xlsx: 967 rows
2026-11-02 09:14:04 WARN shop-07.csv: 3 rows without a price skipped (lines 88, 412, 913)
2026-11-02 09:14:05 INFO Done: 10,412 rows -> report-2026-10.xlsx (sheets "Sales" and "Totals")
Settings, not code
The column names of each shop live in settings.ini, so a new shop or a renamed column is a line there:
[columns]
date = Date, Sale date, Day
product = Product, Item, Name
quantity = Qty, Quantity, Pcs
price = Price, Unit price
A part of the code
def read_shop_file(path: Path, columns: dict[str, list[str]]) -> pd.DataFrame:
"""Reads one shop's file and gives it the report's column names."""
table = pd.read_excel(path) if path.suffix == ".xlsx" else pd.read_csv(path, encoding="utf-8-sig")
renamed = {}
for name, variants in columns.items():
found = next((c for c in table.columns if c.strip() in variants), None)
if found is None:
raise ReportError(f"{path.name}: no column for '{name}' (looked for {', '.join(variants)})")
renamed[found] = name
table = table.rename(columns=renamed)[list(columns)]
table["shop"] = path.stem
return table
Files: a ZIP archive with merge_sales.py (310 lines), settings.ini, requirements.txt and a README with installing Python, running the script and what each message in the log means. The client runs it on their own computer.
Client: a small chain of 9 stationery shops; each shop sends its sales for the month as a CSV or Excel file, with slightly different column names. Task: one script that reads every file in a folder, brings the columns to one shape, and writes a single Excel report with all sales and a sheet of totals by shop.
The client and all details are made up.
About this service
A ready-made CSV cleaning script: a typical Python script that is already worked out, set up with the columns of your file. Exports from a shop, a form, a CRM or a spreadsheet often arrive with spaces at the ends, empty rows, the same row twice, dates written three ways and odd symbols in place of letters. The script fixes what has a clear rule: it trims spaces, removes empty and exact duplicate rows, writes dates and numbers in one format, reads the file in the right encoding and saves it with the separator your next program expects. The original stays as it was. You send a few rows of your file, with made-up values if the data is private, and what the result should look like. You run it on your own computer. It does not guess missing values, merge records that are only similar or check whether the data is true.
What is included
- What you getA ZIP archive with the ready CSV cleaning script in Python, a README with step-by-step instructions and, from Standard, a settings file; the code is also shown on the order page.
- Clear rulesSpaces, empty rows and exact duplicates
- One formatDates and numbers per column, from Standard
- Right encodingNo odd symbols in place of letters
- Original keptThe clean file is saved as a new one
- A plain guideInstalling Python and running it, step by step
How it works
- 1DetailsYou send sample rows and how the result should look
- 2SetupWe adapt the ready script to your details and write the guide
- 3Try itYou run it on a copy of your files
- 4ChangesYou ask for changes within your package and send any error message
What we need from you
Where the file comes from and what it goes into next, for example a shop export to be imported into a mailing service. A few rows of it with the header, with made-up values if the data is private, and the same rows as they should look after cleaning. Rules per column: date format, decimal separator, upper or lower case. The separator and encoding you need. Your system: Windows, macOS or Linux.
We will ask you:
- Where is the file from, and where does it go?
- Sample rows before and after
- Rules per column
- Your system
Compare packages
| Packages | Basic$13 | Standard$26 | Premium$50 |
|---|---|---|---|
| What is included | Basic clean-up | Rules in settings | Several files and a report |
| Deadline | 1 day | 2 days | 3 days |
| Revisions | 1 | 2 | 3 |
| Code | up to 150 lines | up to 400 lines | up to 1,000 lines |
| Files of code | 1 | up to 3 | up to 8 |
| Settings file | No | Yes | Yes |
| Clear error messages and a log | No | Yes | Yes |
| Run options and a guide to running it on a schedule | No | No | Yes |
| Guide to installing and running it (README) | Yes | Yes | Yes |
| Ready-made version | CSV cleaning | CSV cleaning | CSV cleaning |
| Order Basic | Order Standard | Order Premium |
Payment protection
You pay when you order, but the money is released only for accepted work.
- Fixed priceThe package price does not change after you pay.
- The money is reservedWhen you pay, the amount is only reserved. It is released to the service once you accept the work.
- Checked before deliveryEvery result goes through a quality check before it reaches you, and you see it on the order page before accepting it.
- Free revisionsAsk for changes within your brief as many times as the package allows.
- Acceptance after 3 daysIf within 3 days of delivery you neither accept the work nor ask for changes, it is accepted automatically. If you write in the order chat after delivery, the order waits; once we answer, we may start the 3 days again and will say so in the chat.
- Redo or a full refundIf the result does not match your brief and the revisions did not fix it, or the work takes more than twice its deadline, write in the order chat: we will redo the work or refund the payment in full.
Questions and answers
Should I send my real data?
No need. A few rows with made-up values and the real header are enough; you run the script on the real file yourself.
Will it merge «J. Smith» and «John Smith»?
No. It removes only rows that are exactly the same after cleaning. Deciding that two different rows are one person or one product needs your judgement.
Does it work with Excel files?
This ready script works with CSV. Save the sheet as CSV first; reading and writing Excel directly is a task for the custom script service.
Why does it cost less than a custom script?
It is a ready-made, typical CSV cleaning script: the way it works is already worked out, and we adapt it with your folders, rules and system. A script with its own logic is the custom script service.
Will you run the script for me?
No. You run it on your own computer, on your own files, so they stay with you. Try it on a copy first.
Did not find your answer?


