-
Last night a DB saved my life (Part 2)
Following on from my last post about what DuckDB makes possible, here’s a little more detail about how this works in practice… Installing DuckDB There are two ways to use DuckDB: via the Command Line (CLI/Terminal), and via a library for whatever language you’re programming in. I tend to use the CLI more intensively while…
-
The Full Stack: Tools & Processes for Urban Data Scientists
Recently, I was asked to give talks at both UCL’s CASA and the ETH Future Cities Lab in Singapore for students and staff new to ‘urban data science’ and the sorts of workflows involved in collecting, processing, analysing, and reporting on urban geo-data. Developing the talk proved to be a rather enjoyable opportunity to reflect on more…
-
Plotting & iGraph on Lion and Mountain Lion
Note: this was previously posted at simulacra.info, but I am in the process of (re)organising my technical notes and tutorials. After giving up on Gephi (again, I really should learn), I decided it was time to get to grips with Python and iGraph since I really need to produce multiple iterations of a graph. The…
-
Extracting files from Moodle MBZ Archives with Python
These days it seems that just about every university is using Moodle, the “open-source community-based tools for learning”, to manage the delivery of course material and handling of deadlines, assignments, etc. Now I’m a fan of the OS community, but Moodle has… quirks.