Michael Hunger jexp

Conways Game of Life in Cypher

John Conway (RIP) created the amazing game of life automaton, which is based on a simple rule.

Every cell that has either exactly 3 neighbours or was alive and has 2 neighbours is alive in the next generation.

https://en.wikipedia.org/wiki/Conway%27s_Game_of_Life

Must Watch: https://www.youtube.com/watch?v=FdMzngWchDk

	0	0	none
	1	0	none
	2	0	none
	3	0	none
	4	0	none
	5	0	black
	6	0	black
	7	0	black
	8	0	black
	9	0	black

Select Average Value of Records with a Max Date in Cypher

Question: Oddman

Hmmmm. How would I go about getting the average of a value for a given date, for all records? Ie. For all records on a given date, I want the highest value on that date, and then average that value across all the results.

in SQL, it'd be something like avg... select max... group by date

Sorted Path Expansion by Node Property

Yesterday we got a question on Discord

Maxe — gestern um 19:40 Uhr

Hi folks,

I am searching for some way to expand a graph from one source node like with Apoc.path.expand. But I want to filter on each depth depending on properties.

	create constraint on (q:Question) assert q.id is unique;
	create constraint on (u:User) assert u.id is unique;
	create constraint on (t:Tag) assert t.name is unique;
	create constraint on (a:Answer) assert a.id is unique;
	create index on :Question(title);
	create index on :User(display_name);

	WITH "https://api.stackexchange.com/2.2/questions?pagesize=100&order=desc&sort=creation&tagged=neo4j&site=stackoverflow&filter=!5-i6Zw8Y)4W7vpy91PMYsKM-k9yzEsSC1_Uxlf" AS url
	CALL apoc.load.json(url) YIELD value
	UNWIND value.items AS q

	/* npm install --save neo4j-driver
	node movies.js
	export NEO4J_URI='neo4j+s://demo.neo4jlabs.com:7687'
	export NEO4J_USER='mUser'
	export NEO4J_PASSWORD='s3cr3t'
	export NEO4J_DATABASE='movies'
	*/

	(async() => {

	create constraint on (p:Pair) assert p.digits is unique;

	// pi digits from https://github.com/eneko/Pi (we use 10k here) in pairs of 2
	load csv from "https://raw.githubusercontent.com/eneko/Pi/master/Pi10KDP.txt" as row
	with row[0] as digits
	unwind range(0,size(digits)-4,2) as idx
	merge (from:Pair {digits:substring(digits,idx,2)})
	merge (to:Pair {digits:substring(digits,idx+2,2)})
	merge (from)-[:NEXT {idx:idx}]->(to);

	CREATE CONSTRAINT word_name IF NOT EXISTS ON (w:Word) ASSERT w.name IS UNIQUE;

	CREATE CONSTRAINT cap_idx_char IF NOT EXISTS FOR (cap:CharAtPos) REQUIRE (cap.idx, cap.char) IS NODE KEY;

	LOAD CSV FROM
	"https://gist.githubusercontent.com/jexp/b1882301adb95a8015d6c29d3e24e341/raw/6fe6ac31b9ed46900451e17b5215e9088ec09a6e/wordle.csv" as row
	MERGE (w:Word {name:row[0]});

	:auto MATCH (w:Word)
	CALL { WITH w

	#!/usr/bin/python3
	# usage: ./gedcom2csv.py file.get > file.csv
	# https://pypi.org/project/python-gedcom/
	import sys
	from gedcom.element.individual import IndividualElement
	from gedcom.parser import Parser

	file_path = sys.argv[1]
	gedcom_parser = Parser()
	gedcom_parser.parse_file(file_path)