4 Ways To Pivot Data With SQL
Easy ways to pivot data with SQL in DuckDB (and others) and visualize the results in Plotly heatmap
Published in
8 min readDec 5, 2023
Not a Medium member? Use the Friend Link to read this article!
Since I’ve started looking into my data and trying to make sense out of it, I’ve came to appreciate heatmap plots more and more. They are an excellent way to observe patterns and to get a first impression on a certain topic. I’ve used them for monitoring my energy production and consumption (here), my Medium visitors (here) and…
