Matches in SemOpenAlex for { <https://semopenalex.org/work/W993808862> ?p ?o ?g. }
Showing items 1 to 57 of
57
with 100 items per page.
- W993808862 abstract "Out of the cube Author : Tim Sherratt Tagged as : APIs, datacubes, Django, Piston, population, python, spreadsheets, statistics Date : February 26, 2010 For a project that I’m working on at the National Museum of Australia, I’ve started collecting various sources of date-identified data. Most recently I had a go at extracting historical population data from the Australian Bureau of Statistics. The data can all be downloaded as .xls files, but they’re not simple, flat spreadsheets – they’re data cubes. As the name suggests, data cubes are organised along a number of dimensions. In the case of the population data it’s year, state and gender. This means that you can’t just export the data to CSV and suck it into your database – first you’ve got to flatten the cube. No doubt there are other ways to do this, but I just wrote a simple python script. It uses xlrd to read from the spreadsheet, does a bit or reorganisation, then writes the output to a CSV file. The code, for what it’s worth, is available at Bitbucket. Once I had the CSV file I just imported it into MySQL and used Django and Piston to build a basic API. So if you want to know the population of NSW in 1856, you just go to: http://wraggelabs.com/api/json/population/nsw/1856/ The number of infant deaths in Tasmania in 1932: http://wraggelabs.com/api/json/infantdeaths/tas/1932/ The number of female births in Australia in 1959: http://wraggelabs.com/api/json/births/australia/females/1959/ I’m sure you get the picture. You can change the ‘json’ to ‘xml’ if you’d like another flavour of data." @default.
- W993808862 created "2016-06-24" @default.
- W993808862 creator A5060271781 @default.
- W993808862 date "2010-01-01" @default.
- W993808862 modified "2023-09-23" @default.
- W993808862 title "Out of the cube" @default.
- W993808862 hasPublicationYear "2010" @default.
- W993808862 type Work @default.
- W993808862 sameAs 993808862 @default.
- W993808862 citedByCount "0" @default.
- W993808862 crossrefType "journal-article" @default.
- W993808862 hasAuthorship W993808862A5060271781 @default.
- W993808862 hasConcept C136764020 @default.
- W993808862 hasConcept C144024400 @default.
- W993808862 hasConcept C149923435 @default.
- W993808862 hasConcept C199360897 @default.
- W993808862 hasConcept C2780416260 @default.
- W993808862 hasConcept C2908647359 @default.
- W993808862 hasConcept C41008148 @default.
- W993808862 hasConcept C519991488 @default.
- W993808862 hasConcept C77088390 @default.
- W993808862 hasConceptScore W993808862C136764020 @default.
- W993808862 hasConceptScore W993808862C144024400 @default.
- W993808862 hasConceptScore W993808862C149923435 @default.
- W993808862 hasConceptScore W993808862C199360897 @default.
- W993808862 hasConceptScore W993808862C2780416260 @default.
- W993808862 hasConceptScore W993808862C2908647359 @default.
- W993808862 hasConceptScore W993808862C41008148 @default.
- W993808862 hasConceptScore W993808862C519991488 @default.
- W993808862 hasConceptScore W993808862C77088390 @default.
- W993808862 hasLocation W9938088621 @default.
- W993808862 hasOpenAccess W993808862 @default.
- W993808862 hasPrimaryLocation W9938088621 @default.
- W993808862 hasRelatedWork W1144857804 @default.
- W993808862 hasRelatedWork W121059879 @default.
- W993808862 hasRelatedWork W1576030470 @default.
- W993808862 hasRelatedWork W1584821740 @default.
- W993808862 hasRelatedWork W1599431515 @default.
- W993808862 hasRelatedWork W1864228969 @default.
- W993808862 hasRelatedWork W2169543832 @default.
- W993808862 hasRelatedWork W2230574109 @default.
- W993808862 hasRelatedWork W2524233697 @default.
- W993808862 hasRelatedWork W2736839990 @default.
- W993808862 hasRelatedWork W2744326277 @default.
- W993808862 hasRelatedWork W2994028569 @default.
- W993808862 hasRelatedWork W3191251294 @default.
- W993808862 hasRelatedWork W325635142 @default.
- W993808862 hasRelatedWork W348142183 @default.
- W993808862 hasRelatedWork W406710320 @default.
- W993808862 hasRelatedWork W61231484 @default.
- W993808862 hasRelatedWork W746286637 @default.
- W993808862 hasRelatedWork W818607089 @default.
- W993808862 hasRelatedWork W3095578743 @default.
- W993808862 isParatext "false" @default.
- W993808862 isRetracted "false" @default.
- W993808862 magId "993808862" @default.
- W993808862 workType "article" @default.