Ancestors

Written by Russ Garrett on 2025-01-08 at 01:03

This python script is a memorial to the fact that this country's electricity system runs on horrific spreadsheets and they can't even publish them in a CONSISTENT FORMAT.

=> View attached media

=> More informations about this toot | More toots from russss@chaos.social

Toot

Written by doskel on 2025-01-08 at 01:08

@russss don't worry it's not just the UK, i've gotten CSVs from the US energy monitoring organization and the year column started as a string of a number, then to a float, then back to a string of a number. it's fucked everywhere

=> More informations about this toot | More toots from doskel@doskel.net

Descendants

Written by Russ Garrett on 2025-01-08 at 01:10

@doskel I had one where in one release of the spreadsheet it changed from MVA to kVA, except there was some formatting converting it back to MVA, but pandas obviously didn't know that, so everything was multiplied by 1000.

No problem, I have a multiplier option for exactly this reason.

Next release, it was back to MVA again.

=> More informations about this toot | More toots from russss@chaos.social