◈ Lumen Data
GUIDE / CSV IMPORTS

A comma is not
always a separator.

Quoted notes include commas, quotes, Unicode and embedded newlines. Use a CSV parser and compare against the documented result.

import csv, io
from urllib.request import urlopen

with urlopen("https://lumenfixtures.com/downloads/orders.csv", timeout=15) as response:
    records = list(csv.DictReader(io.StringIO(response.read().decode("utf-8"), newline="")))
assert len(records) == 48
assert sum(int(row["amount_cents"]) for row in records) == 172981
assert sum(row["note"] == "" for row in records) == 7

Amounts are integer cents. Empty note fields represent null, not missing records. Fixture contract →