Responsive Pivot Table

In [13]:
%matplotlib inline
from verticapy.datasets import load_titanic

titanic = load_titanic()

titanic.hchart(x = "pclass",
               y = "survived",
               z = "COUNT(*)",
               kind = "heatmap")
Out[13]:
In [2]:
%load_ext verticapy.vCharts
In [16]:
%%vCharts -type heatmap
SELECT 
    pclass,
    survived,
    COUNT(*)
FROM titanic GROUP BY 1, 2;
Execution: 0.199s
Out[16]: