Few people really want to make decisions without evidence, but time pressures and competing priorities can make achieving analysis with impact difficult. This post explores some of the ways you can make sure your analysis makes a difference. Put Yourself in The Decision-Maker’s Shoes Think about the the person you would like your analysis to… Read More »
With the Firefox SQLite Manager Plugin it’s easy to view, update and export SQLite databases. It’s very easy to install Firefox SQLite Manager, but I found it wasn’t obvious how to actually use it. This post walks you through the steps to load up the manager once you’ve installed it. 1. Right Click on The… Read More »
SPARQL is a semantic query language for databases, often used to explore and retrieve data from public repositories. Useful as it is, if you’re not familiar with SPARQL, it can take a while to get used to. After a while of hunting around I found this good SPARQL tutorial series from Youtube user Dr Noureddin… Read More »
In this post I show you how you can combine SPARQL – a semantic query language for databases, and Excel – Microsoft’s ubiquitous spreadsheet software, to do an Excel SPARQL import. Excel is a commonly used tool for data science and data analysis. This being the case I was interested to know if there was… Read More »
Anaconda SPARQL Install With rdflib Package There are a few different Anaconda SPARQL options available for Python, but I’ve had some success installing the package SPARQLWrapper. You can install the SPARQLWrapper package by loading up the Anaconda Command Prompt and running: which should download and install the most recent version of the package. Go to… Read More »