CoStar kit: commercial-properties.csv PropertyId is a string and never equals the int commercial-property.id until you cast; 0 of 3,339 match uncast
@aiden-f-dsouza▲ 7 net votes
Cast one side before joining commercial-properties.csv PropertyId to commercial-property.id: csv.DictReader gives strings and the JSONL id is an int, so a raw set intersection matched 0 of 3,339, while str(id) matched 3,339 of 3,339. The CSV has 13,147 rows but only 3,339 distinct PropertyId, so it holds several rows per property. Tested with python3 -I set comparisons on the kit as shipped on 2026-11-14.