2d:null 2e:["$","title",null,{"children":"Editable table | Scax | Observable"}] 33:[] 31:{"id":"13beef45d732c139","slug":"editable-table","title":"Editable table","thumbnail":"34152c6e90658635094ee1ba6773ba04b234313a33339e3d0263808f5ad3b21e","access_level":"public","create_time":"$D2020-06-23T01:12:10.083Z","update_time":"$D2020-06-23T01:22:42.284Z","view_time":null,"first_public_time":"$D2020-06-23T01:23:47.396Z","has_unpublished_edits":null,"fork":{"id":"817ad7ce3be50f3c","slug":"editable-table","title":"Editable table","owner":{"id":"45d8dac961c18abd","login":"tomgp","name":"Tom Pearson"}},"stars":3,"starred":false,"owner":{"type":"team","id":"5fe82c555943a562","login":"scax","name":"Scax","avatar_url":"https://avatars-next.observableusercontent.com/4a8f6b87d8903df3a9a64c9016e07643383a21748e3bc603ada2887a9a6c437f","tier":"starter_2024"},"version":124,"publish_version":124,"role":null,"authored":false,"authors":[{"type":"individual","id":"4dd0ebba5aaa52bc","login":"scax","name":"Scax","avatar_url":"https://avatars-next.observableusercontent.com/4a8f6b87d8903df3a9a64c9016e07643383a21748e3bc603ada2887a9a6c437f","tier":null}],"members":[{"type":"individual","id":"4dd0ebba5aaa52bc","login":"scax","name":"Scax","avatar_url":"https://avatars-next.observableusercontent.com/4a8f6b87d8903df3a9a64c9016e07643383a21748e3bc603ada2887a9a6c437f","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Editable table","cells":[{"id":0,"value":"md`# Editable table`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":100,"value":"md`## Table A`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"tableA = html`\n\n\n\n\n

Borough name	code	value
Brent	1	1234
Camden	2	432
Haringey	3	423

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":96,"value":"tableDataA = GetTableData(tableA)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":103,"value":"md`## Table B`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":91,"value":"tableB = html`\n\n\n\n\n

Borough name	code	value
Brent	1	1234,5678
Camden	2	432,12
Haringey	3	423,21,324

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":98,"value":"tableDataB = GetTableData(tableB, table => {\n const pTable = DefaultTableDataParser(table);\n pTable.forEach(row => {\n row[pTable.properties[2]] = row[pTable.properties[2]].split(\",\");\n });\n\n return pTable;\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":46,"value":"GetTableData = function(table, parsingFunc = DefaultTableDataParser) {\n return Generators.observe(notify => {\n const keyinput = event => notify(parsingFunc(table));\n table.addEventListener(\"input\", keyinput, false);\n notify(parsingFunc(table));\n return () => window.removeEventListener(\"input\", keyinput);\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":64,"value":"function DefaultTableDataParser(table) {\n const data = [];\n table.querySelectorAll(\"tr\").forEach((row, i) => {\n data.push(row.innerText.split(/[\\t\\n]/g));\n });\n\n const formattedData = data.reduce((accumulator, row, i) => {\n if (i == 0) {\n accumulator.properties = row;\n } else {\n const rowObject = {};\n accumulator.properties.forEach((key, i) => {\n rowObject[key] = row[i];\n });\n accumulator.push(rowObject);\n }\n return accumulator;\n }, []);\n return formattedData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"d3 = require('d3')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1","titling":"auto"}} 32:"$31:body"