This post goes through the general idea of an index, why a card index might be useful, and some examples of a card index being used. Card index systems are largely a thing of the past, but they still come up from time in archives and libraries around the world. What is an index? An… Read More »
Inspired by the Storytelling With Data book I wanted to try applying some of the techniques to some existing charts and graphs. In all the examples I have been limited in not having access to the original data, so re-plotting hasn’t really been possible. Instead, I have redrawn using Inkscape or Excel and then focused… Read More »
Archaeology can be an interesting source of data for projects or exploring analytical techniques. This post contains a few sources of open archeology data which you may wish to refer to. Journal of Open Archaeology Data This isn’t a repository of data itself, but the articles published in the journal of open archaeology data typically… Read More »
Machine learning is an essential part of data science – a field which covers a range of activities from data acquisition and cleaning, through to analytics and data visualisation. It can be helpful to think in terms of a machine learning workflow that puts some structure around some of these processes. This post looks at… Read More »
Joining tables in SQL is an essential part of many digital services and products. Joins let you answer questions such as which customers bought which products? How many staff work at a particular location? Which students are in which classes at a school? Joining in SQL becomes even more important when your data are stored… Read More »