Andy ReaganNon-SQL in your DBT pipelineDBT forces you to use SQL, even when Python or R transformations are clearer2 min read·Mar 31, 2022--1--1
Andy ReaganThe “Pandas Way” is the functional APIWith Pandas ≥ 1.0, the functional API is powerful and should be the new standard·2 min read·Mar 30, 2022--1--1
Andy ReaganinTowards Data ScienceBusiness logic in DBTThere are many possibilities for implementing custom logic, and this framework can help you sort through the options.4 min read·Mar 14, 2022--2--2
Andy ReaganinTowards Data ScienceProgramming with dplyrWith dplyr version 1.0, there are new ways that you can write functions4 min read·Nov 8, 2021----
Andy ReaganinTowards Data ScienceEmbed Observable NotebooksUse all of the cool examples with your own data, while keeping that data local or inside your network.4 min read·Jul 2, 2021----
Andy ReaganI really enjoyed your post, very helpful.One thing that is potentially confusing is that some of the data.table operations you show work in-place, and the dplyr ones don't. For…1 min read·Apr 28, 2021----
Andy ReaganinTowards Data ScienceHomebrew and Pyenv Python Playing Pleasantly in PartnershipHow to use pyenv’s Python to satisfy Homebrew dependencies so only pyenv manages Python 3 installations on your machine.3 min read·Oct 15, 2020--3--3
Andy ReaganAccessing the D3 documentation for older versionsD3 moves fast:2 min read·Sep 24, 2020----
Andy ReaganinTowards Data ScienceVectorizing code mattersI come from the world of MATLAB and numerical computing, where for loops are shorn and vectors are king. During my PhD at UVM, Professor…4 min read·Sep 24, 2020----
Andy ReaganObservable with local files and FlaskWe’re relying heavily on Observable for the most recent edition of Berkeley MIDS W209: Information Visualization. While Observable is a…5 min read·Sep 16, 2020----