pivot-table.html

<html>
    <head>
        <script src='anim.js'></script>
        <script>
            window.addEventListener( 'load', function () {
                addBoxes(
                    'First',        1, 0,     0, 2,
                    'Last',         2, 0,     1, 2, { w1 : 2, w2 : 2 },
                    'Customer',     4, 0,     1, 1, { w1 : 2, w2 : 2 },
                    'Sale',         6, 0,     3, 0, { w2 : 4 },
                    '',             0, 0, -1000, 0,
                    '',         -1000, 0,     3, 2, { w2 : 2 },
                    '',         -1000, 0,     5, 2, { w2 : 2 },
                    '',         -1000, 0,     0, 0,
                    '',         -1000, 0,     1, 0, { w2 : 2 },
                    '',         -1000, 0,     0, 1,
                    '0',            0, 1, -1000, 1,
                    '1',            0, 2, -1000, 1,
                    '2',            0, 3, -1000, 1,
                    '3',            0, 4, -1000, 2,
                    '4',            0, 5, -1000, 2,
                    '5',            0, 6, -1000, 2,
                );
                setColor( '#dddddd' );
                addBoxes(
                    'Amy', 1, 1, 0, 3,
                    'Amy', 1, 2, 0, 3,
                    'Amy', 1, 3, 0, 3,
                    'Bob', 1, 4, 0, 4,
                    'Bob', 1, 5, 0, 4,
                    'Bob', 1, 6, 0, 4,
                );
                addBoxes(
                    'Smith', 2, 1, 1, 3, { w1 : 2, w2 : 2 },
                    'Smith', 2, 2, 1, 3, { w1 : 2, w2 : 2 },
                    'Smith', 2, 3, 1, 3, { w1 : 2, w2 : 2 },
                    'Jones', 2, 4, 1, 4, { w1 : 2, w2 : 2 },
                    'Jones', 2, 5, 1, 4, { w1 : 2, w2 : 2 },
                    'Jones', 2, 6, 1, 4, { w1 : 2, w2 : 2 },
                );
                setColor( '#ddddff' );
                addBoxes(
                    'Facebook',  4, 1, 3, 1, { w1 : 2, w2 : 2 },
                    'Amazon',    4, 2, 5, 1, { w1 : 2, w2 : 2 },
                    'Facebook',  4, 3, 3, 1, { w1 : 2, w2 : 2 },
                    'Amazon',    4, 4, 5, 1, { w1 : 2, w2 : 2 },
                    'Facebook',  4, 5, 3, 1, { w1 : 2, w2 : 2 },
                    'Amazon',    4, 6, 5, 1, { w1 : 2, w2 : 2 },
                );
                setColor( '#ddffdd' );
                addBoxes(
                    '39', 6, 1, 3, 3, { w2 : 2 },
                    '68', 6, 2, 5, 3, { w2 : 2 },
                    '10', 6, 3, 3, 3, { w2 : 2 },
                    '93', 6, 4, 5, 4, { w2 : 2 },
                    '85', 6, 5, 3, 4, { w2 : 2 },
                    '20',  6, 6, 5, 4, { w2 : 2 },
                    '49', -1000, 0, 3, 3, { w2 : 2 },
                    '113', -1000, 0, 5, 4, { w2 : 2 },
                );
            } );
        </script>
    </head>
    <body>
        <h1>Pivot Table</h1>
        <pre>df.pivot_table( index=["First","Last"], columns="Customer", values="Sale", aggfunc="sum" )</pre>
        <hr/>
    </body>
</html>