25:["$","title",null,{"children":"Dirk Präsentation Weekends | Adrian Zachariae | Observable"}] 49:Te8f,tripsvtemp_lineplot = Object({ width: 700, height: 600, padding: 5, config: { axis: { labelFont: "Helvetica Neue", titleFont: "Helvetica Neue", gridColor: "#CCC", labelColor: "#333", tickColor: "#CCC", titleColor: "#333", domain: false, labelFontSize: 12, tickSize: 8 } }, scales: [ { name: "y", type: "linear", domain: { data: "raw_data", field: "trips" }, range: "height", nice: true, zero: false }, { name: "x", type: "linear", domain: { data: "raw_data", field: "temp_mean" }, range: "width", nice: true }, { name: "color", type: "ordinal", domain: ['2019', '2020', '2021'], range: ["#333", "#30a2da", "#fc4f30"], legend: true } ], axes: [ { orient: "left", scale: "y", title: "trips", format: '.2s', grid: true }, { orient: "bottom", scale: "x", title: "temperature [°C]", format: '.2s', grid: true } ], legends: [ { type: "symbol", title: "Year", symbolType: 'circle', fill: "color", direction: "vertical" } ], marks: [ { type: "group", from: { facet: { name: "glines", data: "raw_data", groupby: "year" } }, marks: [ { type: "line", name: 'interpol_line', from: { data: "glines" }, encode: { enter: { interpolate: { value: "catmull-rom" }, y: { scale: "y", field: "trips" }, x: { scale: "x", field: "temp_mean" }, stroke: { scale: 'color', field: 'year' }, strokeWidth: { value: 1 } } }, zindex: 0 } ] }, { type: "symbol", name: 'points', from: { data: "raw_data" }, encode: { enter: { y: { scale: "y", field: "trips" }, x: { scale: "x", field: "temp_mean" }, fill: { scale: 'color', field: 'year' }, stroke: { value: "#FFF" }, strokeWidth: { value: 1.4 }, size: { value: 70 } } }, zindex: 8 }, { type: "text", from: { data: "points" }, name: "label", encode: { enter: { text: { field: 'datum.date_label' }, fontSize: { value: 8 }, font: { value: "Helvetica Neue" }, fill: { scale: 'color', field: 'datum.year' }, stroke: { value: 'white' }, strokeWidth: { value: 1.5 } } }, transform: [ { type: "label", offset: [1, 5, 10], size: { signal: "[width + 500, height]" } } ], zindex: 9 }, { type: "text", from: { data: "points" }, encode: { enter: { text: { field: 'datum.date_label' }, fontSize: { value: 8 }, font: { value: "Helvetica Neue" }, fill: { scale: 'color', field: 'datum.year' }, stroke: { value: null } } }, transform: [ { type: "label", offset: [1, 5, 10], size: { signal: "[width + 500, height]" } } ], zindex: 10 }, { type: "rule", from: { data: "label" }, encode: { enter: { x: { field: "datum.x" }, y: { field: "datum.y" }, x2: { field: "x" }, y2: { field: "y" }, stroke: { value: '#AAA' }, strokeWidth: { value: 1 } } }, zindex: { value: -3 } } ] })4a:T595,wetter_HH = { // create and register a date parser under the name 'parse_mdy' // use { override: true } to suppress errors if we re-evaluate this cell aq.addFunction('parse_YYYYMMDD', d3.utcParse('%Y%m%d'), { override: true }); aq.addFunction('formatd3', d3.timeFormat('%b %d'), { override: true }); const weather_2021 = aq .fromCSV( (await FileAttachment( 'produkt_klima_tag_20191016_20210417_01975.txt' ).text()).replaceAll(/[ ]+/g, ''), { delimiter: ';' } ) .derive({ date: d => op.parse_YYYYMMDD(d.MESS_DATUM), temp_mean: d => d.TMK, temp_high: d => d.TXK, temp_night: d => d.TNK }) .derive({ date_label: d => op.formatd3(d.date) }) .select('date', 'date_label', 'temp_high', 'temp_mean', 'temp_night'); const weather_hist = aq .fromCSV( (await FileAttachment( 'produkt_klima_tag_19360101_20201231_01975.txt' ).text()).replaceAll(/[ ]+/g, ''), { delimiter: ';' } ) .derive({ date: d => op.parse_YYYYMMDD(d.MESS_DATUM), temp_mean: d => d.TMK, temp_high: d => d.TXK, temp_night: d => d.TNK }) .filter(d => d.date < op.datetime(2019, 9, 16)) .filter(d => d.date > op.datetime(2018, 11, 31)) .derive({ date_label: d => op.formatd3(d.date) }) .select('date', 'date_label', 'temp_high', 'temp_mean', 'temp_night'); return weather_2021.concat(weather_hist); }4b:T515,wetter_FU = { // create and register a date parser under the name 'parse_mdy' // use { override: true } to suppress errors if we re-evaluate this cell aq.addFunction('parse_YYYYMMDD', d3.utcParse('%Y%m%d'), { override: true }); aq.addFunction('formatd3', d3.timeFormat('%b %d'), { override: true }); const weather_2021 = aq .fromCSV( (await FileAttachment('FU_wetter.tsv').text()).replaceAll(/[ ]+/g, ',') ) .derive({ date: d => op.parse_YYYYMMDD(d.JJJJMMDD), temp_mean: d => d.TM, temp_high: d => d.TX, temp_night: d => d.TN, rain_mm: d => d.RR, pressure: d => d.PM }) .derive({ date_label: d => op.formatd3(d.date) }) .select('date', 'date_label', 'temp_high', 'temp_mean', 'temp_night'); const weather_hist = aq .fromCSV( (await FileAttachment( 'produkt_klima_tag_19500101_20201231_00403@1.txt' ).text()).replaceAll(/[ ]+/g, ''), { delimiter: ';' } ) .derive({ date: d => op.parse_YYYYMMDD(d.MESS_DATUM), temp_mean: d => d.TMK, temp_high: d => d.TXK, temp_night: d => d.TNK }) .derive({ date_label: d => op.formatd3(d.date) }) .select('date', 'date_label', 'temp_high', 'temp_mean', 'temp_night'); return weather_2021.concat(weather_hist); }4c:[{"id":"1192b4d1873a66b68b08bead4eca9f5e093336121fc3ea7a9ae214018ea1ca3eab6e4aeebe2c7ca14ca015b9bb23504e5054b68a4ca97ae387362ad82e214117","href":"https://static.observableusercontent.com/files/1192b4d1873a66b68b08bead4eca9f5e093336121fc3ea7a9ae214018ea1ca3eab6e4aeebe2c7ca14ca015b9bb23504e5054b68a4ca97ae387362ad82e214117","name":"produkt_klima_tag_19360101_20201231_01975.txt","type":"text/plain","lastModified":1618778488650.665,"size":4403640},{"id":"788bebcadb9de61dc52fad297dc78ffc00fe120e2b9400ffeeebcfa2e1dfe2458ce6d42e8fa0631f9e48308e627e4f87545f2d09c38e2d7b8fdeb234ceacebea","href":"https://static.observableusercontent.com/files/788bebcadb9de61dc52fad297dc78ffc00fe120e2b9400ffeeebcfa2e1dfe2458ce6d42e8fa0631f9e48308e627e4f87545f2d09c38e2d7b8fdeb234ceacebea","name":"weekdays_ml_berlin_hour@1.csv","type":"text/csv","lastModified":1618778488650.665,"size":400216},{"id":"e3bcc33e43b59102ccd52077b10b312e9ce7e5aa43ba75477bd71f049f9e98a2cecab40957dd59d052acc73161c2dacf8d31381550cafc91d9698712be363ed8","href":"https://static.observableusercontent.com/files/e3bcc33e43b59102ccd52077b10b312e9ce7e5aa43ba75477bd71f049f9e98a2cecab40957dd59d052acc73161c2dacf8d31381550cafc91d9698712be363ed8","name":"weekdays_ml_HH.csv","type":"text/csv","lastModified":1618778488650.665,"size":15824},{"id":"b62962f247ec37c9186bce024a46522588d2c114110b69feb9ca26e226c9c6bcff326c6bff0167b680ccdc866aeb4f76269c693efac9e29c904eaa5945edde07","href":"https://static.observableusercontent.com/files/b62962f247ec37c9186bce024a46522588d2c114110b69feb9ca26e226c9c6bcff326c6bff0167b680ccdc866aeb4f76269c693efac9e29c904eaa5945edde07","name":"weekdays_ml_berlin@1.csv","type":"text/csv","lastModified":1618778488650.665,"size":15831},{"id":"19efda1afc4955c6a6b4a15623481e764d629f33aadbf47fba108f74dd58cefb675aa7662d8fba76624153bb5389637e1060923a3671e173fa6a4a6aace74ffc","href":"https://static.observableusercontent.com/files/19efda1afc4955c6a6b4a15623481e764d629f33aadbf47fba108f74dd58cefb675aa7662d8fba76624153bb5389637e1060923a3671e173fa6a4a6aace74ffc","name":"weekdays_tl_berlin@1.csv","type":"text/csv","lastModified":1618778488650.665,"size":17428},{"id":"38564790d0e718d412d03e4551e6d8d07068e0139304635232755e86ffdff84b7afc3f930dea4b1ccc86ec47838cd1ac38d9975886061a34e5f3212d16e1f301","href":"https://static.observableusercontent.com/files/38564790d0e718d412d03e4551e6d8d07068e0139304635232755e86ffdff84b7afc3f930dea4b1ccc86ec47838cd1ac38d9975886061a34e5f3212d16e1f301","name":"weekdays_ml_HH_hour.csv","type":"text/csv","lastModified":1618778488650.665,"size":397673},{"id":"5cbde0f3cc1355efb5873eb83451009cf4a47b76be0cb03e77a4a22a3dc77dcb0a3a90feee75b3fb8843fd79f428178b08df97973e6be2b7a1f39818f839280d","href":"https://static.observableusercontent.com/files/5cbde0f3cc1355efb5873eb83451009cf4a47b76be0cb03e77a4a22a3dc77dcb0a3a90feee75b3fb8843fd79f428178b08df97973e6be2b7a1f39818f839280d","name":"weekdays_ml_berlin_all_alt.csv","type":"text/csv","lastModified":1618778488650.665,"size":17268},{"id":"599ba5eb5b3d4c2bf18d79280146ccae9eca2a0c90807ce7296954aeaf15057440e00b2e489cda5d22aac05109cf0d054b3448e7c0ca89158a81255553f416fb","href":"https://static.observableusercontent.com/files/599ba5eb5b3d4c2bf18d79280146ccae9eca2a0c90807ce7296954aeaf15057440e00b2e489cda5d22aac05109cf0d054b3448e7c0ca89158a81255553f416fb","name":"weekdays_tl_long.csv","type":"text/csv","lastModified":1618778488650.665,"size":2332},{"id":"243d6a567f885394b20587b1a741b5df3e3fb9a2331ae5c9e82cb0f5188a68214db1bb595e6f51d36774b08c565a0a36cf259f9c76340a9442039470689489c3","href":"https://static.observableusercontent.com/files/243d6a567f885394b20587b1a741b5df3e3fb9a2331ae5c9e82cb0f5188a68214db1bb595e6f51d36774b08c565a0a36cf259f9c76340a9442039470689489c3","name":"FU_wetter.tsv","type":"text/tab-separated-values","lastModified":1618778488650.665,"size":9973},{"id":"56552a56ae9b1dd84ed8847ac401784276f5f09fb8f42de750779395ad749d0500eb3e0224505982b8b891812a399aa1e32fd5e8386d621be705855afc93a8cb","href":"https://static.observableusercontent.com/files/56552a56ae9b1dd84ed8847ac401784276f5f09fb8f42de750779395ad749d0500eb3e0224505982b8b891812a399aa1e32fd5e8386d621be705855afc93a8cb","name":"produkt_klima_tag_19500101_20201231_00403@1.txt","type":"text/plain","lastModified":1618778488650.665,"size":3578112},{"id":"d576511c96c9e1b3c31b0847f3d247dcef7fd0f06fa9f157cf5b47a2ac483a15ceb1d165545cf894a4a82161cf95e9108ff55a4956e156ab842f8de6f445244c","href":"https://static.observableusercontent.com/files/d576511c96c9e1b3c31b0847f3d247dcef7fd0f06fa9f157cf5b47a2ac483a15ceb1d165545cf894a4a82161cf95e9108ff55a4956e156ab842f8de6f445244c","name":"weekdays_tl_HH.csv","type":"text/csv","lastModified":1618778488650.665,"size":17428},{"id":"523438bf23df53399ce8c476043a8b9ffd8b75e489c6962dd71635d05031de345505e69682fa984cdc891967ce8c218423725cef81c157c6973c5b5a009ab0f8","href":"https://static.observableusercontent.com/files/523438bf23df53399ce8c476043a8b9ffd8b75e489c6962dd71635d05031de345505e69682fa984cdc891967ce8c218423725cef81c157c6973c5b5a009ab0f8","name":"produkt_klima_tag_20191016_20210417_01975.txt","type":"text/plain","lastModified":1618778488650.665,"size":78756}] 29:{"id":"0281827223f4b268","slug":null,"title":"Dirk Präsentation Weekends","thumbnail":"274d05096d81edb3d3f74c04cadc82ed9d089a27f2098e78963b2f6e8612a539","access_level":"unlisted","create_time":"$D2021-04-18T20:41:28.650Z","update_time":"$D2021-05-03T08:07:18.611Z","view_time":null,"first_public_time":null,"has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"1cff3bba2b121a9d","login":"adrianzachariae","name":"Adrian Zachariae","avatar_url":"https://avatars-next.observableusercontent.com/d1de44a1770f6bd5ba339f85f7c25703fe2ec685d61f08e2a9ce02be00a6b919","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":1251,"publish_version":1251,"role":null,"authored":false,"authors":[{"type":"individual","id":"fb2c373fd95fe547","login":"adrianzachariae","name":"Adrian Zachariae","avatar_url":"https://avatars-next.observableusercontent.com/d1de44a1770f6bd5ba339f85f7c25703fe2ec685d61f08e2a9ce02be00a6b919","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"fb2c373fd95fe547","login":"adrianzachariae","name":"Adrian Zachariae","avatar_url":"https://avatars-next.observableusercontent.com/d1de44a1770f6bd5ba339f85f7c25703fe2ec685d61f08e2a9ce02be00a6b919","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Dirk Präsentation Weekends","cells":[{"id":0,"value":"md`# Dirk Präsentation Weekends`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1069,"value":"render = \"canvas\" // alternative \"svg\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":830,"value":"$49","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1071,"value":"md`## Saturday night`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1062,"value":"md`the fist two are only until end of April. the ones after are the first 6 Months. If think here thats better bc you can see the increase with weather.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":808,"value":"embed(\n _.merge(_.cloneDeep(tripsvtemp_lineplot), {\n title: 'Berlin – Saturday 22:00',\n data: [\n {\n name: \"raw_data\",\n values: weekdays_berlin_hourly\n .join(wetter_FU, 'date')\n .derive({ year: d => op.year(d.date) })\n .filter(d => op.month(d.date) < 4)\n .filter(d => d.weekday == 5)\n .filter(d => d.hour == 22)\n .objects()\n }\n ]\n }),\n { renderer: render }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1066,"value":"embed(\n _.merge(_.cloneDeep(tripsvtemp_lineplot), {\n title: 'Hamburg – Saturday 22:00',\n data: [\n {\n name: \"raw_data\",\n values: weekdays_HH_hourly\n .join(wetter_HH, 'date')\n .derive({ year: d => op.year(d.date) })\n .filter(d => op.month(d.date) < 4)\n .filter(d => d.weekday == 5)\n .filter(d => d.hour == 22)\n .objects()\n }\n ]\n }),\n { renderer: render }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1077,"value":"embed(\n _.merge(_.cloneDeep(tripsvtemp_lineplot), {\n title: 'Berlin – Saturday 22:00',\n data: [\n {\n name: \"raw_data\",\n values: weekdays_berlin_hourly\n .join(wetter_FU, 'date')\n .derive({ year: d => op.year(d.date) })\n .filter(d => op.month(d.date) < 6)\n .filter(d => d.weekday == 5)\n .filter(d => d.hour == 22)\n .objects()\n }\n ]\n }),\n { renderer: render }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1020,"value":"embed(\n _.merge(_.cloneDeep(tripsvtemp_lineplot), {\n title: 'Hamburg – Saturday 22:00',\n data: [\n {\n name: \"raw_data\",\n values: weekdays_HH_hourly\n .join(wetter_HH, 'date')\n .derive({ year: d => op.year(d.date) })\n .filter(d => op.month(d.date) < 6)\n .filter(d => d.weekday == 5)\n .filter(d => d.hour == 22)\n .objects()\n }\n ]\n }),\n { renderer: render }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1083,"value":"md`## Sunday – whole day`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":608,"value":"embed(\n _.merge(_.cloneDeep(tripsvtemp_lineplot), {\n title: 'Berlin – Sunday',\n data: [\n {\n name: \"raw_data\",\n values: weekdays_berlin_all\n .join(wetter_FU, 'date')\n .derive({ year: d => op.year(d.date) })\n .filter(d => op.month(d.date) < 4)\n .filter(d => d.weekday === 6)\n .objects()\n }\n ]\n }),\n { renderer: render }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":995,"value":"embed(\n _.merge(_.cloneDeep(tripsvtemp_lineplot), {\n title: 'Hamburg – Sunday',\n data: [\n {\n name: \"raw_data\",\n values: weekdays_HH_all\n .join(wetter_HH, 'date')\n .derive({ year: d => op.year(d.date) })\n .filter(d => op.month(d.date) < 4)\n .filter(d => d.weekday === 6)\n .objects()\n }\n ]\n }),\n { renderer: render }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1091,"value":"md`## Saturday`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":515,"value":"embed(\n _.merge(_.cloneDeep(tripsvtemp_lineplot), {\n title: 'Berlin – Saturday',\n data: [\n {\n name: \"raw_data\",\n values: weekdays_berlin_all\n .join(wetter_FU, 'date')\n .derive({ year: d => op.year(d.date) })\n .filter(d => op.month(d.date) < 4)\n .filter(d => d.weekday === 5)\n .objects()\n }\n ]\n }),\n { renderer: render }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1130,"value":"embed(\n _.merge(_.cloneDeep(tripsvtemp_lineplot), {\n title: 'Hamburg – Saturday',\n data: [\n {\n name: \"raw_data\",\n values: weekdays_HH_all\n .join(wetter_HH, 'date')\n .derive({ year: d => op.year(d.date) })\n .filter(d => op.month(d.date) < 4)\n .filter(d => d.weekday === 5)\n .objects()\n }\n ]\n }),\n { renderer: render }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1138,"value":"md`## Wednesday`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1141,"value":"embed(\n _.merge(_.cloneDeep(tripsvtemp_lineplot), {\n title: 'Berlin – Wednesday',\n data: [\n {\n name: \"raw_data\",\n values: weekdays_berlin_all\n .join(wetter_FU, 'date')\n .derive({ year: d => op.year(d.date) })\n .filter(d => op.month(d.date) < 4)\n .filter(d => d.weekday === 2)\n .objects()\n }\n ]\n }),\n { renderer: render }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1142,"value":"embed(\n _.merge(_.cloneDeep(tripsvtemp_lineplot), {\n title: 'Hamburg – Wednesday',\n data: [\n {\n name: \"raw_data\",\n values: weekdays_HH_all\n .join(wetter_HH, 'date')\n .derive({ year: d => op.year(d.date) })\n .filter(d => op.month(d.date) < 4)\n .filter(d => d.weekday === 2)\n .objects()\n }\n ]\n }),\n { renderer: render }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1154,"value":"md`## Bar plot`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":53,"value":"vl\n .markBar({ width: 9 })\n .data(\n weekdays_berlin_all\n .filter(d => op.month(d.date) < 4)\n .filter(d => (op.dayofweek(d.date) > 4) ^ (op.dayofweek(d.date) == 0))\n .derive({\n day: d => (op.dayofweek(d.date) > 0 ? op.dayofweek(d.date) : 7)\n })\n .derive({ week: d => op.week(d.date) })\n .filter(d => d.week < 17)\n )\n .encode(\n vl\n .x()\n .fieldN('year')\n .axis(null),\n vl\n .y()\n .fieldQ('trips')\n .axis({ grid: false }),\n vl\n .color()\n .fieldN('year')\n .scale({ range: [\"#555\", \"#30a2da\", \"#fc4f30\"] }),\n vl.column({ spacing: 4 }).fieldN('week'),\n vl.row().day('date')\n )\n .height(200)\n .width(30)\n .config({ view: { stroke: null } })\n .render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"weekdays = aq\n .fromCSV(await FileAttachment('weekdays_tl_long.csv').text())\n .derive({ year: d => op.year(d.date) })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1105,"value":"md`## Plot Def.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1108,"value":"md`## Data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":876,"value":"weekdays_berlin_all_old = aq\n .fromCSV(await FileAttachment('weekdays_ml_berlin_all_alt.csv').text())\n .derive({ year: d => op.year(d.date) })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":636,"value":"weekdays_berlin_all_alt = aq\n .fromCSV(await FileAttachment('weekdays_ml_berlin@1.csv').text())\n .derive({ year: d => op.year(d.date) })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":840,"value":"weekdays_berlin_all = aq\n .fromCSV(await FileAttachment('weekdays_tl_berlin@1.csv').text())\n .derive({ year: d => op.year(d.date) })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1002,"value":"weekdays_HH_all_alt = aq\n .fromCSV(await FileAttachment('weekdays_ml_HH.csv').text())\n .derive({ year: d => op.year(d.date) })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":988,"value":"weekdays_HH_all = aq\n .fromCSV(await FileAttachment('weekdays_tl_HH.csv').text())\n .derive({ year: d => op.year(d.date) })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":752,"value":"weekdays_berlin_hourly = aq\n .fromCSV(await FileAttachment('weekdays_ml_berlin_hour@1.csv').text())\n .derive({ year: d => op.year(d.date) })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1007,"value":"weekdays_HH_hourly = aq\n .fromCSV(await FileAttachment('weekdays_ml_HH_hour.csv').text())\n .derive({ year: d => op.year(d.date) })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":501,"value":"weekdays_berlin_hourly.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":964,"value":"$4a","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":570,"value":"$4b","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":558,"value":"aq\n .fromCSV(\n (await FileAttachment(\n 'produkt_klima_tag_19500101_20201231_00403@1.txt'\n ).text()).replaceAll(/[ ]+/g, ''),\n { delimiter: ';' }\n )\n .view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"value":"md`## Libraries`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"import { aq, op } from '@uwdata/arquero'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":200,"value":"embed = require(\"vega-embed\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"import { vl } from '@vega/vega-lite-api-v5'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"d3 = require('d3@v6')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"_ = require('lodash')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4c","stdlib":"1"}} 24:null