zlacker

[parent] [thread] 0 comments
1. iso163+(OP)[view] [source] 2026-02-02 18:29:57
A few weeks ago I was interested in median price paid in the UK for property. I pulled down a 900,000 line csv from gov.uk and asked chapgpt to give me a python to parse it based on price (col 2) and county (col14), then output the 10,25,50,75,90 percentiles.

It dropped out a short file which used

from statistics import quantiles

Now maybe that python module isn't reliable, but as it's an idle curiosity I'm happy enough to trust it.

Now maybe I could import a million line spreadsheet and get that data out, but I'd normally tackle this with writing some python, which is what I asked it to do. It was far faster than me, even if I knew the statistics/quantiles module inside out.

[go to top]