3f:null 40:["$","title",null,{"children":"--- DRAFT in progress --- | PBI Queryous's Workspace | Observable"}] 46:T6dc,vegalite({ $schema: "https://vega.github.io/schema/vega-lite/v5.json", view: { stroke: "transparent" }, width: 600, data: { values: rawdata }, // add the data transform: [ { calculate: "year(utcFormat(datetime( now()),'%d-%b-%y'))", as: "_today" }, { calculate: "year(datetime( now()))", as: "_today1" }, { name: "_DATE_TODAY", calculate: "datetime( now()) ", as: "_dateToday" }, { name: "_DATE_TEST", calculate: "datum._dateToday > datum['Date'] ? 0 : 1 ", as: "_dateTest" }, { calculate: "utcFormat(utcParse('1 June 2023', '%d %B %Y' ), '%d %B %Y' ) ", as: "_today1" } ], encoding: { x: { field: "Date", type: "temporal", timeUnit: "yearmonth", axis: { title: null, labels: true, labelAngle: 335, labelAlign: "right", labelPadding: 5, labelOffset: 0, labelFontSize: 10 }, bin: false }, y: { field: "Amount", type: "quantitative", axis: null, scale: { zero: false } } }, layer: [ { name: "_ALL_BARS", mark: { type: "bar", color: { expr: "datum._dateToday > datum['Date'] ? '#404040' : 'gainsboro'" }, stroke: "dimGrey", strokeWidth: 1 } }, { mark: { type: "text", fontSize: 10, yOffset: -10, baseline: "bottom", align: "center", fontWeight: "bold", size: 10 }, encoding: { text: { field: "Amount", aggregate: "sum", type: "quantitative", format: ".3s" } } } ] })47:T7ea,// place your specification below vega({ "$schema": "https://vega.github.io/schema/vega/v5.json", "width": 500, "height": 250, "padding": 5, "data": [ { "name": "population", "url": "https://vega.github.io/vega-datasets/data/population.json" }, { "name": "aggregated", "source": "population", "transform": [ { "type": "aggregate", "fields": ["people"], "groupby": ["age", "year"], "ops": ["sum"], "as": ["aggregatedPeople"] } ] }, { "name": "filtered", "source": "aggregated", "transform": [ { "type": "filter", "expr": "datum.year === decade" } ] }, { "name": "maxPeople", "source": "aggregated", "transform": [ { "type": "aggregate", "fields": ["aggregatedPeople"], "groupby": ["year"], "ops": ["max"], "as": ["max_aggregatedPeople"] } ] } ], "signals": [ { "name": "decade", "value": 1910, "bind": {"input": "range", "min": 1850, "max": 2000, "step": 10} } ], "scales": [ { "name": "xscale", "type": "linear", "domain": [0, 100], "range": "width", "padding": 5 }, { "name": "yscale", "type": "linear", "domain": {"data": "maxPeople", "field": "max_aggregatedPeople"}, "range": "height", "round": true } ], "axes": [ {"orient": "bottom", "scale": "xscale", "zindex": 1}, {"orient": "left", "scale": "yscale", "tickCount": 5} ], "marks": [ { "type": "rect", "name": "peopleBars", "from": {"data": "filtered"}, "encode": { "update": { "x": {"scale": "xscale", "field": "age"}, "width": {"value": 20}, "y": {"scale": "yscale", "field": "aggregatedPeople"}, "y2": {"scale": "yscale", "value": 0} } } } ] });48:Ta36,vega({ "$schema": "https://vega.github.io/schema/vega/v5.json", "width": 600, "height": 1600, "padding": 5, "signals": [ { "name": "labels", "value": true, "bind": {"input": "checkbox"} }, { "name": "layout", "value": "tidy", "bind": {"input": "radio", "options": ["tidy", "cluster"]} }, { "name": "links", "value": "diagonal", "bind": { "input": "select", "options": ["line", "curve", "diagonal", "orthogonal"] } }, { "name": "separation", "value": false, "bind": {"input": "checkbox"} } ], "data": [ { "name": "tree", "url": "https://vega.github.io/vega-datasets/data/flare.json", "transform": [ { "type": "stratify", "key": "id", "parentKey": "parent" }, { "type": "tree", "method": {"signal": "layout"}, "size": [{"signal": "height"}, {"signal": "width - 100"}], "separation": {"signal": "separation"}, "as": ["y", "x", "depth", "children"] } ] }, { "name": "links", "source": "tree", "transform": [ { "type": "treelinks" }, { "type": "linkpath", "orient": "horizontal", "shape": {"signal": "links"} } ] } ], "scales": [ { "name": "color", "type": "linear", "range": {"scheme": "magma"}, "domain": {"data": "tree", "field": "depth"}, "zero": true } ], "marks": [ { "type": "path", "from": {"data": "links"}, "encode": { "update": { "path": {"field": "path"}, "stroke": {"value": "#ccc"} } } }, { "type": "symbol", "from": {"data": "tree"}, "encode": { "enter": { "size": {"value": 100}, "stroke": {"value": "#fff"} }, "update": { "x": {"field": "x"}, "y": {"field": "y"}, "fill": {"scale": "color", "field": "depth"} } } }, { "type": "text", "from": {"data": "tree"}, "encode": { "enter": { "text": {"field": "name"}, "fontSize": {"value": 9}, "baseline": {"value": "middle"} }, "update": { "x": {"field": "x"}, "y": {"field": "y"}, "dx": {"signal": "datum.children ? -7 : 7"}, "align": {"signal": "datum.children ? 'right' : 'left'"}, "opacity": {"signal": "labels ? 1 : 0"} } } } ] })49:[{"id":"06fb1a2ca2072fa732b1388858e8a2d6d2bb850f6b0a68d7cd8a37832fc2fad322cf32d297e941a0873148dbf24036a2554d7cb310f786c7310970cdb7a0376b","href":"https://static.observableusercontent.com/files/06fb1a2ca2072fa732b1388858e8a2d6d2bb850f6b0a68d7cd8a37832fc2fad322cf32d297e941a0873148dbf24036a2554d7cb310f786c7310970cdb7a0376b","name":"image.png","type":"image/png","lastModified":1698338215588.555,"size":748600}] 44:{"id":"40593f9b7d7a143e","slug":"draft-in-progress","title":"--- DRAFT in progress --- ","thumbnail":"3a73a86937383769a6b4cd7207ba06db7ed30c0f27813d657ee7a7dcfa9f9f46","access_level":"public","create_time":"$D2023-10-24T12:07:22.052Z","update_time":"$D2023-10-28T18:16:28.080Z","view_time":null,"first_public_time":"$D2023-10-24T12:07:22.052Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"313be0b4ebc7608f","login":"pbi-queryous-ws","name":"PBI Queryous's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/404ba15c07c49cb4ef6b5f753efa3e5db0c7d2be11fa244cc724a2f8b2b3494f","tier":"starter_2024","bio":"","following":false},"version":622,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"095ccf69e3466ab9","login":"pbi-queryous","name":"PBI Queryous","avatar_url":"https://avatars-next.observableusercontent.com/0e362e0326315a8b72bf30cfe2bf107a47fb597d0f8798eeb7f6330b2bbb725a","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"095ccf69e3466ab9","login":"pbi-queryous","name":"PBI Queryous","avatar_url":"https://avatars-next.observableusercontent.com/0e362e0326315a8b72bf30cfe2bf107a47fb597d0f8798eeb7f6330b2bbb725a","tier":null,"role":"editor"},{"type":"team","id":"313be0b4ebc7608f","login":"pbi-queryous-ws","name":"PBI Queryous's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/404ba15c07c49cb4ef6b5f753efa3e5db0c7d2be11fa244cc724a2f8b2b3494f","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"236ecd625107aec0","slug":"vega-lite-deneb","title":"Vega-Lite (Deneb)","owner":{"id":"313be0b4ebc7608f","login":"pbi-queryous-ws","name":"PBI Queryous's Workspace"}},"type":"notebook","body":{"titling":"auto","title":"--- DRAFT in progress --- ","cells":[{"id":0,"value":"# --- DRAFT in progress --- \n# Vega-Lite (Basics)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":249,"value":"md`🧙‍♂️[GitHub Repos](https://github.com/PBIQueryous) | 🕊️[Twitter](https://twitter.com/PBIQueryous)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":426,"value":"contents()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":428,"value":"contents(\"h1\", undefined, true)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":416,"value":"

improvements

\n Test text here\n

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":277,"value":"import { mdh as md } from \"@fil/mdh\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":520,"value":"dt = aq.table({\n Category: [\"a\", \"a\", \"b\", \"b\"],\n Numbers1: Int32Array.of(1, 2, 3, 4),\n Numbers2: Float64Array.of(5, 6, 7, 8)\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":526,"value":"flights = aq.loadArrow(\n \"https://vega.github.io/vega-datasets/data/flights-200k.arrow\"\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":524,"value":"dt.objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":530,"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":528,"value":"flights.view({ limit: 5 }) // view(5) also works as a shorthand","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":533,"value":"flights.view(10) // view(5) also works as a shorthand","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":259,"value":"fn_highlighter`\n~~~js\nSELECT * FROM Table\n\nimport {vegaDataViewer} from \"@john-guerra/vega-data-viewer\"\n___test word___\n+++test word+++\n ~~~test words~~~ new word sfsf word \n---new words---\n~~~`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"## 2. Basic Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":413,"value":"### 2.1 js chart","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":10,"value":"viewof carsChart = {\n const data = \"https://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/all_month.csv\"\n const base = vl.markBar().data(data).encode(\n vl.x().fieldQ('mag').bin(true),\n vl.y().count()\n);\n\nreturn base.data(data).render();\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":141,"value":"viewof chart1 = {\n const data = \"https://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/all_month.csv\"\n const base = vl.markBar().data(data).encode(\n vl.x().fieldQ('mag').bin(true),\n vl.y().count()\n);\n\n// return base.data(data).render();\n return fn_printVegaLiteJSON(base, true);\n}\n\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":240,"value":"vegaDataViewer(carsChart)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":215,"value":"---\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":211,"value":"## Example Dataset\n#### Source: https://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/all_month.csv","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":14,"value":"vegalite({\n // define the width and height\n width: 300,\n height: 300,\n\n // assign the mark\n mark: \"bar\",\n\n // define dataset\n data: {\n url: \"https://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/all_month.csv\"\n },\n\n // encode marks\n encoding: {\n x: {\n bin: true,\n field: \"mag\",\n type: \"quantitative\"\n },\n y: {\n aggregate: \"count\",\n type: \"quantitative\"\n }\n }\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":366,"value":"~~~jsonc\n{\n// define the width and height\n \"width\": 300,\n \"height\": 300,\n\n// assign the mark\n \"mark\": \"bar\",\n\n// define dataset\n \"data\": {\"url\": \"https://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/all_month.csv\"},\n\n// encode marks\n \"encoding\": {\n \"x\": {\n \"bin\": true,\n \"field\": \"mag\",\n \"type\": \"quantitative\"\n },\n \"y\": {\n \"aggregate\": \"count\",\n \"type\": \"quantitative\"\n }\n }\n}\n~~~","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":538,"value":"rawdata = [\n {\n Date: \"2023-01-01\",\n Amount: 500,\n Budget: 700,\n Plan: 840\n },\n {\n Date: \"2023-02-01\",\n Amount: 600,\n Budget: 1000,\n Plan: 1200\n },\n {\n Date: \"2023-03-01\",\n Amount: 200,\n Budget: 150,\n Plan: 180\n },\n {\n Date: \"2023-04-01\",\n Amount: 100,\n Budget: 50,\n Plan: 60\n },\n {\n Date: \"2023-05-01\",\n Amount: 800,\n Budget: 350,\n Plan: 420\n },\n {\n Date: \"2023-06-01\",\n Amount: 450,\n Budget: 900,\n Plan: 1080\n },\n {\n Date: \"2023-07-01\",\n Amount: 600,\n Budget: 800,\n Plan: 960\n },\n {\n Date: \"2023-08-01\",\n Amount: 500,\n Budget: 750,\n Plan: 900\n },\n {\n Date: \"2023-09-01\",\n Amount: 950,\n Budget: 350,\n Plan: 420\n },\n {\n Date: \"2023-10-01\",\n Amount: 980,\n Budget: 800,\n Plan: 960\n },\n {\n Date: \"2023-11-01\",\n Amount: 250,\n Budget: 300,\n Plan: 360\n },\n {\n Date: \"2023-12-01\",\n Amount: 675,\n Budget: 700,\n Plan: 840\n }\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":553,"value":"data1 = rawdata","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"data1","database":"$undefined"},{"id":555,"value":"Plot.plot({\n marks: [\n Plot.auto(data1, {x: \"Date\", y: \"Amount\", color: \"#ff77a7\"})\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":559,"value":"vegalite({\n $schema: \"https://vega.github.io/schema/vega-lite/v5.json\",\n transform: [\n {\n calculate: \"year(utcFormat(datetime( now()),'%d-%b-%y'))\",\n as: \"_today\"\n }\n ],\n mark: { type: \"line\" }, // select the mark type\n data: { values: rawdata }, // add the data\n encoding: {\n // add the visual encodings\n x: {\n field: \"Date\",\n type: \"temporal\"\n // format: \"%d %B %Y\"\n },\n y: {\n field: \"Amount\",\n type: \"quantitative\",\n axis: null,\n scale: { zero: false }\n }\n },\n width: 500,\n height: 250 // set graph size\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":583,"value":"$46","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":544,"value":"Inputs.table(rawdata, { width: 500 })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":217,"value":"---\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":219,"value":"## Example Dataset\n_**Source:** manual values in Vega-Lite script_","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":126,"value":"vegalite({\n // comments\n // adjust container size\n \"width\": 300,\n \"height\": 300,\n // input dataset\n data: {\n //--- for power bi , use the dataset\n // {\"name\": \"datasset\"}\n //--- use embedded values as JSON\n values: [\n {category: \"Quilmes\", value: 82}, {category: \"San Miguel\", value: 13}, {category: \"Guiness\", value: 79},\n {category: \"Carlsberg\", value: 61}, {category: \"BudLite\", value: 40}, {category: \"Corona\", value: 31},\n {category: \"Brahma\", value: 21}, {category: \"Heineken\", value: 94}, {category: \"Stella\", value: 82}\n ]\n },\n\n //--- mark type\n mark: \"bar\",\n //--- enconding channels\n encoding: {\n //--- axes\n x: {field: \"category\", type: \"ordinal\"},\n y: {field: \"value\", type: \"quantitative\"}\n }\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":159,"value":"---\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":161,"value":"$47","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":164,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":166,"value":"$48","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":55,"value":"# APPENDIX","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":19,"value":"### ---- *Import Libraries* ----","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":39,"value":"import {vl} from '@vega/vega-lite-api-v5'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":65,"value":"import {vegaDataViewer} from \"@john-guerra/vega-data-viewer\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":81,"value":"import {printTableTypes} from '@jonfroehlich/data-utilities'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":84,"value":"import {printTable} from '@jonfroehlich/data-utilities'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":46,"value":"vegalite = require(\"@observablehq/vega-lite@0.3\");","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":49,"value":"vega = require(\"vega-embed@6\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":62,"value":"### ---- *Functions* ----","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":393,"value":"import { sql } from \"@cmudig/highlighter\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":398,"value":"import { makeHl } from \"@cmudig/highlighter\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":396,"value":"viewof query = sql`SELECT *\nFROM foo\nWHERE foo.a > 42`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":57,"value":"fn_vegaEmbed = {\n const v = window.vega = await require(\"vega@5\");\n const vl = window.vl = await require(\"vega-lite@5\");\n const ve = await require(\"vega-embed@6\");\n async function vega(spec, options) {\n const div = document.createElement(\"div\");\n div.value = (await ve(div, spec, {...options, mode: 'vega-lite', actions: false})).view;\n return div;\n }\n vega.changeset = v.changeset;\n return vega;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":60,"value":"function fn_printVegaLiteJSON(plot, includeData = false){\n let plotObject = plot.toObject();\n if(includeData === false){\n if(plotObject.hasOwnProperty('data')){\n plotObject.data = \"Data removed for printing to Observable\";\n }\n \n if(plotObject.hasOwnProperty('spec')){\n plotObject.spec.data = \"Data removed for printing to Observable\";\n }\n\n if(plotObject.hasOwnProperty('transform')){\n for (const item of plotObject.transform){\n if(item.hasOwnProperty('from') && item.from.hasOwnProperty('data')){\n item.from.data = \"Data removed for printing to Observable\";\n }\n }\n }\n }\n return html`

${JSON.stringify(plotObject, 0, 2)}

`; // format JSON data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":297,"value":"fn_highlighter = {\n const hljs = window.hljs || (await require(\"@observablehq/highlight.js\"));\n\n return function () {\n const node = md(...arguments);\n for (const fragment of node.querySelectorAll(\"code\")) {\n hljs.highlightBlock(fragment);\n\n fragment.innerHTML = fragment.innerHTML.replace(\n /___(.*?)___/g,\n \"$1\"\n );\n fragment.innerHTML = fragment.innerHTML.replace(\n /~~~(.*?)~~~/g,\n '$1'\n );\n fragment.innerHTML = fragment.innerHTML.replace(\n /[+][+][+](.*?)[+][+][+]/g,\n '$1'\n );\n fragment.innerHTML = fragment.innerHTML.replace(\n /---(.*?)---/g,\n '$1'\n );\n }\n\n return node;\n };\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":325,"value":"import { textcolor } from \"@observablehq/text-color-annotations-in-markdown\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":316,"value":"md`### 5. Color annotation in markdown\n\n~~~js\n import {textcolor} from \"@observablehq/text-color-annotations-in-markdown\"\n~~~`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":318,"value":"In the chart below, we can see ${textcolor('AMZN', d3.schemeTableau10[1])} overtaking ${textcolor('GOOG', d3.schemeTableau10[2])} between 2016 and 2018. Here's some ${textcolor('highlighted', 'yellow')} text.","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":336,"value":"You can override the ${textcolor('foreground color', {background: '#404040', color: 'ivory'})} by specifying an options object instead of a background color. The options object can also be used define other css properties, like using an ${fmt('italic', {background: 'purple', fontStyle: 'italic'})} font style or adding ${fmt('more padding', {background: 'cyan', color: 'navy', fontWeight: 200, padding: \"0 10px\"})}","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":322,"value":"In the chart below, we can see ${textcolor('AMZN', d3.schemeTableau10[1])} overtaking ${textcolor('GOOG', d3.schemeTableau10[2])} between 2016 and 2018.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":351,"value":"function fmt(content, style = {}) {\n function yiq(color) {\n const { r, g, b } = d3.rgb(color);\n return (r * 299 + g * 587 + b * 114) / 1000 / 255; // returns values between 0 and 1\n }\n const {\n background,\n color = yiq(background) >= 0.6 ? \"#111\" : \"white\",\n padding = \"0 5px\",\n borderRadius = \"4px\",\n fontWeight = 800,\n ...rest\n } = typeof style === \"string\" ? { background: style } : style;\n return htl.html`${content}`;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":356,"value":"import { fmt as frmt } from \"@libraries-and-functions/tools\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"### ---- *Import Data ----*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":190,"value":"viewof source_upload = html``","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"rawURL = \"https://vega.github.io/vega-datasets/data/population.json\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":28,"value":"rawDATA = fetch(rawURL).then(res => res.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":31,"value":"Inputs.table(rawDATA)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":75,"value":"datasetCARS = (await require(\"vega-datasets@2\"))[\"cars.json\"]()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":93,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":90,"value":"|Note: View Data Types|\n| --- |--- | --- |\n|for CARS dataset|\n##### data types","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":88,"value":"printTableTypes(datasetCARS)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":112,"value":"|Note: View Data Table|\n| --- |--- | --- |\n|for CARS dataset|\n##### data table","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":109,"value":"Inputs.table(datasetCARS.slice(0,10))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":179,"value":"printTable(datasetCARS.slice(0,10))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":114,"value":" viewof chartCARS = {\n const brush = vl.selectInterval(\"brush\").encodings(\"y\");\n\n const base = vl\n .markBar()\n .select(brush)\n .encode(\n vl.x().count(),\n vl.y().fieldQ(\"Horsepower\"),\n vl.color().if(brush, vl.value(\"steelblue\")).value(\"gray\")\n )\n .height(400);\n\n return base.data(datasetCARS).render();\n return html`

${JSON.stringify(base.toObject(), 0, 2)}

`; // prettify the string\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":117,"value":"{\n const brush = vl.selectInterval(\"brush\").encodings(\"y\");\n\n const base = vl\n .markBar()\n .select(brush)\n .encode(\n vl.x().count(),\n vl.y().fieldQ(\"Horsepower\"),\n vl.color().if(brush, vl.value(\"steelblue\")).value(\"gray\")\n )\n .height(400);\n\n //return base.data(data).render();\n // return html`

${JSON.stringify(base.toObject(), 0, 2)}

`; // prettify the string\n return fn_printVegaLiteJSON(base, true);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":182,"value":"---\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":183,"value":"source_url_data = d3.json(rawURL, d3.autoType)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":186,"value":"printTable(source_url_data.slice(0, 10))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":192,"value":"---\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":194,"value":"data = require('vega-datasets@1') // import vega_datasets","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":196,"value":"birdstrikes = data['birdstrikes.json']() // load and parse cars data","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":199,"value":"md`${birdstrikes.length} rows, ${Object.keys(birdstrikes[0]).length} columns!`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":202,"value":"movies = data['movies.json']() // load and parse cars data","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":204,"value":"md`~ ${movies.length} rows, ${Object.keys(movies[0]).length} columns ~`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":454,"value":"md` ${movies.length}`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":206,"value":"printTable(movies.slice(0, 5))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":208,"value":"vl.markCircle()\n .data(movies)\n .encode(\n vl.x().fieldQ('Rotten_Tomatoes_Rating'),\n vl.y().fieldQ('IMDB_Rating')\n )\n .render()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":402,"value":"import { ToC } from \"@rmw4269/contents\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":407,"value":"import { toc as tcontents } from \"@mbostock/toc\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":423,"value":"import { toc as contents } from \"@jonfroehlich/collapsible-toc\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":458,"value":"demoTable1 = [\n { person: \"Mary\", age: 45 },\n { person: \"Jane\", age: 52 },\n { person: \"Jamil\", age: 35 },\n { person: \"Liang\", age: 21 }\n]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":469,"value":"Inputs.table(demoTable1, { width: 250 })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":475,"value":"![image.png](${await FileAttachment(\"image.png\").url()})","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":477,"value":"viewof table = Inputs.table(olympians)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":479,"value":"SELECT * FROM birdstrikes","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"var:birdstrikes"},{"id":490,"value":"tubedata = d3.csv(\n \"https://data.ny.gov/api/views/vxuj-8kew/rows.csv?accessType=DOWNLOAD&sorting=true\",\n d3.autoType\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":494,"value":"printTableTypes(tubedata)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":499,"value":"d3parse = require(\"d3-dsv@1\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":516,"value":"Next","pinned":true,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"}],"files":"$W49","stdlib":"1"}} 45:"$44:body"