44:["$","title",null,{"children":"Neo4j Javascript Driver | socrano | Observable"}] 4c:T561,function dealWithDataWithParallel() { var NodeIdArray = []; var RelationshipIdArray = []; var nodeArray = []; var relArray = [] for (let index = 0; index < queryArray.length; index++) { var sampleArray = queryArray[index]._fields for (let i = 0; i < sampleArray.length; i++) { var id = sampleArray[i].identity.low if (sampleArray[i].constructor.name === "Node") { if (!(NodeIdArray.includes(id))) { NodeIdArray.push(id) if (sampleArray[i].labels[0] === "Restaurant") { var res = sampleArray[i].properties res["ID"] = id res["Label"] = sampleArray[i].labels[0] nodeArray.push(sampleArray[i].properties) } else { var otherNode = sampleArray[i].properties; nodeArray.push({name:otherNode[Object.keys(otherNode)[0]], ID: id, Label:sampleArray[i].labels[0]}) } } } else { if (!(RelationshipIdArray.includes(id))) { RelationshipIdArray.push(id) var link = sampleArray[i].properties link.ID = sampleArray[i].identity.low link.source = sampleArray[i].start.low link.target = sampleArray[i].end.low relArray.push(sampleArray[i].properties) } } } } var finalArray = buildDataArray(nodeArray, relArray); return finalArray }4d:T465,function dealWithData() { var NodeIdArray = []; var RelationshipIdArray = []; var nodeArray = []; var relArray = [] for (let index = 0; index < all.length; index++) { var sample = all[index]._fields[0] var id = sample.identity.low if (sample.constructor.name === "Node") { if (!(NodeIdArray.includes(id))) { NodeIdArray.push(id) if (sample.labels[0] === "Restaurant") { var res = sample.properties res["ID"] = id res["Label"] = sample.labels[0] nodeArray.push(sample.properties) } else { nodeArray.push({name:sample.properties[0], ID: id, Label:sample.labels[0]}) } } } else { if (!(RelationshipIdArray.includes(id))) { RelationshipIdArray.push(id) var link = sample.properties link.ID = sample.identity.low link.source = sample.start.low link.target = sample.end.low relArray.push(sample.properties) } } } var finalArray = buildDataArray(nodeArray, relArray); return finalArray }4e:[] 48:{"id":"07f6b00a66c468bd","slug":"neo4j-javascript-driver","title":"Neo4j Javascript Driver","thumbnail":"49e3b8e7b5c25c76853ac31b4ed41e895e2facb91573182f4e68e995d0ccb899","access_level":"public","create_time":"$D2021-04-11T02:52:41.361Z","update_time":"$D2021-04-17T12:45:40.904Z","view_time":null,"first_public_time":"$D2021-04-11T05:42:28.472Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"3c32529f19d79e67","login":"socrano","name":"","avatar_url":"https://avatars-next.observableusercontent.com/7e34544e65631904a28581d40ef16cead635adaf4172afd77033315c4273a78a","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":1879,"publish_version":1879,"role":null,"authored":false,"authors":[{"type":"individual","id":"fd7ef74f07d09318","login":"socrano","name":"","avatar_url":"https://avatars-next.observableusercontent.com/7e34544e65631904a28581d40ef16cead635adaf4172afd77033315c4273a78a","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"b1fe1cf689c7422f","login":"dannyqth","name":"Danny Qu","avatar_url":"https://avatars-next.observableusercontent.com/092ae848de90a02f99db052efb3e18a12e0a0b6ade7350c55dfe10f39d4623e0","tier":null,"role":"editor"},{"type":"individual","id":"fd7ef74f07d09318","login":"socrano","name":"","avatar_url":"https://avatars-next.observableusercontent.com/7e34544e65631904a28581d40ef16cead635adaf4172afd77033315c4273a78a","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":2,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Neo4j Javascript Driver","cells":[{"id":185,"value":"md` # Neo4j Javascript Driver\n---\n### Get neo4j driver:`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2,"value":"neo4j = {\n const neo4j = await require('neo4j-driver');\n return neo4j;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":193,"value":"md`\n---\n### Create a driver instance:`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"driver = neo4j.driver(\n \"neo4j+s://df82a806.databases.neo4j.io:7687\",\n neo4j.auth.basic(\"Reader\", \"Reader\")\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":206,"value":"md`\n---\n### Run a query and return result records (the Promise way):`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":341,"value":"md`\n---\n### Cypher query runner:\n\nUsing [CodeMirror](https://codemirror.net/) for Cypher syntax hilighting.\n\nYou can edit and run queries here.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1491,"value":"md`\n# Whole Query\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1689,"value":"//allOriginal = buildDataArrayOriginal(\"MATCH ()-[r:Assoc]->(), (n) RETURN n,r\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1701,"value":"allNodeOriginal = buildDataArrayOriginal(\"MATCH (n) RETURN n\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1703,"value":"allRelationshipOriginal = buildDataArrayOriginal(\"MATCH ()-[r:Assoc]->() RETURN r\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1710,"value":"allNode = allNodeOriginal.records","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1714,"value":"allRelationship = allRelationshipOriginal.records","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1716,"value":"all = allNode.concat(allRelationship)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1718,"value":"all[0]._fields[0].constructor.name","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1476,"value":"givenQuery = \"call {match (f:Food {categories:'Thai'})<-[:Assoc]-(r:Restaurant)-[:Assoc]-> (f2:Food) where f2.categories <> 'Restaurants' and f2.categories <> 'Food' with f2, count(*) as nAssoc order by count(*) desc limit 5 return collect(f2.categories) as topcat} match (c:City)<-[rel1:Assoc {ZIPCode:'02115'}]-(r2:Restaurant)-[rel2:Assoc]->(f3:Food) where f3.categories in topcat return r2, f3, rel1, rel2\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1825,"value":"viewof foodtype = select({\n title: \"Food Type\",\n description: \"Please choose the food type\",\n options: foodArray,\n value: \"\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1813,"value":"foodArrayOriginal = buildDataArrayOriginal(\"match (n:Food) return distinct n.categories order by n.categories\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1815,"value":"foodArray = foodArrayOriginal.records.map(d => d._fields[0])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1800,"value":"viewof zipcode = select({\n title: \"Zip Code\",\n description: \"Please choose the zip code\",\n options: zipcodeArray,\n value: \"\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1831,"value":"zipcodeArrayOriginal = buildDataArrayOriginal(\"MATCH ()-[r]-() WHERE EXISTS(r.ZIPCode) RETURN DISTINCT r.ZIPCode order by r.ZIPCode\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1833,"value":"zipcodeArray = zipcodeArrayOriginal.records.map(d => d._fields[0])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1843,"value":"viewof time = select({\n title: \"time\",\n description: \"Please choose the time\",\n options: timeArray,\n value: \"\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1841,"value":"timeArray = [\"Monday\", \"Tuesday\", \"Wednesday\", \"Thursday\", \"Friday\", \"Saturday\",\"Sunday\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1775,"value":"testQuery = \"call {match (f:Food {categories:\"+foodtype+\"})<-[:Assoc]-(r:Restaurant)-[:Assoc]-> (f2:Food) where f2.categories <> 'Restaurants' and f2.categories <> 'Food' with f2, count(*) as nAssoc order by count(*) desc limit 5 return collect(f2.categories) as topcat} match (c:City)<-[rel1:Assoc {ZIPCode:\"+zipcode+\"}]-(r2:Restaurant)-[rel2:Assoc]->(f3:Food) with r2, c, f3, rel1, rel2 where f3.categories in topcat or f3.categories = \"+foodtype+\" match (h:Hours)<-[m:Assoc]-(r2)-[rel3:Assoc]->(s:stars) where h.name = \"+time+\" and time(head(split(m.Time, '-'))) <= time() return r2, c, s, f3, m, rel1, rel2,rel3 order by s.Stars desc limit 10\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1479,"value":"function buildDataArrayOriginal(q) {\n const session3 = driver.session();\n const dataArrayOriginal = session3.run(q);\n return dataArrayOriginal;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1671,"value":"queryArrayOriginal = buildDataArrayOriginal(givenQuery);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1685,"value":"queryArray = queryArrayOriginal.records","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1759,"value":"queryArray[0]._fields[1].properties","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1753,"value":"$4c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1756,"value":"finalArray2 = dealWithDataWithParallel();","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1743,"value":"all[0]._fields[0]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1640,"value":"$4d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1653,"value":"finalArray = dealWithData()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1584,"value":"Table(finalArray.Node)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1599,"value":"Table(finalArray.Link)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1582,"value":"finalArray","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1601,"value":"resArray = finalArray.Node.filter(d => d.LABEL = \"Restaurant\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1611,"value":"resArray.map(d => d.count = countRelations(d, finalArray)).filter(d => d.count !== 0)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1627,"value":"vl.markBar()\n .data(resArray)\n .encode(\n vl.x().fieldN(\"name\").sort(vl.fieldQ(\"count\").order(\"descending\")),\n vl.y().fieldQ(\"count\"),\n vl.color().fieldN(\"name\"),\n vl.tooltip([\n { field: \"name\", type: \"Categorical\"},\n { field: \"count\", type: \"quantitative\" }\n ])\n )\n .render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1118,"value":"md`\n# Separate Query for Node and Link\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1108,"value":"queryForNode = 'MATCH (n) RETURN n';","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1112,"value":"queryForRelationship = 'MATCH p=()-[r:Assoc]->() RETURN p';","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1076,"value":"function buildDataArrayNodeOriginal() {\n const session1 = driver.session();\n const dataArrayNodeOriginal = session1.run(queryForNode);\n return dataArrayNodeOriginal;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1092,"value":"dataArrayNodeOriginal = buildDataArrayNodeOriginal();","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1096,"value":"function buildDataArrayRelationshipOriginal() {\n const session2 = driver.session();\n const dataArrayRelationshipOriginal = session2.run(queryForRelationship);\n return dataArrayRelationshipOriginal;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":946,"value":"dataArrayRelationshipOriginal = buildDataArrayRelationshipOriginal();","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":912,"value":"dataArrayNodeSecond = dataArrayNodeOriginal.records.map(d => d.toObject())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":959,"value":"dataArrayRelationshipSecond = dataArrayRelationshipOriginal.records.map(d => d.toObject()).map(d => d.p)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":937,"value":"// viewof, generators, dependency, mutable (things to look at for sync)\ndataNodeArray = []","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":894,"value":"{\n for (let i = 0; i < dataArrayNodeSecond.length; i++) {\n dataNodeArray[i] = {ID: dataArrayNodeSecond[i].n.identity.low, LABEL:dataArrayNodeSecond[i].n.labels[0]};\n for (const property in dataArrayNodeSecond[i].n.properties) {\n if (dataNodeArray[i].LABEL == \"Restaurant\") {\n dataNodeArray[i][property] = dataArrayNodeSecond[i].n.properties[property]\n } else {\n dataNodeArray[i]['name'] = dataArrayNodeSecond[i].n.properties[property]\n }\n }\n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":992,"value":"dataNodeArray[8730]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1010,"value":"dataRelationshipArray = []","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1014,"value":"{\n for (let i = 0; i < dataArrayRelationshipSecond.length; i++) {\n dataRelationshipArray[i] = {ID: dataArrayRelationshipSecond[i].segments[0].relationship.identity.low, source: dataArrayRelationshipSecond[i].start.identity.low, target: dataArrayRelationshipSecond[i].end.identity.low}\n for (const property in dataArrayRelationshipSecond[i].segments[0].relationship.properties) {\n dataRelationshipArray[i][property] = dataArrayRelationshipSecond[i].segments[0].relationship.properties[property]\n }\n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1040,"value":"dataRelationshipArray","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1055,"value":"function buildDataArray(node, link) {\n const dataArray = {Node: node, Link: link}\n return dataArray;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1060,"value":"dataArray = buildDataArray(dataNodeArray, dataRelationshipArray)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1297,"value":"Table(dataNodeArray)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1303,"value":"Table(dataRelationshipArray)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1440,"value":"function checkCountCity(object) {\n if (object.count >= 150) {\n return object\n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1448,"value":"function checkCountCategory(object) {\n if (object.count >= 500) {\n return object\n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":525,"value":"md`---\n### Basic Visualizations:\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":632,"value":"vl.markBar() \n .data(dataNodeArray)\n .encode(\n vl.x().count(),\n )\n .render() ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1353,"value":"vl.markBar()\n .data(cityArray)\n .encode(\n vl.x().fieldN(\"name\"),\n vl.y().fieldQ(\"count\"),\n vl.color().fieldN(\"name\"),\n vl.tooltip([\n { field: \"name\", type: \"Categorical\"},\n { field: \"count\", type: \"quantitative\" }\n ])\n )\n .render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1412,"value":"{\n const data =cityArray.filter(checkCountCity);\n \n const color = d3.scaleSequential(d3.interpolateViridis).domain([0, data.length-1]);\n \n const colors = {\n domain: data.map(d=>d.group),\n range: data.map( (i,j) => color(j) )\n };\n \n return vl.markArc({outerRadius: 150})\n .data(data)\n .encode(\n vl.theta().fieldQ('count'),\n vl.color().fieldN('name'),\n vl.tooltip([\n { field: \"name\", type: \"nominal\" },\n { field: \"count\", type: \"quantitative\" }\n ])\n )\n .config({view: {stroke: null}})\n .width(300)\n .height(300)\n .render();\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1372,"value":"vl.markBar()\n .data(categoryArray)\n .encode(\n vl.x().fieldN(\"name\"),\n vl.y().fieldQ(\"count\"),\n vl.color().fieldN(\"name\"),\n vl.tooltip([\n { field: \"name\", type: \"Categorical\"},\n { field: \"count\", type: \"quantitative\" }\n ])\n )\n .render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1433,"value":"{\n const data =categoryArray.filter(checkCountCategory);\n \n const color = d3.scaleSequential(d3.interpolateViridis).domain([0, data.length-1]);\n \n const colors = {\n domain: data.map(d=>d.group),\n range: data.map( (i,j) => color(j) )\n };\n \n return vl.markArc({outerRadius: 150})\n .data(data)\n .encode(\n vl.theta().fieldQ('count'),\n vl.color().fieldN('name'),\n vl.tooltip([\n { field: \"name\", type: \"nominal\" },\n { field: \"count\", type: \"quantitative\" }\n ])\n )\n .config({view: {stroke: null}})\n .width(300)\n .height(300)\n .render();\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1469,"value":"vl.markBar()\n .data(starsArray)\n .encode(\n vl.x().fieldN(\"name\"),\n vl.y().fieldQ(\"count\"),\n vl.color().fieldN(\"name\"),\n vl.tooltip([\n { field: \"name\", type: \"Categorical\"},\n { field: \"count\", type: \"quantitative\" }\n ])\n )\n .render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1472,"value":"{\n const data = starsArray;\n \n const color = d3.scaleSequential(d3.interpolateViridis).domain([0, data.length-1]);\n \n const colors = {\n domain: data.map(d=>d.group),\n range: data.map( (i,j) => color(j) )\n };\n \n return vl.markArc({outerRadius: 150})\n .data(data)\n .encode(\n vl.theta().fieldQ('count'),\n vl.color().fieldN('name'),\n vl.tooltip([\n { field: \"name\", type: \"nominal\" },\n { field: \"count\", type: \"quantitative\" }\n ])\n )\n .config({view: {stroke: null}})\n .width(300)\n .height(300)\n .render();\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1383,"value":"categoryArray = dataArray.Node.filter(d => d.LABEL === \"Food\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1348,"value":"categoryArray.map(d => d.count = countRelations(d,dataArray)).filter(d => d.count != 0)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1345,"value":"cityArray.map(d => d.count = countRelations(d, dataArray)).filter(d => d.count !== 0)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1330,"value":"cityArray = dataArray.Node.filter(d => d.LABEL === \"City\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1460,"value":"starsArray = dataArray.Node.filter(d => d.LABEL === \"stars\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1464,"value":"starsArray.map(d => d.count = countRelations(d, dataArray)).filter(d => d.count !== 0)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1334,"value":"function countRelations(obj, array) {\n return array.Link.filter(d => obj.ID === d.source || obj.ID === d.target).length\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":704,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":443,"value":"dot = require(\"@observablehq/graphviz@0.2\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":113,"value":"import {select, text, number, password as passwordInput} from \"@jashkenas/inputs\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1319,"value":"import { vl } from \"@vega/vega-lite-api\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":361,"value":"CodeMirror = require('https://unpkg.com/codemirror@5/lib/codemirror').then(CodeMirror => {\n return require('https://unpkg.com/codemirror@5/mode/cypher/cypher.js').then(() => CodeMirror);\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":737,"value":"pathSegmentsToDot = pathSegments => {\n let dot = \"digraph { rankdir = LR; \"\n\n let dotRels = pathSegments.map(\n ps => {\n let start,end;\n\n if(new neo4j.types.Integer(ps.relationship.start).equals(new neo4j.types.Integer(ps.start.identity))){\n start = ps.start\n end = ps.end\n } else {\n start = ps.end\n end = ps.start\n }\n\n let dotRel = \"\\\"\" + (start.properties.name !== undefined ? start.properties.name : start.properties.title) + \"\\\"\"\n dotRel += \" -> \"; \n dotRel += \"\\\"\" + (end.properties.name !== undefined ? end.properties.name : end.properties.title) + \"\\\"\"\n dotRel += \" [label = \\\"\"+ ps.relationship.type + \"\\\"];\";\n return dotRel;\n }\n );\n\n dot += dotRels.join(\"\\n\")\n\n dot += \"}\";\n\n return dot;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":375,"value":"stylesheet = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":634,"value":"d3 = require(\"d3@5\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":640,"value":"import {chart} with {chartData as data} from \"@d3/disjoint-force-directed-graph\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1299,"value":"import {Table} from \"@observablehq/inputs\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":813,"value":"// npm i @observablehq/runtime","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4e","stdlib":"1"}} 24:null