title: How do I create a relationship with Parent and Child using cypher?
body: <p>I have use the <code>LOAD</code> feature to get my CSV into Neo4j. However, I am unsure how to map all of the Parent categories to the Child categories.</p>
  
  <p>This is the example CSV:</p>
  
  <pre><code>category_id,category,description,parent_id,is_adult
  4,Electronics,Electronics,0,0
  5,Audio Equipment,Audio Equipment,4,0
  6,Home Entertainment,Home Entertainment,4,0
  7,Photography,Photography,4,0
  8,Portable Audio,Portable Audio,4,0
  9,Televisions,Televisions,4,0
  10,Amplifiers &amp; Receivers,Amplifiers &amp; Receivers,5,0
  11,Audio Systems,Audio Systems,5,0
  12,Cassette Decks,Cassette Decks,5,0
  13,CD Players,CD Players,5,0
  14,Radios,Radios,5,0
  15,HiFi Speakers,HiFi Speakers,5,0
  17,MiniDisc Separates,MiniDisc Separates,5,0
  18,Tuners,Tuners,5,0
  19,DJ Equipment,DJ Equipment,5,0
  20,DVD Players,DVD Players,6,0
  21,DVD Recorders,DVD Recorders,6,0
  22,Headphones,Headphones,6,0
  23,Home Cinema,Home Cinema,6,0
  24,Projectors,Projectors,6,0
  25,Remote Controls,Remote Controls,6,0
  26,Set Top Boxes &amp; Receivers,Set Top Boxes &amp; Receivers,6,0
  27,VCR Players,VCR Players,6,0
  29,Camcorders,Camcorders,7,0
  30,Accessories,Accessories,7,0
  32,Cameras,Cameras,7,0
  </code></pre>
  
  <p>As you can see category_id(11) has a parent_id(5)</p>
  
  <p>The LOAD CSV command I am using is:</p>
  
  <pre><code>USING PERIODIC COMMIT LOAD CSV WITH HEADERS FROM "file:///tmp/categories.csv" AS row 
  CREATE (:Category {category_id: row.category_id, category: row.category, description: row.description, parent_id: row.parent_id, is_adult: row.is_adult});
  </code></pre>
  
  <p>I have not used the conversion for is_adult(Boolean) yet.</p>
  
  <p>I'm very new to Neo4j and would welcome any help.</p>