I am working with open data sources and the 2016 Canadian Census is of great interest to me. The Canadian Statistics website provides boundary files, which work great, and some aggregated census data, which doesn't work so great.

The problem I'm having with the aggregated census data is that the data is too 'long' and 'narrow' e.g.

'long' and 'narrow' data

whereas my work requires the data to be 'shorter' and 'wider' e.g.

'shorter' and 'wider' data

Does anyone know of a person or organisation that has solved this issue and made the data publicly available?

  • I suggest you edit your question so that you just ask about how to reformat your data. Your actual problem has nothing to do with the Canadian Census. Don't forget to add what format the data is in (csv?) – user4293 Jan 21 '18 at 15:34
  • Thanks for the advise but I am aware of how to reformat the data myself. I know that there are other open data sources (e.g. the US census) for which the formatting and cleansing task has been done and made available so I was hoping the same might be done for this data source – M4GU1R3 Jan 22 '18 at 14:17

I've run into this problem as well and have opted not to use the aggregated data in some cases because of how badly it's formatted. If you have access through a Canadian university, I`d highly recommend speaking with your librarian about gaining access to UofT's the CHASS Data Centre. They maintain a database of cleaned/geoprocessed census data and make it VERY easy to perform table joins and subsequent analyses with the results.

Unfortunately, their network of universities that they offer data to is not open to all universities and, AFAIK, they don't provide data outside of the academic networks.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.