Non-SQL in your DBT pipelineDBT forces you to use SQL, even when Python or R transformations are clearerMar 31, 20221Mar 31, 20221
The “Pandas Way” is the functional APIWith Pandas ≥ 1.0, the functional API is powerful and should be the new standardMar 30, 20221Mar 30, 20221
Published inTowards 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
Published inTowards Data ScienceProgramming with dplyrWith dplyr version 1.0, there are new ways that you can write functionsNov 8, 2021Nov 8, 2021
Published inTowards 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
I 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
Published inTowards 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
Published inTowards 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
Observable 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