Skip to content

Instantly share code, notes, and snippets.

@rvanbruggen

rvanbruggen/1-cognitivebias.mdx

Last active January 3, 2022 12:00
Show Gist options
  • Save rvanbruggen/44b6209fdd2bf56384a1a6c191030839 to your computer and use it in GitHub Desktop.
Save rvanbruggen/44b6209fdd2bf56384a1a6c191030839 to your computer and use it in GitHub Desktop.
Download ZIP
Cognitive Biases in Neo4j
Raw
1-cognitivebias.mdx

Cognitive biases in Neo4j

I am an economist/engineer. I studied "Commercial Engineering" in Belgium in the nineties, and was quite an avid learner of economic theories large and small at the time. I did however, always kind of find myself uneasy at economists insistence on the rationality the homo economicus, as I knew, and observed all around me, that people were far from rational. That's why, ever since I learned of its existence, I have been a big fan of the field of behavioral economics - which actually tries to formulate ecomic theories that are real, and often times, irrational. I fondly remember first reading Dan Ariely's Predictably Irrational, and learning about some of the crazy biases that he observed and DESCribed. And Nobel-prize-winning Daniel Kahneman has been a hero for decades. I think about the Framing Effect and Prospect Theory almost on a daily basis.

It all started with a tweet

So you can imagine my excitement when I learned about this tweet:

Should be taught to all at a young age pic.twitter.com/GlVkjcdhah

— Elon Musk (@elonmusk) December 19, 2021

This tweet include this particuylar infographic:

I then looked into the source of the graphic, and found that it was featured in more detail on this page. Not much later I was thinking how I could actually do something cool and graphy with this wonderful little piece of data. And again not much later I came up with this blogpost below.

First: get the Cognitive Bias data into a spreadsheet

Call me strange, but I love a good little Google sheet. I put the data in there, and took the trouble of actually putting the category data in there as well. That was 10mins of manual work that I will never get back.

Once I had the spreadsheet nailed, I could easily download the data as a .csv file. That file is then of course ready for import.

Import that data into a Neo4j graph

Import file from .csv

As usual, it take a only a second to import that data into Neo4j, with a very simple query:

    LOAD CSV WITH HEADERS FROM "https://docs.google.com/spreadsheets/d/e/2PACX-1vQDDO_Fqewk1OSR7qrW-2XR7AHhy1MiWmFGwZgLhptaislLP6JLmXgDkR0F331WClserKQz61UDjG8n/pub?gid=0&single=true&output=csv" AS csv
    CREATE (b:Bias)
    SET b = csv;

The result:

Next, I wanted to extract the Category information from the Bias nodes.

Creating the HAS_CATEGORY relationship

From the spreadsheet, we know that there are 6 different categories:

  • Memory
  • Social
  • Learning
  • Belief
  • Money
  • Politics Every Bias has one or more categories, but some are actually pertinent to all.

So let's run the following queries to CREATE the Category nodes, and connect the Bias nodes to these using the HAS_CATEGORY relationship:

    MATCH (b:Bias)
    WHERE b.Memory IS NOT NULL
    MERGE (c:Category {name: "Memory"})
    CREATE (b)-[:HAS_CATEGORY]->(c);

    MATCH (b:Bias)
    WHERE b.Social IS NOT NULL
    MERGE (c:Category {name: "Social"})
    CREATE (b)-[:HAS_CATEGORY]->(c);

    MATCH (b:Bias)
    WHERE b.Learning IS NOT NULL
    MERGE (c:Category {name: "Learning"})
    CREATE (b)-[:HAS_CATEGORY]->(c);

    MATCH (b:Bias)
    WHERE b.Belief IS NOT NULL
    MERGE (c:Category {name: "Belief"})
    CREATE (b)-[:HAS_CATEGORY]->(c);

    MATCH (b:Bias)
    WHERE b.Money IS NOT NULL
    MERGE (c:Category {name: "Money"})
    CREATE (b)-[:HAS_CATEGORY]->(c);

    MATCH (b:Bias)
    WHERE b.Politics IS NOT NULL
    MERGE (c:Category {name: "Politics"})
    CREATE (b)-[:HAS_CATEGORY]->(c);

Here's the result of that query:

The graph now looks like this:

And then we can immediately see that some biases are more interesting than others - if only because they impact more "categories":

    MATCH (b:Bias)-->(c:Category)
    RETURN b.Title, count(c) AS numberofcategories
    ORDER BY numberofcategories DESC;

The result of this looks like this:

My summary would be: interesting, but a bit boring... So I thought about how to make this little graph a little bit more interesting.

NLP on the Bias descriptions

I decided to apply a method that I have used a few times before: the Bias nodes all have a Description property, which actually summarizes in a good way the meaning of each and every one of the 50 biases. If we run

    MATCH (b:Bias)
    RETURN b.Title, b.Description
    ORDER BY b.Title ASC;

Then we see that we could actually do some useful Natural Language Processing on these descriptions:

So, after having installed the required NLP .jar file in the Plugin directory of the Neo4j server, we can start analysing the descriptions using the Google Cloud NLP service. Here's how that works:

    :param apiKey =>("`some fake key here`");

    MATCH (b:Bias)
    CALL apoc.nlp.gcp.entities.graph(b, {
        key: $apiKey,
        nodeProperty: "Description",
        scoreCutoff: 0.01,
        writeRelationshipType: "HAS_ENTITY",
        writeRelationshipProperty: "gcpEntityScore",
        write: true
        })
    YIELD graph AS g
    RETURN "Success!";

This returns after a few seconds:

Now you can see a much richer graph.

And of course we can do some interesting querying on this, like for example exploring the paths between two Biases.

    match path = 
        shortestpath ((b1:Bias {Title: "Reactance"})-[*]-(b2:Bias {Title: "Automation Bias"}))
    return path;

Gives us this:

Wrapping up

So, in conclusion: thanks to Elon's tweet, I had another bit of fun with Neo4j, Bloom, and Google NLP. Hope you liked this example as much as I did - let me know your thoughts regardless!

Cheers

Rik

PS: you can import this little graph in no time, without running the NLP yourself, via this Cypher script.

Raw
2-cognitivebiasimport.cypher
CREATE CONSTRAINT ON (node:`UNIQUE IMPORT LABEL`) ASSERT (node.`UNIQUE IMPORT ID`) IS UNIQUE;
UNWIND [{_id:50, properties:{name:"Memory"}}, {_id:51, properties:{name:"Social"}}, {_id:52, properties:{name:"Learning"}}, {_id:53, properties:{name:"Belief"}}, {_id:54, properties:{name:"Money"}}, {_id:55, properties:{name:"Politics"}}] AS row
CREATE (n:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row._id}) SET n += row.properties SET n:Category;
UNWIND [{_id:56, properties:{text:"others", type:"PERSON"}}, {_id:57, properties:{text:"character", type:"PERSON"}}, {_id:63, properties:{text:"people", type:"PERSON"}}, {_id:75, properties:{text:"person", type:"PERSON"}}, {_id:83, properties:{text:"everyone", type:"PERSON"}}, {_id:90, properties:{text:"witness", type:"PERSON"}}, {_id:92, properties:{text:"victim", type:"PERSON"}}, {_id:100, properties:{text:"personalities", type:"PERSON"}}, {_id:140, properties:{text:"members", type:"PERSON"}}, {_id:142, properties:{text:"individual", type:"PERSON"}}, {_id:159, properties:{text:"someone", type:"PERSON"}}, {_id:160, properties:{text:"children", type:"PERSON"}}] AS row
CREATE (n:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row._id}) SET n += row.properties SET n:Entity:Person;
UNWIND [{_id:103, properties:{text:"piece", type:"WORK_OF_ART"}}] AS row
CREATE (n:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row._id}) SET n += row.properties SET n:Entity:WorkOfArt;
UNWIND [{_id:58, properties:{text:"personality", type:"OTHER"}}, {_id:59, properties:{text:"situation", type:"OTHER"}}, {_id:60, properties:{text:"failures", type:"OTHER"}}, {_id:61, properties:{text:"successes", type:"OTHER"}}, {_id:62, properties:{text:"responsibility", type:"OTHER"}}, {_id:64, properties:{text:"in-group", type:"OTHER"}}, {_id:66, properties:{text:"Ideas", type:"OTHER"}}, {_id:67, properties:{text:"fads", type:"OTHER"}}, {_id:68, properties:{text:"beliefs", type:"OTHER"}}, {_id:69, properties:{text:"conformity", type:"OTHER"}}, {_id:70, properties:{text:"desire", type:"OTHER"}}, {_id:72, properties:{text:"harmony", type:"OTHER"}}, {_id:74, properties:{text:"decisions", type:"OTHER"}}, {_id:76, properties:{text:"trait", type:"OTHER"}}, {_id:77, properties:{text:"impression", type:"OTHER"}}, {_id:78, properties:{text:"traits", type:"OTHER"}}, {_id:79, properties:{text:"standing", type:"OTHER"}}, {_id:80, properties:{text:"outcome", type:"OTHER"}}, {_id:81, properties:{text:"case", type:"OTHER"}}, {_id:82, properties:{text:"something", type:"OTHER"}}] AS row
CREATE (n:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row._id}) SET n += row.properties SET n:Entity:Other;
UNWIND [{_id:84, properties:{text:"attention", type:"OTHER"}}, {_id:85, properties:{text:"appearance", type:"OTHER"}}, {_id:86, properties:{text:"behavior", type:"OTHER"}}, {_id:87, properties:{text:"examples", type:"OTHER"}}, {_id:88, properties:{text:"mind", type:"OTHER"}}, {_id:89, properties:{text:"judgments", type:"OTHER"}}, {_id:91, properties:{text:"mishap", type:"OTHER"}}, {_id:94, properties:{text:"injustice", type:"OTHER"}}, {_id:95, properties:{text:"acts", type:"OTHER"}}, {_id:96, properties:{text:"reality", type:"OTHER"}}, {_id:97, properties:{text:"bias", type:"OTHER"}}, {_id:98, properties:{text:"intentions", type:"OTHER"}}, {_id:99, properties:{text:"actions", type:"OTHER"}}, {_id:101, properties:{text:"statements", type:"OTHER"}}, {_id:102, properties:{text:"range", type:"OTHER"}}, {_id:104, properties:{text:"information", type:"OTHER"}}, {_id:105, properties:{text:"systems", type:"OTHER"}}, {_id:106, properties:{text:"correction", type:"OTHER"}}, {_id:107, properties:{text:"search engines", type:"OTHER"}}, {_id:108, properties:{text:"opposite", type:"OTHER"}}] AS row
CREATE (n:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row._id}) SET n += row.properties SET n:Entity:Other;
UNWIND [{_id:109, properties:{text:"freedoms", type:"OTHER"}}, {_id:110, properties:{text:"threats", type:"OTHER"}}, {_id:111, properties:{text:"perceptions", type:"OTHER"}}, {_id:112, properties:{text:"evidence", type:"OTHER"}}, {_id:113, properties:{text:"effect", type:"OTHER"}}, {_id:114, properties:{text:"mass media consumption", type:"OTHER"}}, {_id:115, properties:{text:"argument", type:"OTHER"}}, {_id:116, properties:{text:"strength", type:"OTHER"}}, {_id:117, properties:{text:"conclusion", type:"OTHER"}}, {_id:118, properties:{text:"minds", type:"OTHER"}}, {_id:119, properties:{text:"need", type:"OTHER"}}, {_id:120, properties:{text:"acceptance", type:"OTHER"}}, {_id:121, properties:{text:"repetition", type:"OTHER"}}, {_id:122, properties:{text:"plausibility", type:"OTHER"}}, {_id:124, properties:{text:"societies", type:"OTHER"}}, {_id:125, properties:{text:"decline", type:"OTHER"}}, {_id:127, properties:{text:"things", type:"OTHER"}}, {_id:128, properties:{text:"changes", type:"OTHER"}}, {_id:129, properties:{text:"same", type:"OTHER"}}, {_id:130, properties:{text:"baseline", type:"OTHER"}}] AS row
CREATE (n:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row._id}) SET n += row.properties SET n:Entity:Other;
UNWIND [{_id:132, properties:{text:"investments", type:"OTHER"}}, {_id:133, properties:{text:"outcomes", type:"OTHER"}}, {_id:134, properties:{text:"possibilities", type:"OTHER"}}, {_id:136, properties:{text:"risks", type:"OTHER"}}, {_id:137, properties:{text:"option", type:"OTHER"}}, {_id:138, properties:{text:"risk", type:"OTHER"}}, {_id:139, properties:{text:"conclusions", type:"OTHER"}}, {_id:141, properties:{text:"characteristics", type:"OTHER"}}, {_id:143, properties:{text:"in-groups", type:"OTHER"}}, {_id:144, properties:{text:"authority figures", type:"OTHER"}}, {_id:145, properties:{text:"opinions", type:"OTHER"}}, {_id:146, properties:{text:"treatment", type:"OTHER"}}, {_id:147, properties:{text:"ones", type:"OTHER"}}, {_id:148, properties:{text:"process", type:"OTHER"}}, {_id:150, properties:{text:"trauma", type:"OTHER"}}, {_id:151, properties:{text:"drug use", type:"OTHER"}}, {_id:152, properties:{text:"exertion", type:"OTHER"}}, {_id:153, properties:{text:"issues", type:"OTHER"}}, {_id:154, properties:{text:"weight", type:"OTHER"}}, {_id:155, properties:{text:"tasks", type:"OTHER"}}] AS row
CREATE (n:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row._id}) SET n += row.properties SET n:Entity:Other;
UNWIND [{_id:156, properties:{text:"value", type:"OTHER"}}, {_id:157, properties:{text:"favors", type:"OTHER"}}, {_id:158, properties:{text:"favor", type:"OTHER"}}, {_id:161, properties:{text:"ideas", type:"OTHER"}}, {_id:162, properties:{text:"memories", type:"OTHER"}}, {_id:163, properties:{text:"questioner", type:"OTHER"}}, {_id:164, properties:{text:"imagination", type:"OTHER"}}, {_id:165, properties:{text:"patterns", type:"OTHER"}}, {_id:166, properties:{text:"clusters", type:"OTHER"}}, {_id:167, properties:{text:"data", type:"OTHER"}}, {_id:168, properties:{text:"likelihood", type:"OTHER"}}] AS row
CREATE (n:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row._id}) SET n += row.properties SET n:Entity:Other;
UNWIND [{_id:0, properties:{Belief:"x", Social:"x", Description:"We judge others on their personality or fundamental character, but we judge ourselves on the situation.", Title:"Fundamental Attribution Error", Link:"https://en.wikipedia.org/wiki/Fundamental_attribution_error"}}, {_id:1, properties:{Social:"x", Belief:"x", Money:"x", Description:"Our failures are situational, but our successes are our responsibility.", Title:"Self-Serving Bias", Link:"https://en.wikipedia.org/wiki/Self-serving_bias"}}, {_id:2, properties:{Belief:"x", Social:"x", Description:"We favor people who are in our in-group as opposed to an out-group.", Title:"In-Group Favoritism", Politics:"x", Link:"https://en.wikipedia.org/wiki/In-group_favoritism"}}, {_id:3, properties:{Belief:"x", Social:"x", Description:"Ideas, fads, and beliefs grow as more people adopt them.", Title:"Bandwagon Effect", Politics:"x", Link:"https://en.wikipedia.org/wiki/Bandwagon_effect"}}, {_id:4, properties:{Social:"x", Belief:"x", Description:"Due to a desire for conformity and harmony in the group, we make irrational decisions, often to minimize conflict.", Title:"Groupthink", Politics:"x", Link:"https://en.wikipedia.org/wiki/Groupthink"}}, {_id:5, properties:{Social:"x", Belief:"x", Description:"If you see a person as having a positive trait, that positive impression will spill over into their other traits. (This also works for negative traits.)", Title:"Halo Effect", Politics:"x", Link:"https://en.wikipedia.org/wiki/Halo_effect"}}, {_id:6, properties:{Belief:"x", Social:"x", Description:"Better moral standing happens due to a positive outcome; worse moral standing happens due to a negative outcome.", Memory:"x", Title:"Moral Luck", Politics:"x", Link:"https://en.wikipedia.org/wiki/Moral_luck"}}, {_id:7, properties:{Belief:"x", Social:"x", Description:"We believe more people agree with us than is actually the case.", Title:"False Consensus", Politics:"x", Link:"https://en.wikipedia.org/wiki/False_consensus_effect"}}, {_id:8, properties:{Social:"x", Belief:"x", Description:"Once we know something, we assume everyone else knows it, too.", Memory:"x", Title:"Curse of Knowledge", Politics:"x", Link:"https://en.wikipedia.org/wiki/Curse_of_knowledge"}}, {_id:9, properties:{Social:"x", Description:"We overestimate how much people are paying attention to our behavior and appearance.", Memory:"x", Title:"Spotlight Effect", Link:"https://en.wikipedia.org/wiki/Spotlight_effect"}}, {_id:10, properties:{Learning:"x", Belief:"x", Money:"x", Description:"We rely on immediate examples that come to mind while making judgments.", Memory:"x", Title:"Availability Heuristic", Politics:"x", Link:"https://en.wikipedia.org/wiki/Availability_heuristic"}}, {_id:11, properties:{Social:"x", Description:"As a witness who secretly fears being vulnerable to a serious mishap, we will blame the victim less if we relate to the victim.", Memory:"x", Title:"Defensive Attribution", Politics:"x", Link:"https://en.wikipedia.org/wiki/Defensive_attribution_hypothesis"}}, {_id:12, properties:{Social:"x", Belief:"x", Description:"We tend to believe the world is just; therefore, we assume acts of injustice are deserved.", Memory:"x", Title:"Just-World Hypothesis", Politics:"x", Link:"https://en.wikipedia.org/wiki/Just-world_hypothesis"}}, {_id:13, properties:{Social:"x", Belief:"x", Description:"We believe that we observe objective reality and that other people are irrational, uninformed, or biased.", Memory:"x", Title:"Naïve Realism", Politics:"x", Link:"https://en.wikipedia.org/wiki/Na%C3%AFve_realism_(psychology)"}}, {_id:14, properties:{Social:"x", Belief:"x", Description:"We believe that we observe objective reality and that other people have a higher egocentric bias than they actually do in their intentions/actions.", Memory:"x", Title:"Naïve Cynicism", Politics:"x", Link:"https://en.wikipedia.org/wiki/Na%C3%AFve_cynicism"}}, {_id:15, properties:{Belief:"x", Description:"We easily attribute our personalities to vague statements, even if they can apply to a wide range of people.", Memory:"x", Title:"Forer Effect (aka Barnum Effect)", Link:"https://en.wikipedia.org/wiki/Barnum_effect"}}, {_id:16, properties:{Learning:"x", Social:"x", Belief:"x", Money:"x", Description:"The less you know, the more confident you are. The more you know, the less confident you are.", Memory:"x", Title:"Dunning-Kruger Effect", Politics:"x", Link:"https://en.wikipedia.org/wiki/Dunning%E2%80%93Kruger_effect"}}, {_id:17, properties:{Belief:"x", Learning:"x", Money:"x", Description:"We rely heavily on the first piece of information introduced when making decisions.", Memory:"x", Title:"Anchoring", Link:"https://en.wikipedia.org/wiki/Anchoring_(cognitive_bias)"}}, {_id:18, properties:{Learning:"x", Belief:"x", Description:"We rely on automated systems, sometimes trusting too much in the automated correction of actually correct decisions.", Memory:"x", Title:"Automation Bias", Link:"https://en.wikipedia.org/wiki/Automation_bias"}}, {_id:19, properties:{Learning:"x", Belief:"x", Description:"We tend to forget information that’s easily looked up in search engines.", Memory:"x", Title:"Google Effect (aka Digital Amnesia)", Link:"https://en.wikipedia.org/wiki/Google_effect"}}] AS row
CREATE (n:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row._id}) SET n += row.properties SET n:Bias;
UNWIND [{_id:20, properties:{Social:"x", Money:"x", Description:"We do the opposite of what we’re told, especially when we perceive threats to personal freedoms.", Title:"Reactance", Politics:"x", Link:"https://en.wikipedia.org/wiki/Reactance_(psychology)"}}, {_id:21, properties:{Learning:"x", Belief:"x", Description:"We tend to find and remember information that confirms our perceptions.", Memory:"x", Title:"Confirmation Bias", Politics:"x", Link:"https://en.wikipedia.org/wiki/Confirmation_bias"}}, {_id:22, properties:{Learning:"x", Belief:"x", Description:"Disproving evidence sometimes has the unwarranted effect of confirming our beliefs.", Memory:"x", Title:"Backfire Effect", Politics:"x", Link:"https://en.wikipedia.org/wiki/Confirmation_bias"}}, {_id:23, properties:{Social:"x", Learning:"x", Belief:"x", Description:"We believe that others are more affected by mass media consumption than we ourselves are.", Memory:"x", Title:"Third-Person Effect", Politics:"x", Link:"https://en.wikipedia.org/wiki/Third-person_effect"}}, {_id:24, properties:{Learning:"x", Belief:"x", Description:"We judge an argument’s strength not by how strongly it supports the conclusion but how plausible the conclusion is in our own minds.", Memory:"x", Title:"Belief Bias", Politics:"x", Link:"https://en.wikipedia.org/wiki/Belief_bias"}}, {_id:25, properties:{Learning:"x", Social:"x", Belief:"x", Money:"x", Description:"Tied to our need for social acceptance, collective beliefs gain more plausibility through public repetition.", Memory:"x", Title:"Availability Cascade", Politics:"x", Link:"https://en.wikipedia.org/wiki/Availability_cascade"}}, {_id:26, properties:{Belief:"x", Social:"x", Description:"We tent to romanticize the past and view the future negatively, believing that societies/institutions are by and large in decline.", Memory:"x", Title:"Declinism", Politics:"x", Link:"https://en.wikipedia.org/wiki/Declinism"}}, {_id:27, properties:{Learning:"x", Social:"x", Belief:"x", Money:"x", Description:"We tend to prefer things to stay the same; changes from the baseline are considered to be a loss.", Memory:"x", Title:"Status Quo Bias", Politics:"x", Link:"https://en.wikipedia.org/wiki/Status_quo_bias"}}, {_id:28, properties:{Belief:"x", Money:"x", Description:"We invest more in things that have cost us something rather than altering our investments, even if we face negative outcomes.", Memory:"x", Title:"Sunk Cost Fallacy (aka Escalation of Commitment)", Link:"https://en.wikipedia.org/wiki/Sunk_cost#Fallacy_effect"}}, {_id:29, properties:{Belief:"x", Money:"x", Description:"We think future possibilities are affected by past events.", Memory:"x", Title:"Gambler’s Fallacy", Link:"https://en.wikipedia.org/wiki/Gambler%27s_fallacy"}}, {_id:30, properties:{Belief:"x", Money:"x", Description:"We prefer to reduce small risks to zero, even if we can reduce more risk overall with another option.", Title:"Zero-Risk Bias", Politics:"x", Link:"https://en.wikipedia.org/wiki/Zero-risk_bias"}}, {_id:31, properties:{Belief:"x", Social:"x", Learning:"x", Money:"x", Description:"We often draw different conclusions from the same information depending on how it’s presented.", Title:"Framing Effect", Politics:"x", Link:"https://en.wikipedia.org/wiki/Framing_(social_sciences)"}}, {_id:32, properties:{Social:"x", Learning:"x", Belief:"x", Description:"We adopt generalized beliefs that members of a group will have certain characteristics, despite not having information about the individual.", Memory:"x", Title:"Stereotyping", Politics:"x", Link:"https://en.wikipedia.org/wiki/Stereotype"}}, {_id:33, properties:{Learning:"x", Social:"x", Belief:"x", Money:"x", Description:"We perceive out-group members as homogeneous and our own in-groups as more diverse.", Memory:"x", Title:"Outgroup Homogeneity Bias", Politics:"x", Link:"https://en.wikipedia.org/wiki/Out-group_homogeneity"}}, {_id:34, properties:{Social:"x", Belief:"x", Money:"x", Description:"We trust and are more often influenced by the opinions of authority figures.", Title:"Authority Bias", Politics:"x", Link:"https://en.wikipedia.org/wiki/Authority_bias"}}, {_id:35, properties:{Belief:"x", Money:"x", Description:"If we believe a treatment will work, it often will have a small physiological effect.", Memory:"x", Title:"Placebo Effect", Link:"https://en.wikipedia.org/wiki/Placebo"}}, {_id:36, properties:{Belief:"x", Social:"x", Money:"x", Description:"We tend to focus on those things that survived a process and overlook ones that failed.", Title:"Survivorship Bias", Politics:"x", Link:"https://en.wikipedia.org/wiki/Survivorship_bias"}}, {_id:37, properties:{Belief:"x", Learning:"x", Description:"Our perceptions of time shift depending on trauma, drug use, and physical exertion.", Memory:"x", Title:"Tachypsychia", Link:"https://en.wikipedia.org/wiki/Time_perception#Tachypsychia"}}, {_id:38, properties:{Social:"x", Money:"x", Description:"We give disproportionate weight to trivial issues, often while avoiding more complex issues.", Memory:"x", Title:"Law of Triviality (aka “Bike-Shedding”)", Politics:"x", Link:"https://en.wikipedia.org/wiki/Law_of_triviality"}}, {_id:39, properties:{Belief:"x", Description:"We remember incomplete tasks more than completed ones.", Memory:"x", Title:"Zeigarnik Effect", Link:"https://en.wikipedia.org/wiki/Zeigarnik_effect"}}] AS row
CREATE (n:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row._id}) SET n += row.properties SET n:Bias;
UNWIND [{_id:40, properties:{Social:"x", Belief:"x", Money:"x", Description:"We place higher value on things we partially created ourselves.", Title:"IKEA Effect", Link:"https://en.wikipedia.org/wiki/IKEA_effect"}}, {_id:41, properties:{Belief:"x", Social:"x", Money:"x", Description:"We like doing favors; we are more likely to do another favor for someone if we’ve already done a favor for them than if we had received a favor from that person.", Title:"Ben Franklin Effect", Politics:"x", Link:"https://en.wikipedia.org/wiki/Ben_Franklin_effect"}}, {_id:42, properties:{Social:"x", Money:"x", Description:"The more other people are around, the less likely we are to help a victim.", Title:"Bystander Effect", Link:"https://en.wikipedia.org/wiki/Bystander_effect"}}, {_id:43, properties:{Belief:"x", Social:"x", Learning:"x", Description:"We, especially children, sometimes mistake ideas suggested by a questioner for memories.", Memory:"x", Title:"Suggestibility", Link:"https://en.wikipedia.org/wiki/Suggestibility"}}, {_id:44, properties:{Social:"x", Belief:"x", Description:"We mistake imagination for real memories.", Memory:"x", Title:"False Memory", Link:"https://en.wikipedia.org/wiki/False_memory"}}, {_id:45, properties:{Social:"x", Belief:"x", Description:"We mistake real memories for imagination.", Memory:"x", Title:"Cryptomnesia", Link:"https://en.wikipedia.org/wiki/Cryptomnesia"}}, {_id:46, properties:{Belief:"x", Description:"We find patterns and “clusters” in random data.", Memory:"x", Title:"Clustering Illusion", Link:"https://en.wikipedia.org/wiki/Clustering_illusion"}}, {_id:47, properties:{Belief:"x", Description:"We sometimes overestimate the likelihood of bad outcomes.", Memory:"x", Title:"Pessimism Bias", Link:"https://en.wikipedia.org/wiki/Optimism_bias"}}, {_id:48, properties:{Belief:"x", Description:"We sometimes are over-optimistic about good outcomes.", Memory:"x", Title:"Optimism Bias", Link:"https://en.wikipedia.org/wiki/Optimism_bias"}}, {_id:49, properties:{Social:"x", Learning:"x", Belief:"x", Description:"We don’t think we have bias, and we see it others more than ourselves.", Memory:"x", Title:"Blind Spot Bias", Link:"https://en.wikipedia.org/wiki/Bias_blind_spot"}}] AS row
CREATE (n:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row._id}) SET n += row.properties SET n:Bias;
UNWIND [{_id:65, properties:{text:"out-group", type:"ORGANIZATION"}}, {_id:71, properties:{text:"group", type:"ORGANIZATION"}}, {_id:126, properties:{text:"institutions", type:"ORGANIZATION"}}] AS row
CREATE (n:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row._id}) SET n += row.properties SET n:Entity:Organization;
UNWIND [{_id:93, properties:{text:"world", type:"LOCATION"}}] AS row
CREATE (n:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row._id}) SET n += row.properties SET n:Entity:Location;
UNWIND [{_id:73, properties:{text:"conflict", type:"EVENT"}}, {_id:131, properties:{text:"loss", type:"EVENT"}}, {_id:135, properties:{text:"events", type:"EVENT"}}, {_id:149, properties:{text:"shift", type:"EVENT"}}] AS row
CREATE (n:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row._id}) SET n += row.properties SET n:Entity:Event;
UNWIND [{_id:123, properties:{text:"tent", type:"CONSUMER_GOOD"}}] AS row
CREATE (n:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row._id}) SET n += row.properties SET n:Entity:ConsumerGood;
UNWIND [{start: {_id:26}, end: {_id:123}, properties:{gcpEntityScore:0.64041454}}] AS row
MATCH (start:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.start._id})
MATCH (end:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.end._id})
CREATE (start)-[r:HAS_ENTITY]->(end) SET r += row.properties;
UNWIND [{start: {_id:17}, end: {_id:103}, properties:{gcpEntityScore:0.36453015}}] AS row
MATCH (start:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.start._id})
MATCH (end:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.end._id})
CREATE (start)-[r:HAS_ENTITY]->(end) SET r += row.properties;
UNWIND [{start: {_id:6}, end: {_id:50}, properties:{}}, {start: {_id:8}, end: {_id:50}, properties:{}}, {start: {_id:9}, end: {_id:50}, properties:{}}, {start: {_id:10}, end: {_id:50}, properties:{}}, {start: {_id:11}, end: {_id:50}, properties:{}}, {start: {_id:12}, end: {_id:50}, properties:{}}, {start: {_id:13}, end: {_id:50}, properties:{}}, {start: {_id:14}, end: {_id:50}, properties:{}}, {start: {_id:15}, end: {_id:50}, properties:{}}, {start: {_id:16}, end: {_id:50}, properties:{}}, {start: {_id:17}, end: {_id:50}, properties:{}}, {start: {_id:18}, end: {_id:50}, properties:{}}, {start: {_id:19}, end: {_id:50}, properties:{}}, {start: {_id:21}, end: {_id:50}, properties:{}}, {start: {_id:22}, end: {_id:50}, properties:{}}, {start: {_id:23}, end: {_id:50}, properties:{}}, {start: {_id:24}, end: {_id:50}, properties:{}}, {start: {_id:25}, end: {_id:50}, properties:{}}, {start: {_id:26}, end: {_id:50}, properties:{}}, {start: {_id:27}, end: {_id:50}, properties:{}}] AS row
MATCH (start:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.start._id})
MATCH (end:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.end._id})
CREATE (start)-[r:HAS_CATEGORY]->(end) SET r += row.properties;
UNWIND [{start: {_id:28}, end: {_id:50}, properties:{}}, {start: {_id:29}, end: {_id:50}, properties:{}}, {start: {_id:32}, end: {_id:50}, properties:{}}, {start: {_id:33}, end: {_id:50}, properties:{}}, {start: {_id:35}, end: {_id:50}, properties:{}}, {start: {_id:37}, end: {_id:50}, properties:{}}, {start: {_id:38}, end: {_id:50}, properties:{}}, {start: {_id:39}, end: {_id:50}, properties:{}}, {start: {_id:43}, end: {_id:50}, properties:{}}, {start: {_id:44}, end: {_id:50}, properties:{}}, {start: {_id:45}, end: {_id:50}, properties:{}}, {start: {_id:46}, end: {_id:50}, properties:{}}, {start: {_id:47}, end: {_id:50}, properties:{}}, {start: {_id:48}, end: {_id:50}, properties:{}}, {start: {_id:49}, end: {_id:50}, properties:{}}, {start: {_id:0}, end: {_id:51}, properties:{}}, {start: {_id:1}, end: {_id:51}, properties:{}}, {start: {_id:2}, end: {_id:51}, properties:{}}, {start: {_id:3}, end: {_id:51}, properties:{}}, {start: {_id:4}, end: {_id:51}, properties:{}}] AS row
MATCH (start:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.start._id})
MATCH (end:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.end._id})
CREATE (start)-[r:HAS_CATEGORY]->(end) SET r += row.properties;
UNWIND [{start: {_id:5}, end: {_id:51}, properties:{}}, {start: {_id:6}, end: {_id:51}, properties:{}}, {start: {_id:7}, end: {_id:51}, properties:{}}, {start: {_id:8}, end: {_id:51}, properties:{}}, {start: {_id:9}, end: {_id:51}, properties:{}}, {start: {_id:11}, end: {_id:51}, properties:{}}, {start: {_id:12}, end: {_id:51}, properties:{}}, {start: {_id:13}, end: {_id:51}, properties:{}}, {start: {_id:14}, end: {_id:51}, properties:{}}, {start: {_id:16}, end: {_id:51}, properties:{}}, {start: {_id:20}, end: {_id:51}, properties:{}}, {start: {_id:23}, end: {_id:51}, properties:{}}, {start: {_id:25}, end: {_id:51}, properties:{}}, {start: {_id:26}, end: {_id:51}, properties:{}}, {start: {_id:27}, end: {_id:51}, properties:{}}, {start: {_id:31}, end: {_id:51}, properties:{}}, {start: {_id:32}, end: {_id:51}, properties:{}}, {start: {_id:33}, end: {_id:51}, properties:{}}, {start: {_id:34}, end: {_id:51}, properties:{}}, {start: {_id:36}, end: {_id:51}, properties:{}}] AS row
MATCH (start:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.start._id})
MATCH (end:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.end._id})
CREATE (start)-[r:HAS_CATEGORY]->(end) SET r += row.properties;
UNWIND [{start: {_id:38}, end: {_id:51}, properties:{}}, {start: {_id:40}, end: {_id:51}, properties:{}}, {start: {_id:41}, end: {_id:51}, properties:{}}, {start: {_id:42}, end: {_id:51}, properties:{}}, {start: {_id:43}, end: {_id:51}, properties:{}}, {start: {_id:44}, end: {_id:51}, properties:{}}, {start: {_id:45}, end: {_id:51}, properties:{}}, {start: {_id:49}, end: {_id:51}, properties:{}}, {start: {_id:10}, end: {_id:52}, properties:{}}, {start: {_id:16}, end: {_id:52}, properties:{}}, {start: {_id:17}, end: {_id:52}, properties:{}}, {start: {_id:18}, end: {_id:52}, properties:{}}, {start: {_id:19}, end: {_id:52}, properties:{}}, {start: {_id:21}, end: {_id:52}, properties:{}}, {start: {_id:22}, end: {_id:52}, properties:{}}, {start: {_id:23}, end: {_id:52}, properties:{}}, {start: {_id:24}, end: {_id:52}, properties:{}}, {start: {_id:25}, end: {_id:52}, properties:{}}, {start: {_id:27}, end: {_id:52}, properties:{}}, {start: {_id:31}, end: {_id:52}, properties:{}}] AS row
MATCH (start:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.start._id})
MATCH (end:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.end._id})
CREATE (start)-[r:HAS_CATEGORY]->(end) SET r += row.properties;
UNWIND [{start: {_id:32}, end: {_id:52}, properties:{}}, {start: {_id:33}, end: {_id:52}, properties:{}}, {start: {_id:37}, end: {_id:52}, properties:{}}, {start: {_id:43}, end: {_id:52}, properties:{}}, {start: {_id:49}, end: {_id:52}, properties:{}}, {start: {_id:0}, end: {_id:53}, properties:{}}, {start: {_id:1}, end: {_id:53}, properties:{}}, {start: {_id:2}, end: {_id:53}, properties:{}}, {start: {_id:3}, end: {_id:53}, properties:{}}, {start: {_id:4}, end: {_id:53}, properties:{}}, {start: {_id:5}, end: {_id:53}, properties:{}}, {start: {_id:6}, end: {_id:53}, properties:{}}, {start: {_id:7}, end: {_id:53}, properties:{}}, {start: {_id:8}, end: {_id:53}, properties:{}}, {start: {_id:10}, end: {_id:53}, properties:{}}, {start: {_id:12}, end: {_id:53}, properties:{}}, {start: {_id:13}, end: {_id:53}, properties:{}}, {start: {_id:14}, end: {_id:53}, properties:{}}, {start: {_id:15}, end: {_id:53}, properties:{}}, {start: {_id:16}, end: {_id:53}, properties:{}}] AS row
MATCH (start:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.start._id})
MATCH (end:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.end._id})
CREATE (start)-[r:HAS_CATEGORY]->(end) SET r += row.properties;
UNWIND [{start: {_id:17}, end: {_id:53}, properties:{}}, {start: {_id:18}, end: {_id:53}, properties:{}}, {start: {_id:19}, end: {_id:53}, properties:{}}, {start: {_id:21}, end: {_id:53}, properties:{}}, {start: {_id:22}, end: {_id:53}, properties:{}}, {start: {_id:23}, end: {_id:53}, properties:{}}, {start: {_id:24}, end: {_id:53}, properties:{}}, {start: {_id:25}, end: {_id:53}, properties:{}}, {start: {_id:26}, end: {_id:53}, properties:{}}, {start: {_id:27}, end: {_id:53}, properties:{}}, {start: {_id:28}, end: {_id:53}, properties:{}}, {start: {_id:29}, end: {_id:53}, properties:{}}, {start: {_id:30}, end: {_id:53}, properties:{}}, {start: {_id:31}, end: {_id:53}, properties:{}}, {start: {_id:32}, end: {_id:53}, properties:{}}, {start: {_id:33}, end: {_id:53}, properties:{}}, {start: {_id:34}, end: {_id:53}, properties:{}}, {start: {_id:35}, end: {_id:53}, properties:{}}, {start: {_id:36}, end: {_id:53}, properties:{}}, {start: {_id:37}, end: {_id:53}, properties:{}}] AS row
MATCH (start:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.start._id})
MATCH (end:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.end._id})
CREATE (start)-[r:HAS_CATEGORY]->(end) SET r += row.properties;
UNWIND [{start: {_id:39}, end: {_id:53}, properties:{}}, {start: {_id:40}, end: {_id:53}, properties:{}}, {start: {_id:41}, end: {_id:53}, properties:{}}, {start: {_id:43}, end: {_id:53}, properties:{}}, {start: {_id:44}, end: {_id:53}, properties:{}}, {start: {_id:45}, end: {_id:53}, properties:{}}, {start: {_id:46}, end: {_id:53}, properties:{}}, {start: {_id:47}, end: {_id:53}, properties:{}}, {start: {_id:48}, end: {_id:53}, properties:{}}, {start: {_id:49}, end: {_id:53}, properties:{}}, {start: {_id:1}, end: {_id:54}, properties:{}}, {start: {_id:10}, end: {_id:54}, properties:{}}, {start: {_id:16}, end: {_id:54}, properties:{}}, {start: {_id:17}, end: {_id:54}, properties:{}}, {start: {_id:20}, end: {_id:54}, properties:{}}, {start: {_id:25}, end: {_id:54}, properties:{}}, {start: {_id:27}, end: {_id:54}, properties:{}}, {start: {_id:28}, end: {_id:54}, properties:{}}, {start: {_id:29}, end: {_id:54}, properties:{}}, {start: {_id:30}, end: {_id:54}, properties:{}}] AS row
MATCH (start:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.start._id})
MATCH (end:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.end._id})
CREATE (start)-[r:HAS_CATEGORY]->(end) SET r += row.properties;
UNWIND [{start: {_id:31}, end: {_id:54}, properties:{}}, {start: {_id:33}, end: {_id:54}, properties:{}}, {start: {_id:34}, end: {_id:54}, properties:{}}, {start: {_id:35}, end: {_id:54}, properties:{}}, {start: {_id:36}, end: {_id:54}, properties:{}}, {start: {_id:38}, end: {_id:54}, properties:{}}, {start: {_id:40}, end: {_id:54}, properties:{}}, {start: {_id:41}, end: {_id:54}, properties:{}}, {start: {_id:42}, end: {_id:54}, properties:{}}, {start: {_id:2}, end: {_id:55}, properties:{}}, {start: {_id:3}, end: {_id:55}, properties:{}}, {start: {_id:4}, end: {_id:55}, properties:{}}, {start: {_id:5}, end: {_id:55}, properties:{}}, {start: {_id:6}, end: {_id:55}, properties:{}}, {start: {_id:7}, end: {_id:55}, properties:{}}, {start: {_id:8}, end: {_id:55}, properties:{}}, {start: {_id:10}, end: {_id:55}, properties:{}}, {start: {_id:11}, end: {_id:55}, properties:{}}, {start: {_id:12}, end: {_id:55}, properties:{}}, {start: {_id:13}, end: {_id:55}, properties:{}}] AS row
MATCH (start:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.start._id})
MATCH (end:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.end._id})
CREATE (start)-[r:HAS_CATEGORY]->(end) SET r += row.properties;
UNWIND [{start: {_id:14}, end: {_id:55}, properties:{}}, {start: {_id:16}, end: {_id:55}, properties:{}}, {start: {_id:20}, end: {_id:55}, properties:{}}, {start: {_id:21}, end: {_id:55}, properties:{}}, {start: {_id:22}, end: {_id:55}, properties:{}}, {start: {_id:23}, end: {_id:55}, properties:{}}, {start: {_id:24}, end: {_id:55}, properties:{}}, {start: {_id:25}, end: {_id:55}, properties:{}}, {start: {_id:26}, end: {_id:55}, properties:{}}, {start: {_id:27}, end: {_id:55}, properties:{}}, {start: {_id:30}, end: {_id:55}, properties:{}}, {start: {_id:31}, end: {_id:55}, properties:{}}, {start: {_id:32}, end: {_id:55}, properties:{}}, {start: {_id:33}, end: {_id:55}, properties:{}}, {start: {_id:34}, end: {_id:55}, properties:{}}, {start: {_id:36}, end: {_id:55}, properties:{}}, {start: {_id:38}, end: {_id:55}, properties:{}}, {start: {_id:41}, end: {_id:55}, properties:{}}] AS row
MATCH (start:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.start._id})
MATCH (end:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.end._id})
CREATE (start)-[r:HAS_CATEGORY]->(end) SET r += row.properties;
UNWIND [{start: {_id:12}, end: {_id:93}, properties:{gcpEntityScore:0.53116685}}] AS row
MATCH (start:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.start._id})
MATCH (end:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.end._id})
CREATE (start)-[r:HAS_ENTITY]->(end) SET r += row.properties;
UNWIND [{start: {_id:0}, end: {_id:58}, properties:{gcpEntityScore:0.10201344}}, {start: {_id:0}, end: {_id:59}, properties:{gcpEntityScore:0.05140319}}, {start: {_id:1}, end: {_id:60}, properties:{gcpEntityScore:0.63770765}}, {start: {_id:1}, end: {_id:61}, properties:{gcpEntityScore:0.18323098}}, {start: {_id:1}, end: {_id:62}, properties:{gcpEntityScore:0.17906135}}, {start: {_id:2}, end: {_id:64}, properties:{gcpEntityScore:0.13922307}}, {start: {_id:3}, end: {_id:66}, properties:{gcpEntityScore:0.6420922}}, {start: {_id:3}, end: {_id:67}, properties:{gcpEntityScore:0.1846216}}, {start: {_id:3}, end: {_id:68}, properties:{gcpEntityScore:0.13106933}}, {start: {_id:4}, end: {_id:69}, properties:{gcpEntityScore:0.2744025}}, {start: {_id:4}, end: {_id:70}, properties:{gcpEntityScore:0.24403447}}, {start: {_id:4}, end: {_id:72}, properties:{gcpEntityScore:0.16957623}}, {start: {_id:4}, end: {_id:74}, properties:{gcpEntityScore:0.043204073}}, {start: {_id:5}, end: {_id:76}, properties:{gcpEntityScore:0.2753298}}, {start: {_id:5}, end: {_id:77}, properties:{gcpEntityScore:0.2262046}}, {start: {_id:5}, end: {_id:78}, properties:{gcpEntityScore:0.0886328}}, {start: {_id:6}, end: {_id:79}, properties:{gcpEntityScore:0.5761208}}, {start: {_id:6}, end: {_id:80}, properties:{gcpEntityScore:0.1352814}}, {start: {_id:7}, end: {_id:81}, properties:{gcpEntityScore:0.3903134}}, {start: {_id:8}, end: {_id:82}, properties:{gcpEntityScore:0.871939}}] AS row
MATCH (start:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.start._id})
MATCH (end:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.end._id})
CREATE (start)-[r:HAS_ENTITY]->(end) SET r += row.properties;
UNWIND [{start: {_id:9}, end: {_id:84}, properties:{gcpEntityScore:0.33168504}}, {start: {_id:9}, end: {_id:85}, properties:{gcpEntityScore:0.23454522}}, {start: {_id:9}, end: {_id:86}, properties:{gcpEntityScore:0.105849884}}, {start: {_id:10}, end: {_id:87}, properties:{gcpEntityScore:0.6635821}}, {start: {_id:10}, end: {_id:88}, properties:{gcpEntityScore:0.1787386}}, {start: {_id:10}, end: {_id:89}, properties:{gcpEntityScore:0.15767933}}, {start: {_id:11}, end: {_id:91}, properties:{gcpEntityScore:0.12146241}}, {start: {_id:12}, end: {_id:94}, properties:{gcpEntityScore:0.32251242}}, {start: {_id:12}, end: {_id:95}, properties:{gcpEntityScore:0.14632073}}, {start: {_id:13}, end: {_id:96}, properties:{gcpEntityScore:0.5222095}}, {start: {_id:14}, end: {_id:96}, properties:{gcpEntityScore:0.14785057}}, {start: {_id:14}, end: {_id:97}, properties:{gcpEntityScore:0.094058655}}, {start: {_id:14}, end: {_id:98}, properties:{gcpEntityScore:0.07252702}}, {start: {_id:14}, end: {_id:99}, properties:{gcpEntityScore:0.05129041}}, {start: {_id:15}, end: {_id:101}, properties:{gcpEntityScore:0.15869622}}, {start: {_id:15}, end: {_id:102}, properties:{gcpEntityScore:0.11318171}}, {start: {_id:17}, end: {_id:104}, properties:{gcpEntityScore:0.33729768}}, {start: {_id:17}, end: {_id:74}, properties:{gcpEntityScore:0.29817218}}, {start: {_id:18}, end: {_id:105}, properties:{gcpEntityScore:0.6254516}}, {start: {_id:18}, end: {_id:74}, properties:{gcpEntityScore:0.22854814}}] AS row
MATCH (start:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.start._id})
MATCH (end:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.end._id})
CREATE (start)-[r:HAS_ENTITY]->(end) SET r += row.properties;
UNWIND [{start: {_id:18}, end: {_id:106}, properties:{gcpEntityScore:0.14600027}}, {start: {_id:19}, end: {_id:104}, properties:{gcpEntityScore:0.7533932}}, {start: {_id:19}, end: {_id:107}, properties:{gcpEntityScore:0.24660681}}, {start: {_id:20}, end: {_id:108}, properties:{gcpEntityScore:0.6824204}}, {start: {_id:20}, end: {_id:109}, properties:{gcpEntityScore:0.1943814}}, {start: {_id:20}, end: {_id:110}, properties:{gcpEntityScore:0.12319822}}, {start: {_id:21}, end: {_id:104}, properties:{gcpEntityScore:0.66521174}}, {start: {_id:21}, end: {_id:111}, properties:{gcpEntityScore:0.33478823}}, {start: {_id:22}, end: {_id:112}, properties:{gcpEntityScore:0.6443757}}, {start: {_id:22}, end: {_id:113}, properties:{gcpEntityScore:0.19363198}}, {start: {_id:22}, end: {_id:68}, properties:{gcpEntityScore:0.16199233}}, {start: {_id:23}, end: {_id:114}, properties:{gcpEntityScore:0.39611816}}, {start: {_id:24}, end: {_id:115}, properties:{gcpEntityScore:0.62256473}}, {start: {_id:24}, end: {_id:116}, properties:{gcpEntityScore:0.15862334}}, {start: {_id:24}, end: {_id:117}, properties:{gcpEntityScore:0.115794115}}, {start: {_id:24}, end: {_id:118}, properties:{gcpEntityScore:0.05535024}}, {start: {_id:25}, end: {_id:119}, properties:{gcpEntityScore:0.3413404}}, {start: {_id:25}, end: {_id:120}, properties:{gcpEntityScore:0.23823574}}, {start: {_id:25}, end: {_id:68}, properties:{gcpEntityScore:0.22241624}}, {start: {_id:25}, end: {_id:121}, properties:{gcpEntityScore:0.12110706}}] AS row
MATCH (start:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.start._id})
MATCH (end:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.end._id})
CREATE (start)-[r:HAS_ENTITY]->(end) SET r += row.properties;
UNWIND [{start: {_id:25}, end: {_id:122}, properties:{gcpEntityScore:0.07690057}}, {start: {_id:26}, end: {_id:124}, properties:{gcpEntityScore:0.19046097}}, {start: {_id:26}, end: {_id:125}, properties:{gcpEntityScore:0.104301274}}, {start: {_id:27}, end: {_id:127}, properties:{gcpEntityScore:0.26756403}}, {start: {_id:27}, end: {_id:128}, properties:{gcpEntityScore:0.25315866}}, {start: {_id:27}, end: {_id:129}, properties:{gcpEntityScore:0.1888883}}, {start: {_id:27}, end: {_id:130}, properties:{gcpEntityScore:0.1743438}}, {start: {_id:28}, end: {_id:127}, properties:{gcpEntityScore:0.576163}}, {start: {_id:28}, end: {_id:82}, properties:{gcpEntityScore:0.17530245}}, {start: {_id:28}, end: {_id:132}, properties:{gcpEntityScore:0.16149773}}, {start: {_id:28}, end: {_id:133}, properties:{gcpEntityScore:0.087036826}}, {start: {_id:29}, end: {_id:134}, properties:{gcpEntityScore:0.57888854}}, {start: {_id:30}, end: {_id:136}, properties:{gcpEntityScore:0.6441626}}, {start: {_id:30}, end: {_id:137}, properties:{gcpEntityScore:0.20663421}}, {start: {_id:30}, end: {_id:138}, properties:{gcpEntityScore:0.1492032}}, {start: {_id:31}, end: {_id:139}, properties:{gcpEntityScore:0.5700269}}, {start: {_id:31}, end: {_id:104}, properties:{gcpEntityScore:0.42997316}}, {start: {_id:32}, end: {_id:68}, properties:{gcpEntityScore:0.41723743}}, {start: {_id:32}, end: {_id:141}, properties:{gcpEntityScore:0.11849076}}, {start: {_id:32}, end: {_id:104}, properties:{gcpEntityScore:0.091485515}}] AS row
MATCH (start:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.start._id})
MATCH (end:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.end._id})
CREATE (start)-[r:HAS_ENTITY]->(end) SET r += row.properties;
UNWIND [{start: {_id:33}, end: {_id:143}, properties:{gcpEntityScore:0.483358}}, {start: {_id:34}, end: {_id:144}, properties:{gcpEntityScore:0.6839195}}, {start: {_id:34}, end: {_id:145}, properties:{gcpEntityScore:0.3160805}}, {start: {_id:35}, end: {_id:146}, properties:{gcpEntityScore:0.73466045}}, {start: {_id:35}, end: {_id:113}, properties:{gcpEntityScore:0.26533955}}, {start: {_id:36}, end: {_id:127}, properties:{gcpEntityScore:0.45827365}}, {start: {_id:36}, end: {_id:147}, properties:{gcpEntityScore:0.39511743}}, {start: {_id:36}, end: {_id:148}, properties:{gcpEntityScore:0.14660892}}, {start: {_id:37}, end: {_id:111}, properties:{gcpEntityScore:0.44152462}}, {start: {_id:37}, end: {_id:150}, properties:{gcpEntityScore:0.13800925}}, {start: {_id:37}, end: {_id:151}, properties:{gcpEntityScore:0.12738247}}, {start: {_id:37}, end: {_id:152}, properties:{gcpEntityScore:0.097590804}}, {start: {_id:38}, end: {_id:153}, properties:{gcpEntityScore:0.37035677}}, {start: {_id:38}, end: {_id:154}, properties:{gcpEntityScore:0.36418378}}, {start: {_id:39}, end: {_id:155}, properties:{gcpEntityScore:0.50836724}}, {start: {_id:39}, end: {_id:147}, properties:{gcpEntityScore:0.49163273}}, {start: {_id:40}, end: {_id:156}, properties:{gcpEntityScore:0.5084283}}, {start: {_id:40}, end: {_id:127}, properties:{gcpEntityScore:0.49157172}}, {start: {_id:41}, end: {_id:157}, properties:{gcpEntityScore:0.45190495}}, {start: {_id:41}, end: {_id:158}, properties:{gcpEntityScore:0.16639797}}] AS row
MATCH (start:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.start._id})
MATCH (end:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.end._id})
CREATE (start)-[r:HAS_ENTITY]->(end) SET r += row.properties;
UNWIND [{start: {_id:43}, end: {_id:161}, properties:{gcpEntityScore:0.12395835}}, {start: {_id:43}, end: {_id:162}, properties:{gcpEntityScore:0.08800376}}, {start: {_id:43}, end: {_id:163}, properties:{gcpEntityScore:0.039926443}}, {start: {_id:44}, end: {_id:164}, properties:{gcpEntityScore:0.7483922}}, {start: {_id:44}, end: {_id:162}, properties:{gcpEntityScore:0.25160778}}, {start: {_id:45}, end: {_id:162}, properties:{gcpEntityScore:0.7504093}}, {start: {_id:45}, end: {_id:164}, properties:{gcpEntityScore:0.24959071}}, {start: {_id:46}, end: {_id:165}, properties:{gcpEntityScore:0.5404038}}, {start: {_id:46}, end: {_id:166}, properties:{gcpEntityScore:0.26816338}}, {start: {_id:46}, end: {_id:167}, properties:{gcpEntityScore:0.19143282}}, {start: {_id:47}, end: {_id:168}, properties:{gcpEntityScore:0.58150464}}, {start: {_id:47}, end: {_id:133}, properties:{gcpEntityScore:0.4184954}}, {start: {_id:48}, end: {_id:133}, properties:{gcpEntityScore:1}}, {start: {_id:49}, end: {_id:97}, properties:{gcpEntityScore:1}}] AS row
MATCH (start:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.start._id})
MATCH (end:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.end._id})
CREATE (start)-[r:HAS_ENTITY]->(end) SET r += row.properties;
UNWIND [{start: {_id:2}, end: {_id:65}, properties:{gcpEntityScore:0.07032406}}, {start: {_id:4}, end: {_id:71}, properties:{gcpEntityScore:0.17154321}}, {start: {_id:26}, end: {_id:126}, properties:{gcpEntityScore:0.064823225}}, {start: {_id:32}, end: {_id:71}, properties:{gcpEntityScore:0.12856293}}] AS row
MATCH (start:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.start._id})
MATCH (end:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.end._id})
CREATE (start)-[r:HAS_ENTITY]->(end) SET r += row.properties;
UNWIND [{start: {_id:4}, end: {_id:73}, properties:{gcpEntityScore:0.09723952}}, {start: {_id:27}, end: {_id:131}, properties:{gcpEntityScore:0.11604521}}, {start: {_id:29}, end: {_id:135}, properties:{gcpEntityScore:0.42111146}}, {start: {_id:37}, end: {_id:149}, properties:{gcpEntityScore:0.19549285}}] AS row
MATCH (start:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.start._id})
MATCH (end:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.end._id})
CREATE (start)-[r:HAS_ENTITY]->(end) SET r += row.properties;
UNWIND [{start: {_id:0}, end: {_id:56}, properties:{gcpEntityScore:0.74337727}}, {start: {_id:0}, end: {_id:57}, properties:{gcpEntityScore:0.1032061}}, {start: {_id:2}, end: {_id:63}, properties:{gcpEntityScore:0.7904529}}, {start: {_id:3}, end: {_id:63}, properties:{gcpEntityScore:0.04221686}}, {start: {_id:5}, end: {_id:75}, properties:{gcpEntityScore:0.34162834}}, {start: {_id:7}, end: {_id:63}, properties:{gcpEntityScore:0.6096866}}, {start: {_id:8}, end: {_id:83}, properties:{gcpEntityScore:0.128061}}, {start: {_id:9}, end: {_id:63}, properties:{gcpEntityScore:0.32791987}}, {start: {_id:11}, end: {_id:90}, properties:{gcpEntityScore:0.765978}}, {start: {_id:11}, end: {_id:92}, properties:{gcpEntityScore:0.06885115}}, {start: {_id:13}, end: {_id:63}, properties:{gcpEntityScore:0.47779047}}, {start: {_id:14}, end: {_id:63}, properties:{gcpEntityScore:0.63427335}}, {start: {_id:15}, end: {_id:100}, properties:{gcpEntityScore:0.6478481}}, {start: {_id:15}, end: {_id:63}, properties:{gcpEntityScore:0.08027394}}, {start: {_id:23}, end: {_id:56}, properties:{gcpEntityScore:0.60388184}}, {start: {_id:32}, end: {_id:140}, properties:{gcpEntityScore:0.17944223}}, {start: {_id:32}, end: {_id:142}, properties:{gcpEntityScore:0.06478112}}, {start: {_id:33}, end: {_id:140}, properties:{gcpEntityScore:0.51664203}}, {start: {_id:41}, end: {_id:159}, properties:{gcpEntityScore:0.10221045}}, {start: {_id:41}, end: {_id:75}, properties:{gcpEntityScore:0.050508387}}] AS row
MATCH (start:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.start._id})
MATCH (end:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.end._id})
CREATE (start)-[r:HAS_ENTITY]->(end) SET r += row.properties;
UNWIND [{start: {_id:42}, end: {_id:63}, properties:{gcpEntityScore:0.7233959}}, {start: {_id:42}, end: {_id:92}, properties:{gcpEntityScore:0.27660412}}, {start: {_id:43}, end: {_id:160}, properties:{gcpEntityScore:0.7481114}}] AS row
MATCH (start:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.start._id})
MATCH (end:`UNIQUE IMPORT LABEL`{`UNIQUE IMPORT ID`: row.end._id})
CREATE (start)-[r:HAS_ENTITY]->(end) SET r += row.properties;
MATCH (n:`UNIQUE IMPORT LABEL`) WITH n LIMIT 20000 REMOVE n:`UNIQUE IMPORT LABEL` REMOVE n.`UNIQUE IMPORT ID`;
DROP CONSTRAINT ON (node:`UNIQUE IMPORT LABEL`) ASSERT (node.`UNIQUE IMPORT ID`) IS UNIQUE;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment