Public
Edited
Mar 5, 2023
// convert wide data to tidy data
// What if the penguin observations where made for each variable with a number seperately?
penguinDataLong = {
const data = penguinData;
const columns = Object.keys(penguinData[0]).slice(2, 6);
return Object.assign(
columns.flatMap((key) =>
data.map((d) => ({
species: d.species,
island: d.island,
sex: d.sex,
key,
value: d[key]
}))
)
).flat();
}
// arquero has a convenient `fold` method for this
penguinDataLong2 = {
const columns = Object.keys(penguinData[0]).slice(2, 6);
return aq.from(penguinData).fold(columns).view();
// .objects() // you can get the objects by replacing .view() with .objects()
}
// vanilla JS
penguinData
.map((d) => d.species)
.reduce((acc, e) => ((acc[e] = (acc[e] || 0) + 1), acc), {})
// vanilla JS with a Map
penguinData
.map((d) => d.species)
.reduce((acc, e) => acc.set(e, (acc.get(e) || 0) + 1), new Map())
// with d3.rollup
d3.rollup(
penguinData,
(v) => v.length,
(d) => d.species
)
// with Ramda
R.countBy((d) => d.species, penguinData)
// with Arquero
aq.from(penguinData)
.groupby("species")
.rollup({
count: op.count()
})
.view()
aq
.from(penguinDataLong)
.groupby("species", "key")
.rollup({
average: op.average("value"),
})
.view()
averagesMap = d3.rollup(
bla.filter((d) => !d.checkedDontKnow),
(a) => d3.sum(a, (d) => d.value) / a.length,
(d) => d.factor, // key1
(d) => d.actor_id
)
Array.from(averagesMap, ([factor, actors]) => ({
factor: factor,
...Object.fromEntries(actors) // maps each of cities.keys() to each of cities.values()
}))
Array.from(
d3.rollup(
bla.filter((d) => !d.checkedDontKnow),
(a) => d3.sum(a, (d) => d.value) / a.length,
(d) => d.factor, // key1
(d) => d.actor_id
),
([factor, actors]) => ({
factor: factor,
...Object.fromEntries(actors) // maps each of cities.keys() to each of cities.values()
})
)
penguinData
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.
