Public
Edited
Nov 2, 2022
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
urlsCsv
Insert cell
urls = new Map(urlsCsv.map(d => [dataCsv.columns.indexOf(d.id), d.url]))
Insert cell
dataCsv
Insert cell
dataCsv.columns
Insert cell
columns = dataCsv.columns.map(formatKey)
Insert cell
formatKey = d => d.replace(/\r/g,"").replace(/\n/g," ").replace(/- /g,"").replace(/\"/g,"").normalize()
Insert cell
data = dataCsv
.map(d => {
const values = Object.values(d)
values[11] = parseNumber(values[11])
return values
})
.filter(d => d[1] != "")
//.map(d => [...d])
//.map(d => (d[11] = parseNumber(d[11]), d))
Insert cell
parseNumber = d => parseInt((""+d).replace(/,/g, "").split(".")[0]) || undefined
Insert cell
parseNumber("61,876,000.00")
Insert cell
dataLookup = new Map(data.map(d => [d[1], d]))
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
<style>
h4 {margin: initial !important;}
<style>
Insert cell
paddingLeft = width * 0.3
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
data.filter(d => d[11] > 0)
Insert cell
Insert cell
sectorsColorsKeys = Object.keys(sectorsColors)
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
parseNumberTree("93.369.000€")
Insert cell
<style >
.observablehq p{ margin: inherit;}
</style>
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
view1 = html`
${draftsStacked.map(d => html`
<div style="margin-bottom: 2em">
<div style="margin-bottom: 0.5em"><b>${d.name}</b> ${d.date} <span style="white-space: nowrap;">(<a href="${d.url}" target="_blank">${d.lobbies.length} Kommentare</a>)</span></div>
${chartStacked(d.stack)}
</div>
`)}
`
Insert cell
Insert cell
Insert cell
Insert cell
import {fileInput} from "@mbostock/file-input"
Insert cell
import {swatches} from "@d3/color-legend"
Insert cell
import {form, formValue} from "@mbostock/form-input"
Insert cell
d3 = require("d3@6")
Insert cell

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.
Learn more