3e:null 3f:["$","title",null,{"children":"Decision Table to Tree Visualization Editable | Ruzgar Imski | Observable"}] 45:[{"id":"f3afc96f1b9c6dbacf8b3d9fafc1e7293fa250ebce7ddd6c6b0fdc3c106f0295bf8fdd0bcd65a575a2666077d8fcacb24ecc4c9bce153ab1e13e95ea47c08d6e","href":"https://static.observableusercontent.com/files/f3afc96f1b9c6dbacf8b3d9fafc1e7293fa250ebce7ddd6c6b0fdc3c106f0295bf8fdd0bcd65a575a2666077d8fcacb24ecc4c9bce153ab1e13e95ea47c08d6e","name":"table_template@3.csv","type":"text/csv","lastModified":1706252731697.906,"size":1174}] 43:{"id":"f8cdb78ac8850fc9","slug":null,"title":"Decision Table to Tree Visualization Editable","thumbnail":"8d56d31b9169610b9679efe0643f4e36f1ba369246ab325d383cbb63cff0f088","access_level":"public","create_time":"$D2024-01-26T07:05:31.697Z","update_time":"$D2024-01-26T07:05:31.697Z","view_time":null,"first_public_time":"$D2024-01-26T07:05:31.697Z","has_unpublished_edits":null,"fork":{"id":"bbff9317aef5c8a9","slug":"decision-table-editable","title":"Decision Table to Tree Visualization Editable","owner":{"id":"0060d7e6ab876335","login":"joesquito","name":""}},"stars":0,"starred":false,"owner":{"type":"team","id":"62eaf79b101c4021","login":"mondano","name":"Ruzgar Imski","avatar_url":"https://avatars-next.observableusercontent.com/77349a6cb8957792df3c6651144ca808d40794c15df75040d13e6d6387841d04","tier":"starter_2024","bio":"","following":false},"version":4759,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"97ed911fd2a1208e","login":"mondano","name":"Ruzgar Imski","avatar_url":"https://avatars-next.observableusercontent.com/77349a6cb8957792df3c6651144ca808d40794c15df75040d13e6d6387841d04","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"97ed911fd2a1208e","login":"mondano","name":"Ruzgar Imski","avatar_url":"https://avatars-next.observableusercontent.com/77349a6cb8957792df3c6651144ca808d40794c15df75040d13e6d6387841d04","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Decision Table to Tree Visualization Editable","cells":[{"id":0,"value":"# Decision Table to Tree Visualization Editable","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"This notebook converts decision tables first into hierarchical data then into tidy tree visualizations","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":4611,"value":"Edit the decision table below to see the tree visualization updated","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":4426,"value":"table = {\n return html`\n \n \n ${Object.keys(tableTemplate[0]).map( e => htl.html``)}\n \n \n \n ${tableTemplate.map( (e,i,a) => {\n let html = htl.html.fragment``\n \n for(let f in e){\n html = htl.html.fragment`${html}`\n } \n \n if(e.name === 'condition' && a[i+1]?.name === 'action'){\n html = htl.html.fragment`${html}`\n } else {\n html = htl.html.fragment`${html}`\n }\n return html\n })\n }\n \n

${e}
${e[f]}

`\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":413,"value":"graphDecisionTree(root, {panZoom}).tree //","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4260,"value":"viewof panZoom = Inputs.toggle({value: false, label: \"Allow pan and zoom\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4498,"value":"\n \n \n \n ${Object.keys(trimmedData[0]).map( e => htl.html``)}\n \n \n \n ${trimmedData.map( (e,i,a) => {\n let html = htl.html.fragment``\n \n for(let f in e){\n html = htl.html.fragment`${html}`\n } \n \n if(e.name === 'condition' && a[i+1]?.name === 'action'){\n html = htl.html.fragment`${html}`\n } else {\n html = htl.html.fragment`${html}`\n }\n return html\n })\n }\n \n

Condensed Table
${e}
${e[f]}

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":4479,"value":"trimmedData = {\n const result = []\n for(let i = 0; i < tableData.length; i++){\n result[i] = {}\n }\n _.forEach(tableData[0], (value, key) => {\n let blank = true\n for(let i = 0; i < tableData.length; i++){\n if( tableData[i][key] !== '' ) blank = false\n }\n if(!blank){\n for(let i = 0; i < tableData.length; i++){\n result[i][key] = tableData[i][key]\n }\n }\n })\n\n return result.filter( e => {\n let includeRow = false\n _.forEach(e, (value, key) => {\n if( ! ['name', 'number', 'statement'].includes(key ) ){\n if( value !== '') { \n includeRow = true\n }\n }\n })\n\n return includeRow\n })\n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":390,"value":"---\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":80,"value":"## Table to paths\n\nThe function called below creates path strings for the tree graph. d3.stratify is called on the paths to create the hierarchy for the trees. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":4650,"value":"paths = tableToPath(trimmedData)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":91,"value":"root = d3.stratify().path(d => d.path)(paths)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":55,"value":"---\n\n## Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":4648,"value":"import {tableToPath, graphDecisionTree, treeLink, elementSize} from \"@joesquito/decision-table\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4417,"value":"// Adapted from \"@tomgp/editable-table\"\nfunction parseTableData(table) {\n const data = [];\n table.querySelectorAll(\"tr\")\n .forEach((row, i)=>{\n const rowData = []\n row.querySelectorAll('th')\n .forEach( cell => rowData.push(cell.innerText.trim()))\n row.querySelectorAll('td')\n .forEach( (cell, j) => { \n return j === 2 ? rowData.push(cell.innerText) \n : rowData.push(cell.innerText.trim())\n })\n data.push(rowData)\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":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4424,"value":"tableData = Generators.observe(notify => {\n const keyinput = event => notify(parseTableData(table))\n table.addEventListener(\"input\", keyinput, false)\n notify(parseTableData(table));\n return () => window.removeEventListener(\"input\", keyinput);\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4457,"value":"tableTemplate = FileAttachment(\"table_template@3.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4354,"value":"mutable currentTrace = []","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W45","stdlib":"1"}} 44:"$43:body"