-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathpivot-table.html
69 lines (69 loc) · 2.96 KB
/
pivot-table.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
<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>