date_range 11/05/2022 12:24

Quick script to add a summary page to any Excel containing homogeneous data over multiple sheets, with some useful links and formatting for an enhanced end user experience

date_range 11/05/2022 11:03

Powerful one liner to convert column number into Excel column letter(s)

date_range 10/05/2022 10:34

Enumerate and Zip are 2 powerful functions available in python when looping over lists.

date_range 06/05/2022 08:37

If you don’t know what DBT is just unravel the acronym and you will have a good understanding of it, Data Build Tool.

date_range 25/03/2022 13:08

Loading a excel with multiple sheets into a single database table with Python quick and easy.