
Itsamejoshab
@itsamejoshabee
ID: 1520124876312530946
29-04-2022 19:36:40
19 Tweet
34 Takipçi
13 Takip Edilen





When working with time-series data, sometimes there are missing values Fill down the last known value with LAST_VALUE ( ... IGNORE NULLS ) OVER ( ORDER BY ... ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW ) Itsamejoshab explains medium.com/@jberry_33001/… #SQL





Some tasks have non-obvious solutions in #SQL Itsamejoshab explains how to solve these 5 Date spines - generating missing values Pivot / unpivot One-hot encoding to map values Market basket analysis Time-series aggregations kdnuggets.com/2022/07/5-hard…



. Itsamejoshab outlines lesser known SQL transforms and why they might be useful. buff.ly/3fRuTHn


Python patterns only beginners use codecalamity.com/python-pattern… via Chris Griffith


I still owe Vu Truong $20, anyone know if he still has the same PO Box from 1994? David King