Coding classes for teens in Canada

# Our search for Calgary public art that uses light (Modern Age Coders, written for this page)
import csv
import re

TEXT_COLUMNS = ["TITLE", "SHORT_DESC", "DESC1", "DESC2", "DESC3", "DESC4", "DESC5"]
WORD = re.compile(r"\b(light|lights|lighting|lit|illuminated)\b", re.IGNORECASE)

naive = folded = rows_found = 0
artworks = {}                      # ART_ID -> title, so one artwork counts once

with open("calgary-public-art.csv", encoding="utf-8-sig") as f:
    for row in csv.DictReader(f):
        text = " ".join(row[c] for c in TEXT_COLUMNS)
        if "light" in text:
            naive += 1
        if "light" in text.lower():
            folded += 1
        if WORD.search(text):
            rows_found += 1
            artworks[row["ART_ID"]] = row["TITLE"]

print("substring, case-sensitive:", naive)
print("substring, lower-cased:   ", folded)
print("whole words, rows:        ", rows_found)
print("whole words, artworks:    ", len(artworks))
print(sorted(artworks.values())[:4])

substring, case-sensitive: 30
substring, lower-cased:    31
whole words, rows:         16
whole words, artworks:     13
['Below/Before/Between', 'Chinook Arc', 'Confluence', 'Flock']

Four ways of counting the same thing give 30, 31, 16 and 13. Only the last is the number of artworks.