Postgres to DataFrame, Ten Years Later
Ten years after my pandas and Postgres post, the same job with Polars 2.0: reading, batching and querying Bluesky data with SQL
Writing on data engineering, the outdoors, and technology.
Long-form thoughts on data engineering and software development, alongside walk reports, climbing days, and time spent in the hills.
Yr Wyddfa via the Watkin Path
A long day up Yr Wyddfa by the Watkin Path - the first officially designated footpath in Great Britain.
East Ridge, Beinn a' Chaorainn
A winter traverse of Beinn a Chaorainn via the east ridge - a classic Grade I/II route in good snow conditions.
Combining rasters with rasterio
Use rasterio to combine raster files
Matplotlib in Virtualenv
Fixing Matplotlib plotting in virtualenvs.
NLP Analysis of Welsh Assembly Proceedings
Using NLP to analyse political discourse in Wales' National Assembly
Fitbit Data Analysis
Analyse your heart rate with Fitbit, Python and Pandas.
Setting up Python on Ubuntu
Install Python on an Ubuntu EC2 instance.
Jupyter Progress Bars
Create a Jupyter notebook progress bar.
Connecting to Postgres with Pandas and Jupyter
Read SQL into a Pandas dataframe
Using the data.police.uk API with Leaflet (part 2)
Geocode addresses and postcodes to find crime statistics for a location.
A basic Leaflet.js map in Jekyll
Add a leaflet map to your Jekyll blog.
Using the data.police.uk API with Leaflet
Map Police neighbourhoods and their crime statistics with Leaflet.