31:[{"id":"454723837aa3a5f62bc9732d9d42d49b821c7ea078d1cecd9109f8c20adda7f9c4648f1a38832a2fc0db03d9a79427235ea12ff8f78dc86de97248daedb89a65","href":"https://static.observableusercontent.com/files/454723837aa3a5f62bc9732d9d42d49b821c7ea078d1cecd9109f8c20adda7f9c4648f1a38832a2fc0db03d9a79427235ea12ff8f78dc86de97248daedb89a65","name":"MaineCTE.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1668463514287.051,"size":42242},{"id":"5907712f13d29d9624f173afbd8ebaae46e9915fcd865c0e2c464d39362768e1045c675447ea7296fe3d895bdc7482de5392152b5f776b3768fc8355411843c8","href":"https://static.observableusercontent.com/files/5907712f13d29d9624f173afbd8ebaae46e9915fcd865c0e2c464d39362768e1045c675447ea7296fe3d895bdc7482de5392152b5f776b3768fc8355411843c8","name":"Bio-Info-Science.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1668464682747.801,"size":42519},{"id":"2982075c323defde9fb0568353c67572cb9bf6d9b7a3cb4700821fe7ca71ad0b79e240bf8713c5cf30bb84df18c47b16041ec00d07c153de81e83b62209d74a9","href":"https://static.observableusercontent.com/files/2982075c323defde9fb0568353c67572cb9bf6d9b7a3cb4700821fe7ca71ad0b79e240bf8713c5cf30bb84df18c47b16041ec00d07c153de81e83b62209d74a9","name":"dummy2.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1669081921078.436,"size":34544},{"id":"ad517f4a4f9a7ef52c01b57b1ec0c2fa6ed1b6e0ea7106e4269710dfea0c0ddadae65f8cfdc67ea74c98bf279ec8fc3ce7fee68ac9d2d401454bf6e8f96eb02e","href":"https://static.observableusercontent.com/files/ad517f4a4f9a7ef52c01b57b1ec0c2fa6ed1b6e0ea7106e4269710dfea0c0ddadae65f8cfdc67ea74c98bf279ec8fc3ce7fee68ac9d2d401454bf6e8f96eb02e","name":"dummy2@1.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1669083811647.762,"size":38087}] 2f:{"title":"Bioscience Data Furnace","cells":[{"id":1271,"value":"# Bioscience Data Furnace","pinned":false,"hidden":false,"mode":"md"},{"id":895,"value":"md`read a xlsx`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1294,"value":"workbook = FileAttachment(\"Bio-Info-Science.xlsx\").xlsx()","pinned":true,"hidden":false,"mode":"ojs"},{"id":1465,"value":"sheetsnames = workbook.sheetNames","pinned":true,"hidden":false,"mode":"ojs"},{"id":1471,"value":"sheets_headers_true = sheetsnames.map(x => workbook.sheet(x, {headers: true}))","pinned":true,"hidden":false,"mode":"ojs"},{"id":1669,"value":"sheets_headers_false = sheetsnames.map(x => workbook.sheet(x, {headers: false}))","pinned":true,"hidden":false,"mode":"ojs"},{"id":1609,"value":"sheetsObj = sheetsnames.reduce((prev, curr) => {\n prev[curr] = workbook.sheet(curr, {headers:true});\n return prev;\n}, {});","pinned":true,"hidden":false,"mode":"ojs"},{"id":1596,"value":"sheetsMap = new Map(sheetsnames.map(x => [x,workbook.sheet(x, {headers: true})]))","pinned":true,"hidden":false,"mode":"ojs"},{"id":1662,"value":"# Filter by Longitude and Latitude","pinned":false,"hidden":false,"mode":"md"},{"id":1477,"value":"filtered_sheets = sheets_headers_true.filter(x =>x.columns.includes(\"Longitude\") && x.columns.includes(\"Latitude\"))","pinned":true,"hidden":false,"mode":"ojs"},{"id":1529,"value":"invalid_sheets = sheets_headers_true.filter(x =>! (x.columns.includes(\"Longitude\") && x.columns.includes(\"Latitude\")))","pinned":true,"hidden":false,"mode":"ojs"},{"id":1673,"value":"# Data for Tangled Tree","pinned":false,"hidden":false,"mode":"md"},{"id":1641,"value":"// [Maine CTEs, Maine STEM Schools] - [Colleges, Community Colleges] - [Companies]\ndata0 = {\n var data = new Array();\n for (const sheet of sheets_headers_false){\n let level = new Array();\n for (const col of sheet){\n level.push({id: col.A})\n }\n data.push(level)\n }\nreturn data;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1510,"value":"sheets_json = filtered_sheets.map(x => {\n return{\n type: \"FeatureCollection\",\n features: x.map((d) => {\n return {\n type: \"Feature\",\n geometry: { type: \"Point\", coordinates: [d.Longitude, d.Latitude] },\n properties: d\n }\n })\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1534,"value":"intersection = sheets_headers_true[0].columns.filter(col => sheets_headers_true[7].columns.includes(col)).filter(col => !(new Set([\"#\", \"City\", \"State\", \"County\", \"Latitude\", \"Longitude\"])).has(col))","pinned":false,"hidden":false,"mode":"ojs"},{"id":1557,"value":"pre_engineering_path = sheets_headers_true.map(x => x.filter(y => Object.keys(y).includes(\"Pre-Engineering\"))).filter(z => z.length > 0)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1564,"value":"pre_engineering_edge = new Array","pinned":false,"hidden":false,"mode":"ojs"},{"id":1570,"value":"{\nfor (let i = 0; i < pre_engineering_path.length - 1; i++) {\n for (let j = 0; j < pre_engineering_path[i].length; j++){\n for (let k = 0; k < pre_engineering_path[i+1].length; k++) {\n pre_engineering_edge.push({src: pre_engineering_path[i][j].City, dst: pre_engineering_path[i+1][k].City});\n }\n } \n}\n return 'creating path...';\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1688,"value":"# Creating Dummy Data","pinned":false,"hidden":false,"mode":"md"},{"id":1692,"value":"dummy = FileAttachment(\"dummy2@1.xlsx\").xlsx()","pinned":true,"hidden":false,"mode":"ojs"},{"id":1707,"value":"dummynames = dummy.sheetNames","pinned":true,"hidden":false,"mode":"ojs"},{"id":1742,"value":"dummyMap = new Map(dummynames.map(x => [x, dummy.sheet(x, {headers: true})]))","pinned":true,"hidden":false,"mode":"ojs"},{"id":1756,"value":"category = dummy.sheet(\"Sheet3\", {headers: true}).map(x => x[\"name\"])","pinned":true,"hidden":false,"mode":"ojs"},{"id":1716,"value":"newDummy = dummy.sheet(\"Companies\", {headers: true}).map(x => {\n var row = new Object()\n row['Name'] = x[\"Name\"]\n for (let i=0;i < category.length; i++){\n if (Math.random() < .1){\n row[category[i]] = 'X'\n }\n }\n return row;\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1834,"value":"dummyArr = dummynames.reduce((prev, curr) => {\n if ([\"Maine CTEs\", \"Community Colleges\"].includes(curr)){\n prev.push(dummy.sheet(curr, {headers:true}));\n } else{\n \n prev.push(dummy.sheet(curr, {headers: true}).map(x => {\n var row = new Object()\n row['Name'] = x[\"Name\"]\n for (let i=0;i < category.length; i++){\n if (Math.random() < .1){\n row[category[i]] = 'X'\n }\n }\n return row;\n }))\n }\n return prev;\n}, new Array());","pinned":false,"hidden":false,"mode":"ojs"},{"id":1925,"value":"dummyArr1 = {\n const arr = _.cloneDeep(dummyArr);\n let temp = arr[0];\n arr[0] = arr[2];\n arr[2] = temp;\n temp = arr[1];\n arr[1] = arr[3];\n arr[3] = temp;\n temp = arr[3];\n arr[3] = arr[5];\n arr[5] = temp;\n \n return arr;}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1906,"value":"dummyArr0 = {\n const arr = _.cloneDeep(dummyArr);\n let temp = arr[0]\n arr[0] = arr[2]\n arr[2] = temp\n temp = arr[1]\n arr[1] = arr[3]\n arr[3] = temp\n temp = arr[3]\n arr[3] = arr[5]\n arr[5] = temp\n\n arr[0] = arr[0].concat(arr[1]).concat(arr[2])\n arr.splice(1,2)\nreturn arr;}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1712,"value":"dummyObj = dummynames.reduce((prev, curr) => {\n if ([\"Maine CTEs\", \"Community Colleges\"].includes(curr)){\n prev[curr] = dummy.sheet(curr, {headers:true});\n console.log(prev)\n } else{\n \n prev[curr] = dummy.sheet(curr, {headers: true}).map(x => {\n var row = new Object()\n row['Name'] = x[\"Name\"]\n for (let i=0;i < category.length; i++){\n if (Math.random() < .1){\n row[category[i]] = 'X'\n }\n }\n return row;\n })\n }\n return prev;\n}, {});","pinned":false,"hidden":false,"mode":"ojs"},{"id":1832,"value":"## Dummy Data for Google Sheet","pinned":false,"hidden":false,"mode":"md"},{"id":1823,"value":"{\n const div = DOM.element('div');\n for (let i = 0; i {\n prev[curr] = new Array();\n for (let i=0;i{\n for (let i=1;i{\n prev.push(curr[\"id\"])\n return prev;\n },new Array())\n \n dummyE[curr][i].map(row => row[\"parents\"]=parent)\n }\n})\n return dummyE;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1883,"value":"// [Maine CTEs, Maine STEM Schools] - [Colleges, Community Colleges] - [Companies]\ndummyE0 = {\n var dummyE = category.reduce((prev, curr) => {\n prev[curr] = new Array();\n for (let i=0;i{\n for (let i=1;i{\n prev.push(curr[\"id\"])\n return prev;\n },new Array())\n \n dummyE[curr][i].map(row => row[\"parents\"]=parent)\n }\n})\n return dummyE;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1940,"value":"md`# Modifying Derek's Data`","pinned":true,"hidden":false,"mode":"ojs"},{"id":31,"value":"md`## libs`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1171,"value":"_ = require('lodash')","pinned":false,"hidden":false,"mode":"ojs"},{"id":1032,"value":"json2csv = require('json2csv@latest')","pinned":false,"hidden":false,"mode":"ojs"},{"id":873,"value":"d3 = require('d3@5')","pinned":false,"hidden":false,"mode":"ojs"},{"id":33,"value":"xlsx = require('xlsx/dist/xlsx.core.min.js').then(() => window.XLSX)","pinned":false,"hidden":false,"mode":"ojs"},{"id":309,"value":"geocoder = require(\"@esri/arcgis-rest-geocoder\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":313,"value":"auth = require(\"@esri/arcgis-rest-auth\"); ","pinned":false,"hidden":false,"mode":"ojs"},{"id":331,"value":"import { \n checkbox,\n password,\n select,\n slider,\n text,\n textarea\n} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1499,"value":"# Previous Work","pinned":false,"hidden":false,"mode":"md"},{"id":1255,"value":"companies = workbook.sheet(\"Companies\", {headers: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1307,"value":"companiesGeoJson = {\n return {\n type: \"FeatureCollection\",\n features: companies.map((d) => {\n return {\n type: \"Feature\",\n geometry: { type: \"Point\", coordinates: [d.Longitude, d.Latitude] },\n properties: d\n }\n })\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1360,"value":"Inputs.table(companies, {layout: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1517,"value":"## Filter","pinned":false,"hidden":false,"mode":"md"},{"id":1475,"value":"sheets_headers_true[0].columns","pinned":true,"hidden":false,"mode":"ojs"},{"id":1489,"value":"Object.values(sheets_headers_true[0].columns)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1496,"value":"sheets_headers_true[0].columns.includes(\"Latitude\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":1494,"value":"\"Latitude\" in Object.values(sheets_headers_true[0].columns)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1485,"value":"\"0\" in sheets_headers_true[0].columns","pinned":true,"hidden":false,"mode":"ojs"},{"id":1481,"value":"sheets_headers_true.filter(x =>\"Longitude\" in x.columns)","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}