28:null 29:["$","title",null,{"children":"ZGF Data exploration | Flavio Gortana | Observable"}] 2e:[] 2c:{"id":"ff428e1058e074d2","slug":"zgf-data-exploration","title":"ZGF Data exploration","thumbnail":"cf557263bb4c7787b9ad2ef6c324f6a041d74d361989340a17183a2f7378e9d6","access_level":"public","create_time":"$D2018-03-14T16:53:43.474Z","update_time":"$D2019-11-05T18:46:06.321Z","view_time":null,"first_public_time":"$D2018-03-15T12:37:57.406Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"fdeadbc5c3f5c23e","login":"flave","name":"Flavio Gortana","avatar_url":"https://avatars-next.observableusercontent.com/409334ae1ad29f5dd3a962ab14304c798b963a4db0d8af5c8cf8df66fd10c141","tier":"starter_2024"},"version":575,"publish_version":575,"role":null,"authored":false,"authors":[{"type":"individual","id":"b100eec6dfd36590","login":"flave","name":"Flavio Gortana","avatar_url":"https://avatars-next.observableusercontent.com/409334ae1ad29f5dd3a962ab14304c798b963a4db0d8af5c8cf8df66fd10c141","tier":null}],"members":[{"type":"individual","id":"b100eec6dfd36590","login":"flave","name":"Flavio Gortana","avatar_url":"https://avatars-next.observableusercontent.com/409334ae1ad29f5dd3a962ab14304c798b963a4db0d8af5c8cf8df66fd10c141","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"ZGF Data exploration","cells":[{"id":0,"value":"md`# ZGF Data exploration`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":181,"value":"viewof expenseType = {\n const form = html``;\n form.value = {value: \"keyword\", label: \"Schlagwort\" };\n form.onchange = (e) => { \n form.value.value = e.target.value;\n form.value.label = e.target.alt;\n form.dispatchEvent(new CustomEvent(\"input\"));\n }\n return form;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":464,"value":"md`### Anzahl Ausgaben pro ${html`${expenseType.label}`}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":109,"value":"vegalite({\n data: { values: data },\n mark: 'bar',\n encoding: {\n x: { \n field: expenseType.value, \n type: \"ordinal\",\n scale: {rangeStep: 20},\n sort: {op: \"count\", order: \"descending\"}\n },\n y: { \n aggregate: \"count\", \n type: \"quantitative\", \n axis: {title: \"Anzahl Ausgaben\"}\n },\n color: {\n field: expenseType.value,\n type: \"nominal\"\n }\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":118,"value":"md`### Anzahl Ausgaben nach ${html`${expenseType.label}`}\nWie groß war das Budget für bestimmte Kategorien oder Kontinente?`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":40,"value":"vegalite({\n data: { values: data },\n mark: 'area',\n encoding: {\n x: { \n field: \"year\", \n type: \"ordinal\",\n scale: {rangeStep: 20}\n },\n y: { \n aggregate: \"count\", \n type: \"quantitative\", \n axis: {title: \"Anzahl\"},\n stack: \"center\"\n },\n color: { \n field: expenseType.value, \n type: \"nominal\",\n scale: {\"scheme\": \"category20b\"}\n },\n tooltip: {\n field: expenseType.value,\n type: \"nominal\"\n }\n },\n config: {\n area: {\n interpolate: \"cardinal\"\n }\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":469,"value":"md`### Vergleich von Anzahl an Ausgaben und Gesamtbudget pro Projekt\nWeit oben = hohes Gesamtbudget\n\nWeit rechts = viele Ausgaben`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":311,"value":"vegalite({\n data: { values: refinedData },\n mark: 'circle',\n transform: [\n\t{\n \tfilter: \"datum.project_id\",\n \t},\n \t{\n aggregate: [{\n field: \"budget_euro\",\n op: \"sum\",\n as: \"project_budget\"\n },{\n field: \"project_id\",\n op: \"count\",\n as: \"expenses\"\n }],\n groupby: [\"project_id\"]\n }],\n encoding: {\n x: {\n field: \"expenses\",\n type: \"quantitative\"\n },\n y: {\n field: \"project_budget\",\n type: \"quantitative\"\n }\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":450,"value":"md`### Dauer der Projekt \nScheint noch etwas falsch zu sein. Wahrscheinlich fehler in meiner Berechnung.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":456,"value":"vegalite({\n data: { values: refinedData },\n transform: [\n\t{\n \tfilter: \"datum.project_id\",\n \t},\n \t{\n\t aggregate: [{\n\t\t field: \"year\",\n\t \t op: \"min\",\n\t\t as: \"project_start\"\n\t },\n {\n\t \t field: \"year\",\n \t\t op: \"max\",\n\t\t as: \"project_end\"\n\t }],\n \tgroupby: [\"project_id\"]\n \t},\n {\n calculate: \"datum.project_end - datum.project_start\",\n as: \"project_duration\"\n }\n ],\n vconcat: [{\n mark: \"tick\",\n \tencoding: {\n \tx: {\n field: \"project_duration\",\n type: \"quantitative\"\n }\n }\n }],\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"md`----\n### 3rd party libraries`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"data = d3Fetch.csv(\"https://gist.githubusercontent.com/Flave/164e517b2140011b5b7be19e9e82b655/raw/57ee1a715e9137f1aca436cb20155273354c61bd/gistfile1.csv\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":272,"value":"refinedData = data.map((d) => ({\n\t...d,\n\tbudget_euro: d.budget_euro ? parseFloat(d.budget_euro.replace(\",\", \"\").replace(\"€\", \"\")) : undefined\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"value":"d3Fetch = require(\"d3-fetch@1\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":31,"value":"vegalite = require(\"@observablehq/vega-lite@0.1\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":448,"value":"_ = require('lodash')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W2e","stdlib":"1","titling":"auto"}} 2d:"$2c:body"