Category: Uncategorised
Uncategorised
Using SQL in pandas with duckdb
A code snippet showing how to use SQL to query a pandas dataframe using duckdb. See this post by duckdb. SQL logic, functions and syntax fit my brain better than …
Uncategorised
Export Google Sheets to pdf and send over Google chat
Situation A beautiful report has been created in Google Sheets. The spreadsheet is exported to a pdf format and circulated with the relevant people via a Google Chat space. Complication …
Uncategorised
Self Hosting Video on Digital Ocean
Recently I have been playing around with Spaces on Digital Ocean. This is Digital Oceans version of object storage (think S3 for Amazon or Google Cloud Storage). Spaces comes with …