31:[{"id":"4e1ea0463f6c6c98887de3e2d07ffecf83476ff111f736875f8d96384d48214bcc13409cf57e9f69da3faafdd9a9561071c587d27e42deb45a50011aaaa3e824","href":"https://static.observableusercontent.com/files/4e1ea0463f6c6c98887de3e2d07ffecf83476ff111f736875f8d96384d48214bcc13409cf57e9f69da3faafdd9a9561071c587d27e42deb45a50011aaaa3e824","name":"countries7.csv","type":"text/csv","lastModified":1628805468786.634,"size":59919}] 2f:{"title":"Template for exploring a data set","cells":[{"id":0,"value":"step1 = md`# Template for exploring a data set\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":451,"value":"heading(\" 👉 Choose a data set\", 1, 4)","pinned":false,"hidden":false,"mode":"ojs"},{"id":105,"value":"viewof file = localFileInput({\n accept: \".csv,.txt\",\n value: FileAttachment(\"countries7.csv\")\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":583,"value":"heading(\" 👉 Choose a delimiter\", 2, 4)","pinned":false,"hidden":false,"mode":"ojs"},{"id":506,"value":"viewof delimiter = Inputs.select([\", (comma)\", \"; (semicolon)\", \"| (pipe)\"], {\n label: \"Delimiter:\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":457,"value":"heading(\" 🤓 Process your data (if applicable)\", 3, 4)","pinned":false,"hidden":false,"mode":"ojs"},{"id":531,"value":"initialData = {\n const psv = d3.dsvFormat(delimiter.charAt(0));\n const myFile = await file.text();\n const typeConversion = d3.autoType; // default type conversion\n // const typeConversion = customType; // custom type conversion\n return psv.parse(myFile, typeConversion);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":569,"value":"function customType(row) {\n // example how use d3.autoType and update one or more properties\n /* \n for (const col of numericColumns) { // convert columns before d3.autoType\n row[col] = String(new NumberParser(\"de\").parse(row[col]));\n }\n return { ...d3.autoType(row), property: row.property }; // convert columns after d3.autoType\n */\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":599,"value":"function processData(_initialData) {\n // process data here\n return _initialData;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":525,"value":"data = processData(initialData)","pinned":false,"hidden":false,"mode":"ojs"},{"id":461,"value":"heading(\" 🧐 Check if the data looks right?\", 4, 4)","pinned":false,"hidden":false,"mode":"ojs"},{"id":413,"value":"viewof myTableView = Inputs.radio([\"table\", \"summary\", \"exploration\"], {\n label: \"Data view:\",\n value: \"table\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":194,"value":"dataView = {\n if (myTableView === \"table\") {\n return Inputs.table(data);\n } else if (myTableView === \"summary\") {\n return SummaryTable(data);\n } else if (myTableView === \"exploration\") {\n return navio(data);\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":276,"value":"viewof filterData = Inputs.checkbox([\"Filter Data?\"])","pinned":false,"hidden":false,"mode":"ojs"},{"id":279,"value":"viewof filteredData = {\n const blankElement = html`

`;\n blankElement.value = data;\n return filterData.length ? navio(data) : blankElement;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":308,"value":"heading(\" Visualize and explore 📊📈✨ \", 1, 1, \"blue\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":1061,"value":"PlotMatrix()","pinned":true,"hidden":false,"mode":"ojs"},{"id":436,"value":"## Appendix","pinned":false,"hidden":false,"mode":"md"},{"id":673,"value":"\n#### Arquero References\n- [Introducing Arquero](https://observablehq.com/@uwdata/introducing-arquero)\n- [Arquero API - Verbs](https://uwdata.github.io/arquero/api/verbs)\n- [An Illustrated Guide to Arquero Verbs](https://observablehq.com/@uwdata/an-illustrated-guide-to-arquero-verbs)\n- [Tidy Data in Javascript](https://observablehq.com/@uwdata/tidy-data-in-javascript)\n- [Data Wrangler based on Arquero](https://observablehq.com/@observablehq/data-wrangler)","pinned":false,"hidden":false,"mode":"md"},{"id":577,"value":"\n#### Plot References\n- https://observablehq.com/@observablehq/plot\n- https://github.com/observablehq/plot\n- https://ee2dev.github.io/plot/","pinned":false,"hidden":false,"mode":"md"},{"id":686,"value":"import { aq, op } from \"@uwdata/arquero\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":682,"value":"import { Wrangler } from \"@observablehq/data-wrangler\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":33,"value":"import { navio } from \"@john-guerra/navio\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":411,"value":"import { SummaryTable } from \"@observablehq/summary-table\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":116,"value":"import { localFileInput } from \"@mbostock/localfile\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":448,"value":"import { heading } from \"@ee2dev/formatting-in-observable\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":664,"value":"import { NumberParser } from \"@mbostock/localized-number-parsing\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1058,"value":"import { PlotMatrix } with { data } from \"@observablehq/autoplot-matrix\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}