montreal_2014.html
4.91 KB
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
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
<!DOCTYPE html>
<html>
<head>
<title>Pivot Demo</title>
<!-- external libs from cdnjs -->
<link rel="stylesheet" type="text/css" href="https://cdnjs.cloudflare.com/ajax/libs/c3/0.4.11/c3.min.css">
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jqueryui/1.11.4/jquery-ui.min.js"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/PapaParse/4.1.2/papaparse.min.js"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/d3/3.5.5/d3.min.js"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/c3/0.4.11/c3.min.js"></script>
<!-- PivotTable.js libs from ../dist -->
<link rel="stylesheet" type="text/css" href="../dist/pivot.css">
<script type="text/javascript" src="../dist/pivot.js"></script>
<script type="text/javascript" src="../dist/c3_renderers.js"></script>
<script type="text/javascript" src="../dist/export_renderers.js"></script>
<style>
body { font-family: Verdana; }
.c3-line, .c3-focused {stroke-width: 3px !important;}
.c3-bar {stroke: white !important; stroke-width: 1;}
.c3 text { font-size: 12px; color: grey;}
.tick line {stroke: white;}
.c3-axis path {stroke: grey;}
.c3-circle { opacity: 1 !important; }
.c3-xgrid-focus {visibility: hidden !important;}
</style>
<!-- optional: mobile support with jqueryui-touch-punch -->
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jqueryui-touch-punch/0.2.3/jquery.ui.touch-punch.min.js"></script>
<!-- for examples only! script to show code to user -->
<script type="text/javascript" src="show_code.js"></script>
</head>
<body>
<script type="text/javascript">
// This example loads the "Montreal Weather 2014" dataset
// from a CSV and shows date handling with derivers and
// sort overriding. This example also features custom
// aggregators with custom formatting, C3 Charts, hidden
// attributes and a custom heatmap color-scale.
$(function () {
var dateFormat = $.pivotUtilities.derivers.dateFormat;
var sortAs = $.pivotUtilities.sortAs;
var tpl = $.pivotUtilities.aggregatorTemplates;
var fmt = $.pivotUtilities.numberFormat({suffix: " °C"});
Papa.parse("montreal_2014.csv", {
download: true,
skipEmptyLines: true,
complete: function(parsed){
$("#output").pivotUI(parsed.data, {
hiddenAttributes: ["Date","Max Temp (C)","Mean Temp (C)",
"Min Temp (C)" ,"Total Rain (mm)","Total Snow (cm)"],
derivedAttributes: {
"month name": dateFormat("Date", "%n", true),
"day name": dateFormat("Date", "%w", true)
},
rows: ["day name"],
cols: ["month name"],
sorters: {
"month name": sortAs(["Jan","Feb","Mar","Apr", "May",
"Jun","Jul","Aug","Sep","Oct","Nov","Dec"]),
"day name": sortAs(["Mon","Tue","Wed", "Thu","Fri",
"Sat","Sun"])
},
aggregators: {
"Mean Temperature":
function() { return tpl.average(fmt)(["Mean Temp (C)"])},
"Max Temperature":
function() { return tpl.max(fmt)(["Max Temp (C)"]) },
"Min Temperature":
function() { return tpl.min(fmt)(["Min Temp (C)"]) }
},
renderers: $.extend(
$.pivotUtilities.renderers,
$.pivotUtilities.c3_renderers,
$.pivotUtilities.export_renderers
),
rendererName: "Heatmap",
rendererOptions: {
heatmap: {
colorScaleGenerator: function(values) {
return d3.scale.linear()
.domain([-35, 0, 35])
.range(["#77F", "#FFF", "#F77"])
}
}
}
});
}
});
});
</script>
<p><a href="index.html">« back to PivotTable.js examples</a></p>
<div id="output" style="margin: 10px;"></div>
</body>
</html>