News for hackers. Stuff that matters.
Re:Data Organization in Spreadsheets by sonofgod on Monday August 20, 2018 @02:56PM (#17802771)
Sometimes the spreadsheets are the output of one system, but the input to the next: the spreadsheets of the Office of National Statistics in the UK are the final, and official output of a long chain of number wrangling, but when it comes to re-consuming them to power their new data-driven website it's a real challenge -- I wound up working on a project to allow programmatic consumption of these complex spreadsheets.

(https://github.com/sensiblecodeio/databaker for the top-level project; https://github.com/sensiblecodeio/xypath for the library I created).

Get in touch if you're interested -- [email protected]

Re:Data Organization in Spreadsheets by IanCal on Monday August 20, 2018 @04:16PM (#17803539)
Oh fantastic, I want to do more with the data but the spreadsheets are designed for people rather than machines. Will have to check this out, thanks!
Re:Data Organization in Spreadsheets by DenisM on Monday August 20, 2018 @06:05PM (#17804435)
See also DataWrangler.