Responsive Pivot Table¶

%matplotlib inline
from verticapy.datasets import load_titanic
titanic = load_titanic()
titanic.hchart(x = "pclass",
               y = "survived",
               z = "COUNT(*)",
               kind = "heatmap")

%load_ext verticapy.hchart

%%hchart -type heatmap
SELECT 
    pclass,
    survived,
    COUNT(*)
FROM titanic GROUP BY 1, 2;