A Python script that reads your web server's access logs and turns them into a clear report of pages and errors

Example result

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")

[columns]
date = Date, Sale date, Day
product = Product, Item, Name
quantity = Qty, Quantity, Pcs
price = Price, Unit price

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

About this service

Your web server writes down every request in its access log, but a file of millions of lines tells you little until it is counted. This Python script reads Nginx or Apache access logs, including older compressed ones, and makes a report: requests by day and hour, the most visited pages, status codes, the pages that return 404 or 500 and where visitors came from. Premium counts search engine crawlers apart from people and saves an Excel workbook with a tab per section. Visitors' IP addresses stay out of the report by default, or are shortened if you need them. Send us the log format line from your server's settings and 20-30 lines with addresses changed. You run it on your server or computer; it reads logs and does not change any settings.

What is included

• What you getA ZIP archive with the Python script, a README with step-by-step instructions and, from Standard, a settings file with log paths and report options; the code is also shown on the order page.
• Nginx and ApacheThe common log formats, or yours if it differs
• Errors with pagesWhich addresses give 404 or 500, and how often
• Old logs tooFrom Standard, compressed .gz files read as they are
• No personal dataIP addresses left out or shortened
• Readable codeWith comments, easy to add a section later

How it works

1. 1
   TaskYou send the log format and a few lines with addresses changed
2. 2
   CodeWe write the script and the guide to running it
3. 3
   Try itYou run it on a copy of one day's log and look at the report
4. 4
   ChangesYou ask for changes within your package and send any error message

What we need from you

Your web server (Nginx or Apache), the log_format or LogFormat line from its settings if it was changed, and 20-30 lines of the access log with IP addresses replaced by made-up ones. Where the logs are kept and how they are rotated, how big a day's log is, what the report should show and in what form (CSV or Excel), and where it will run: the server itself (with its system) or your computer.

We will ask you:

• Which web server and log format?
• What should the report show?
• How often do you need it?
• Where will it run?

Compare packages

Questions and answers

Did not find your answer? Ask us