Analytical – Honest – Passionate
Data Ops, AKA Dev Ops for data. Essential content for learning about improving the velocity of development and effective maintenance of data products (products produced by data teams). Christopher Bergh …
Pandas is the go to library in Python for analysing and manipulating data. This post lists some useful video resources for learning this package. Brandon Rhodes – Pandas From The …
SQL is a great language for analysing and slicing and dicing data. The folks at Google who build Google Sheets appreciate this too. So much so that they have built …
An example of how to run multiple queries in parallel.
With the bq command line tool moving multiple tables at a time from one BigQuery dataset to another can be done with a few lines of code. The tool can …
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 …
A lightweight example of saving some logs to an SQLite database in a python script.
A short guide to adding user authentication to Streamlit apps. So you’ve created a beautiful Streamlit app which your users love, but only certain people should be able to access …