Whether we like it or not Excel is a common tool for working with data, so we often find ourselves wanting to load Excel files into R. In this post I show you a simple method for how to import data from different sheets of an Excel workbook into R. The way I like to… Read More »
In this post I’ve found some cool open data APIs which allow access to a range of data including environmental, weather, economic, and transport data. Organisations are increasingly making their data available via an API. An API, or Application Programming Interface allows users to access services or data using a particular set of commands or… Read More »
Transport is one area where the wide availability of data has made a big difference in recent years. Google mapsis probably the most obvious example, but there are also some other cool projects out there. Here I’ve picked out some cool map and visualisation projects that use live transport data to visualise transport systems around… Read More »
As you develop your data science and analytics skills, you may find yourself wanting to play with cool data in bigger data sets. It’s not always clear how you can find this data. SPARQL endpoints are one way to access this cool data – and they allow the public to access a whole range of… Read More »
Supporting decisions and providing insight are essential principles of data science. To provide this insight means having an understanding of the problems that people and organisations experience. The consulting company Deloitte have put together some short guidance on what they call “Crunchy Questions” to help you start making a difference with data and analytics, and… Read More »