Andy ReaganNon-SQL in your DBT pipelineDBT forces you to use SQL, even when Python or R transformations are clearerMar 31, 20221Mar 31, 20221
Andy ReaganThe “Pandas Way” is the functional APIWith Pandas ≥ 1.0, the functional API is powerful and should be the new standardMar 30, 20221Mar 30, 20221
Andy ReaganinTowards Data ScienceBusiness logic in DBTThere are many possibilities for implementing custom logic, and this framework can help you sort through the options.Mar 14, 20222Mar 14, 20222
Andy ReaganinTowards Data ScienceProgramming with dplyrWith dplyr version 1.0, there are new ways that you can write functionsNov 8, 2021Nov 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.Jul 2, 2021Jul 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…Apr 28, 2021Apr 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.Oct 15, 20203Oct 15, 20203
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…Sep 24, 2020Sep 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…Sep 16, 2020Sep 16, 2020