Extract Metrics from Log Fixtures

2026-07-20 09:00:01 GET /api/users 200
2026-07-20 09:00:02 GET /api/orders 404
2026-07-20 09:00:03 POST /api/users 201
2026-07-20 09:00:04 GET /api/users 200
2026-07-20 09:00:05 GET /api/orders 500

from collections import Counter
status_counts = Counter(line.split()[-1] for line in lines)
result = dict(status_counts)

Python + string parsing

{"200": 2, "404": 1, "201": 1, "500": 1}

req_id=1 latency_ms=120
req_id=2 latency_ms=980
req_id=3 latency_ms=150
req_id=4 latency_ms=200

import sqlite3
conn = sqlite3.connect(':memory:')
c = conn.cursor()
c.execute('CREATE TABLE logs(req_id INTEGER, latency_ms INTEGER)')
for line in lines:
    req_id = int(line.split()[0].split('=')[1])
    lat = int(line.split()[1].split('=')[1])
    c.execute('INSERT INTO logs VALUES (?, ?)', (req_id, lat))
c.execute("SELECT AVG(latency_ms) FROM logs")
result = round(c.fetchone()[0], 2)

SQL (log data loaded into a table)

362.5

2026-07-20 10:01 ERROR svc=payments msg=timeout
2026-07-20 10:02 INFO svc=payments msg=ok
2026-07-20 10:03 ERROR svc=auth msg=bad_token

from collections import Counter
import re
errors = Counter(re.search(r'svc=(\w+)', l).group(1) for l in lines if 'ERROR' in l)
result = dict(errors)

Python + regex

{"payments": 1, "auth": 1}