Aggregations in JavaScript
How to use D3.js-based Aggregates in Plotly.js.
New to Plotly?
Plotly is a free and open-source graphing library for JavaScript. We recommend you read our Getting Started guide for the latest installation or upgrade instructions, then move on to our Plotly Fundamentals tutorials or dive straight in to some Basic Charts tutorials.
Note: transforms
are deprecated and will be removed in a future version of Plotly.js
var subject = ['Moe','Larry','Curly','Moe','Larry','Curly','Moe','Larry','Curly','Moe','Larry','Curly']
var score = [1,6,2,8,2,9,4,5,1,5,2,8]
var data = [{
type: 'scatter',
x: subject,
y: score,
mode: 'markers',
transforms: [{
type: 'aggregate',
groups: subject,
aggregations: [
{target: 'y', func: 'avg', enabled: true},
]
}]
}]
Plotly.newPlot('myDiv', data)
var subject = ['Moe','Larry','Curly','Moe','Larry','Curly','Moe','Larry','Curly','Moe','Larry','Curly']
var score = [1,6,2,8,2,9,4,5,1,5,2,8]
var data = [{
type: 'scatter',
x: subject,
y: score,
mode: 'markers',
transforms: [{
type: 'aggregate',
groups: subject,
aggregations: [
{target: 'y', func: 'avg', enabled: true},
]
}]
}]
layout = {
title: '<b>Plotly Aggregations</b><br>use dropdown to change aggregation',
xaxis: {title: 'Subject'},
yaxis: {title: 'Score', range: [0,22]},
height: 600,
width: 900,
updatemenus: [{
x: 0.85,
y: 1.15,
xref: 'paper',
yref: 'paper',
yanchor: 'top',
active: 0,
showactive: false,
buttons: [{
method: 'restyle',
args: ['transforms[0].aggregations[0].func', 'avg'],
label: 'Avg'
}, {
method: 'restyle',
args: ['transforms[0].aggregations[0].func', 'sum'],
label: 'Sum'
}, {
method: 'restyle',
args: ['transforms[0].aggregations[0].func', 'min'],
label: 'Min'
}, {
method: 'restyle',
args: ['transforms[0].aggregations[0].func', 'max'],
label: 'Max'
}, {
method: 'restyle',
args: ['transforms[0].aggregations[0].func', 'mode'],
label: 'Mode'
}, {
method: 'restyle',
args: ['transforms[0].aggregations[0].func', 'median'],
label: 'Median'
}, {
method: 'restyle',
args: ['transforms[0].aggregations[0].func', 'count'],
label: 'Count'
}, {
method: 'restyle',
args: ['transforms[0].aggregations[0].func', 'stddev'],
label: 'Std.Dev'
}, {
method: 'restyle',
args: ['transforms[0].aggregations[0].func', 'first'],
label: 'First'
}, {
method: 'restyle',
args: ['transforms[0].aggregations[0].func', 'last'],
label: 'Last'
}]
}]
}
Plotly.newPlot('myDiv', data, layout)
d3.csv("https://plotly.com/~public.health/17.csv", function(err, rows){
function unpack(rows, key) {
return rows.map(function(row) { return row[key]; });
}
trace1 = {
x: unpack(rows, 'date'),
autobinx: false,
autobiny: true,
marker: {color: 'rgb(68, 68, 68)'},
name: 'date',
type: 'histogram',
xbins: {
end: '2016-12-31 12:00',
size: 'M1',
start: '1983-12-31 12:00'
}
};
data = [trace1];
layout = {
paper_bgcolor: 'rgb(240, 240, 240)',
plot_bgcolor: 'rgb(240, 240, 240)',
title: '',
xaxis: {
autorange: true,
range: ['1984-07-01 06:00', '2016-07-30 18:00'],
title: '',
type: 'date'
},
yaxis: {
autorange: true,
range: [0, 92.6315789474],
title: 'Shootings incidents',
type: 'linear'
},
updatemenus: [{
x: 0.1,
y: 1.15,
xref: 'paper',
yref: 'paper',
yanchor: 'top',
active: 0,
showactive: true,
buttons: [{
args: ['xbins.size', 'M1'],
label: 'Month',
method: 'restyle',
}, {
args: ['xbins.size', 'M3'],
label: 'Quater',
method: 'restyle',
}, {
args: ['xbins.size', 'M6'],
label: 'Half Year',
method: 'restyle',
}, {
args: ['xbins.size', 'M12'],
label: 'Year',
method: 'restyle',
}]
}]
};
Plotly.newPlot('myDiv', data, layout);
});
d3.csv('https://raw.githubusercontent.com/bcdunbar/datasets/master/worldhappiness.csv', function(err, rows){
function unpack(rows, key) {
return rows.map(function(row) { return row[key]; });
}
var data = [{
type: 'choropleth',
locationmode: 'country names',
locations: unpack(rows, 'Country'),
z: unpack(rows, 'HappinessScore'),
autocolorscale: false,
reversescale: true,
colorscale: 'Portland',
transforms: [{
type: 'aggregate',
groups: unpack(rows, 'Country'),
aggregations: [
{target: 'z', func: 'avg', enabled: true},
]
}]
}];
var layout = {
title: '<b>World Happiness</b><br>2015 - 2017',
geo: {
showframe: false,
showcoastlines: false,
projection:{
type: 'orthographic'
}
},
updatemenus: [{
x: 0.85,
y: 1.15,
xref: 'paper',
yref: 'paper',
yanchor: 'top',
active: 0,
showactive: true,
buttons: [{
method: 'restyle',
args: ['transforms[0].aggregations[0].func', 'avg'],
label: 'Avg'
}, {
method: 'restyle',
args: ['transforms[0].aggregations[0].func', 'sum'],
label: 'Sum'
}, {
method: 'restyle',
args: ['transforms[0].aggregations[0].func', 'min'],
label: 'Min'
}, {
method: 'restyle',
args: ['transforms[0].aggregations[0].func', 'max'],
label: 'Max'
}, {
method: 'restyle',
args: ['transforms[0].aggregations[0].func', 'mode'],
label: 'Mode'
}, {
method: 'restyle',
args: ['transforms[0].aggregations[0].func', 'median'],
label: 'Median'
}, {
method: 'restyle',
args: ['transforms[0].aggregations[0].func', 'first'],
label: 'First'
}, {
method: 'restyle',
args: ['transforms[0].aggregations[0].func', 'last'],
label: 'Last'
}]
}]
};
Plotly.newPlot('myDiv', data, layout);
});