All Posts

Python Rgonomics: User-defined functions in polars

rstats
python
tutorial
Polars provides a consistent API for conducting transformations against a DataFrame. But what do you do when you need to apply a user-defined function beyond the native API? This post surveys the patterns for transformation and aggregation with UDFs, including vector / object output, expression expansion, and when to break the abstraction with partitions and list comprehensions
Nov 16, 2025

MLOrbs?: MLOps in the database with orbital and dbt

rstats
python
dbt
sql
data
ml
Playing with the potential, perils, and design principles of deploying ML models into the analytical database using orbital’s sklearn-to-sql translation, sqlglot, and dbt
Aug 16, 2025

How Quarto embed fixes data science storytelling

workflow
rstats
python
quarto
rmarkdown
Literate programming excels at capturing our stream of conscience. Our stream of conscience does not excel at explaining the impact of our work. Notebooks enable some of data scientists’ worst tendencies in technical communication, but Quarto’s embed feature bridges the gap between reproducible research and resonate story-telling.
Jul 27, 2025

In my orbit: hacking orbital’s ML-to-SQL for xgboost

python
ml
The orbital package offers an interface for translating a fitted SciKitLearn pipeline to pure SQL for scaling predictions. In this tech note, I explore how this framework can (mostly) be used for xgboost models, as well, with a bit of wrangling (and a few limitations).
Jul 19, 2025

Python Rgonomics - 2025 Update

rstats
python
Switching languages is about switching mindsets - not just syntax. New developments in python data science toolings, like polars and seaborn’s object interface, can capture the ‘feel’ that converts from R/tidyverse love while opening the door to truly pythonic workflows. (Updated from 2025 for new tools).
Jan 26, 2025
No matching items