Pack and unpack tabular dataLocation InputForeignObject exporting issueConvert observable code to normal JavascriptPersistent Select InputContinent SelectorInputs in gridMatrix InputFetcher usageComments on notebooksData driven range slidersObservableHQ built in datasetsUtils UsageStylesFetcherUtilsInstant Data Visualizer
GroupBy we deserve 🦇
import {group} from "@bumbeishvili/utils"
data = require("@observablehq/cars")
group(data)
.by(d=>d.Year)
.run()
result = group(data)
.by(d=>d.Year,d=>d.Horsepower)
.run()
group(data)
.by(d=>d.Year,d=>d.Horsepower,d=>d.Acceleration)
.orderBy(d=>d.keys[2])
.run()
group(data)
.by(d=>d.Year)
.sort(null)
.run()
group(data)
.by(d=>d.Year)
.sort((a,b)=>a.key>b.key?1:-1)
.run()
group(data)
.by(d=>d.Year)
.orderBy(d=>d.key)
.run()
group(data)
.by(d=>d.Year)
.orderByDescending(d=>d.key)
.run()
group(data)
.by(d=>d.Year)
.orderBy(d=>d.key)
.run() // This returns array
.map(grouped=>{
const horses = grouped.values.map(d=>d.Horsepower);
const sum = horses.reduce((a,b)=>a+b);
const avg = sum/grouped.values.length;
const max = Math.max(...horses);
const min = Math.min(...horses);
return Object.assign(
{min,max,sum,avg},
grouped,
)
})
groupF = {
const groupByFunction = function(arr) {
const operations = [];
const initialData = arr;
const resultObj = {};
let resultArr;
let sort = function(a, b) {
return a.values.length < b.values.length ? 1 : -1
}
groupByFunction.by = function(groupFuncs) {
const length = arguments.length;
for (let j = 0; j < initialData.length; j++) {
const dataObj = initialData[j];
const keys = [];
for (let i = 0; i < length; i++) {
const key = arguments[i];
keys.push(key(dataObj,j));
}
const strKey = JSON.stringify(keys);
if (!resultObj[strKey]) {
resultObj[strKey] = [];
}
resultObj[strKey].push(dataObj)
}
operations.push('by')
return groupByFunction;
}
groupByFunction.orderBy = function(func) {
sort = function(a, b) {
var a = func(a);
var b = func(b);
if (typeof a === 'string' || a instanceof String) {
return a.localeCompare(b);
}
return a - b;
};
operations.push('orderBy')
return groupByFunction;
}
groupByFunction.orderByDescending = function(func) {
sort = function(a, b) {
var a = func(a);
var b = func(b);
if (typeof a === 'string' || a instanceof String) {
return a.localeCompare(b);
}
return b - a;
};
operations.push('orderByDescending')
return groupByFunction;
}
groupByFunction.sort = function(v) {
sort = v;
operations.push('sort')
return groupByFunction;
}
groupByFunction.run = function() {
operations.forEach(operation=>{
console.log(operation);
})
resultArr = Object
.keys(resultObj)
.map(k => {
const result = {}
const keys = JSON.parse(k);
if (keys.length == 1) {
result.key = keys[0];
} else {
result.keys = keys
}
result.values = resultObj[k]
return result;
});
if (sort) {
resultArr.sort(sort);
}
return resultArr;
}
return groupByFunction;
}
return groupByFunction;
}
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
