Category: Data
-
Linked data types in Excel
Apparently parts of this have been around for a couple of years, but it just came on my radar last week with this blog post. Did you know that Excel can do lookups from providers like Wolfram, Bing, and Power BI on a bunch of different data types? Only available with a Live365 (and/or institutional?)…
-
Historical COVID-19 R-Values for Alberta
Filed under stuff no citizen should have to do, today I went through pages archived by the Wayback Machine in order to provide a patron with historical R-Value data for COVID-19 for the Province of Alberta. This information is updated weekly (since mid-December, 2020) at https://www.alberta.ca/covid-19-alberta-data.aspx, but for some reason the Government has chosen not…
-
Preparing a dataset to use in Hydrator
Update – April 18, 2023: From the developer: Twitter's changes to their API which greatly reduce the amount of read-only access means that the Hydrator is no longer a useful application. The application keys, which functioned for the last 7 years, have been rescinded by Twitter. Every few months I get an email from someone…
-
Summary of CO2 Emissions by Sector. Alberta, 1988-2005.
Earlier this week I was trying to help a student find CO2 emissions data for Alberta going back to 1985, and have so far been unsuccessful. According to the Canadian Greenhouse Gas Measurement Program, measurements began in 1975, at least nationally, but I haven't been able to find the actual data following any of the…
-
A map of the most spoken languages in every Canadian Province or Territory besides English and/or French
I saw this post on BoingBoing earlier today: A fascinating map of the most spoken languages in every US state besides English and Spanish and wondered what an equivalent map for Canada might look like. So I made one. Data was pulled from the 2016 Canadian Census, looking at the variable "Language spoken most often…
-
Witchcraft and OpenRefine
Last September I learned about a fabulous resource called Places of Residence for Accused Witches. Map of Scots women accused of witchcraft published for first time https://t.co/vOxIlv6g24 ht @ResearchBuzz Fascinating stuff! #GIS #witches #witchcraft #mapping pic.twitter.com/nOWNHiUlw4 (@ppival) September 26, 2019 At that time I didn't realize how much work had been done using OpenRefine, one…
-
Quick and Dirty Data Viz of Canadian Federal Candidates
A couple of months ago I posted about using Flourish to build a bar chart race data visualization. Shortly after that Flourish had another blog post highlighting all the different ways their site could be used to visualize election data, and I've had it bookmarked waiting for another opportunity to experiment with the service. Earlier…
-
11 Best Web Scraping Tools to Extract Online Data
Hongkiat just posted a list of the 10 Best Web Scraping Tools to Extract Online Data (ht ResearchBuzz). I've tried a few of them, but now have more to explore. I was really surprised that Octoparse wasn't on their list. I've had some really good success with it before, and it definitely deserves to be…
-
Thoughts on building my first bar chart race with Flourish
If you're on social media you've probably seen a bunch of bar chart races pop up in the past couple of weeks. The folks at Flourish have a good post chronicling the "new" phenomenon. Even better, Flourish created a template which makes it pretty easy to build your own, so that's what I did. Here…