Skip to content

Instantly share code, notes, and snippets.

@juniorUsca
Created August 4, 2016 21:40
Show Gist options
  • Save juniorUsca/57767c754eaed3cb5af37cfe31f00d8e to your computer and use it in GitHub Desktop.
Save juniorUsca/57767c754eaed3cb5af37cfe31f00d8e to your computer and use it in GitHub Desktop.
Clustering in Neo4j
CREATE (:Centroid {musica: 126, arte: 16, juegos: 44, peliculas: 116, anime: 70, vida: 95, amanecer: 26, amor: 127, familia: 148, tv: 142, medio_ambiente: 118, mechanotherapeutic: 136, protectorate: 135, phytopaleontological: 143, springlet: 35, diectasis: 24, sconcheon: 60, noncompetitive: 76, bellonion: 24, hami: 142, accusable: 99, operatable: 123, linitis: 30, hoastman: 15, unlanguid: 62, isokurtic: 103, benchboard: 113, gastroplication: 120, alumiferous: 45, chapterful: 134, yeldrock: 81, axopodia: 41, smokebox: 23, fireworky: 107, semideltaic: 62, intimation: 101, tarsioid: 142, fotui: 146, woft: 128, Mandingo: 48, pretincture: 60, pamper: 19, extraneously: 25, consternation: 27, malleate: 109, thisn: 31, ribbony: 100, Lapland: 70, Monticulipora: 118, cetylene: 80, fie: 89, pluvious: 72, gunl: 99, monsieur: 81, producal: 80, Limnophilidae: 114, daitya: 114, octahedral: 146, pegger: 13, index:1, iteration:1 });
CREATE (:Centroid {musica: 58, arte: 59, juegos: 114, peliculas: 127, anime: 97, vida: 118, amanecer: 74, amor: 85, familia: 128, tv: 70, medio_ambiente: 88, mechanotherapeutic: 12, protectorate: 15, phytopaleontological: 18, springlet: 126, diectasis: 124, sconcheon: 143, noncompetitive: 99, bellonion: 137, hami: 145, accusable: 25, operatable: 119, linitis: 31, hoastman: 92, unlanguid: 80, isokurtic: 86, benchboard: 145, gastroplication: 117, alumiferous: 149, chapterful: 60, yeldrock: 76, axopodia: 22, smokebox: 115, fireworky: 85, semideltaic: 19, intimation: 69, tarsioid: 46, fotui: 95, woft: 63, Mandingo: 47, pretincture: 51, pamper: 43, extraneously: 13, consternation: 12, malleate: 74, thisn: 150, ribbony: 133, Lapland: 76, Monticulipora: 71, cetylene: 36, fie: 11, pluvious: 134, gunl: 99, monsieur: 97, producal: 117, Limnophilidae: 15, daitya: 89, octahedral: 105, pegger: 52, index:2, iteration:1 });
CREATE (:Centroid {musica: 90, arte: 87, juegos: 15, peliculas: 91, anime: 114, vida: 90, amanecer: 42, amor: 115, familia: 95, tv: 140, medio_ambiente: 42, mechanotherapeutic: 92, protectorate: 23, phytopaleontological: 65, springlet: 28, diectasis: 131, sconcheon: 80, noncompetitive: 89, bellonion: 77, hami: 87, accusable: 113, operatable: 39, linitis: 62, hoastman: 145, unlanguid: 79, isokurtic: 144, benchboard: 81, gastroplication: 78, alumiferous: 119, chapterful: 21, yeldrock: 120, axopodia: 14, smokebox: 75, fireworky: 108, semideltaic: 92, intimation: 14, tarsioid: 140, fotui: 127, woft: 23, Mandingo: 120, pretincture: 60, pamper: 130, extraneously: 50, consternation: 55, malleate: 100, thisn: 31, ribbony: 98, Lapland: 127, Monticulipora: 120, cetylene: 96, fie: 94, pluvious: 103, gunl: 34, monsieur: 66, producal: 76, Limnophilidae: 139, daitya: 79, octahedral: 141, pegger: 137, index:3, iteration:1 });
CREATE (:Centroid {musica: 72, arte: 109, juegos: 15, peliculas: 40, anime: 108, vida: 87, amanecer: 51, amor: 123, familia: 97, tv: 71, medio_ambiente: 113, mechanotherapeutic: 88, protectorate: 85, phytopaleontological: 112, springlet: 24, diectasis: 149, sconcheon: 20, noncompetitive: 135, bellonion: 54, hami: 33, accusable: 28, operatable: 12, linitis: 36, hoastman: 81, unlanguid: 15, isokurtic: 132, benchboard: 48, gastroplication: 12, alumiferous: 150, chapterful: 90, yeldrock: 44, axopodia: 90, smokebox: 74, fireworky: 114, semideltaic: 89, intimation: 137, tarsioid: 90, fotui: 83, woft: 125, Mandingo: 103, pretincture: 15, pamper: 150, extraneously: 86, consternation: 124, malleate: 74, thisn: 100, ribbony: 36, Lapland: 86, Monticulipora: 98, cetylene: 64, fie: 136, pluvious: 18, gunl: 42, monsieur: 26, producal: 100, Limnophilidae: 139, daitya: 15, octahedral: 94, pegger: 125, index:4, iteration:1 });
CREATE (:Centroid {musica: 62, arte: 137, juegos: 92, peliculas: 61, anime: 92, vida: 143, amanecer: 94, amor: 58, familia: 79, tv: 12, medio_ambiente: 108, mechanotherapeutic: 83, protectorate: 124, phytopaleontological: 45, springlet: 107, diectasis: 145, sconcheon: 64, noncompetitive: 37, bellonion: 36, hami: 66, accusable: 12, operatable: 56, linitis: 113, hoastman: 25, unlanguid: 94, isokurtic: 18, benchboard: 140, gastroplication: 110, alumiferous: 79, chapterful: 38, yeldrock: 74, axopodia: 47, smokebox: 134, fireworky: 22, semideltaic: 15, intimation: 27, tarsioid: 25, fotui: 51, woft: 14, Mandingo: 117, pretincture: 26, pamper: 122, extraneously: 129, consternation: 39, malleate: 35, thisn: 113, ribbony: 21, Lapland: 100, Monticulipora: 65, cetylene: 94, fie: 145, pluvious: 59, gunl: 136, monsieur: 18, producal: 24, Limnophilidae: 143, daitya: 47, octahedral: 42, pegger: 138, index:5, iteration:1 });
CREATE (:Centroid {musica: 71, arte: 56, juegos: 103, peliculas: 120, anime: 110, vida: 45, amanecer: 13, amor: 99, familia: 15, tv: 113, medio_ambiente: 123, mechanotherapeutic: 43, protectorate: 144, phytopaleontological: 117, springlet: 36, diectasis: 45, sconcheon: 135, noncompetitive: 111, bellonion: 113, hami: 30, accusable: 75, operatable: 104, linitis: 120, hoastman: 93, unlanguid: 70, isokurtic: 99, benchboard: 125, gastroplication: 63, alumiferous: 77, chapterful: 73, yeldrock: 103, axopodia: 52, smokebox: 134, fireworky: 142, semideltaic: 33, intimation: 143, tarsioid: 39, fotui: 126, woft: 98, Mandingo: 45, pretincture: 116, pamper: 100, extraneously: 32, consternation: 148, malleate: 10, thisn: 91, ribbony: 43, Lapland: 10, Monticulipora: 64, cetylene: 130, fie: 141, pluvious: 101, gunl: 50, monsieur: 148, producal: 44, Limnophilidae: 14, daitya: 76, octahedral: 119, pegger: 80, index:6, iteration:1 });
CREATE (:Centroid {musica: 135, arte: 23, juegos: 61, peliculas: 33, anime: 132, vida: 122, amanecer: 80, amor: 26, familia: 109, tv: 81, medio_ambiente: 123, mechanotherapeutic: 118, protectorate: 134, phytopaleontological: 85, springlet: 64, diectasis: 29, sconcheon: 108, noncompetitive: 105, bellonion: 113, hami: 57, accusable: 116, operatable: 85, linitis: 149, hoastman: 150, unlanguid: 51, isokurtic: 113, benchboard: 99, gastroplication: 55, alumiferous: 119, chapterful: 113, yeldrock: 147, axopodia: 108, smokebox: 104, fireworky: 18, semideltaic: 66, intimation: 141, tarsioid: 127, fotui: 46, woft: 100, Mandingo: 54, pretincture: 118, pamper: 11, extraneously: 96, consternation: 112, malleate: 73, thisn: 35, ribbony: 96, Lapland: 134, Monticulipora: 42, cetylene: 42, fie: 139, pluvious: 88, gunl: 81, monsieur: 73, producal: 58, Limnophilidae: 19, daitya: 33, octahedral: 121, pegger: 111, index:7, iteration:1 });
CREATE (:Centroid {musica: 121, arte: 45, juegos: 86, peliculas: 95, anime: 30, vida: 97, amanecer: 104, amor: 64, familia: 98, tv: 58, medio_ambiente: 149, mechanotherapeutic: 124, protectorate: 17, phytopaleontological: 137, springlet: 147, diectasis: 88, sconcheon: 127, noncompetitive: 150, bellonion: 107, hami: 83, accusable: 88, operatable: 100, linitis: 100, hoastman: 134, unlanguid: 44, isokurtic: 63, benchboard: 148, gastroplication: 134, alumiferous: 102, chapterful: 93, yeldrock: 101, axopodia: 63, smokebox: 19, fireworky: 90, semideltaic: 138, intimation: 65, tarsioid: 24, fotui: 124, woft: 31, Mandingo: 57, pretincture: 13, pamper: 135, extraneously: 93, consternation: 95, malleate: 94, thisn: 118, ribbony: 78, Lapland: 108, Monticulipora: 34, cetylene: 83, fie: 35, pluvious: 129, gunl: 64, monsieur: 109, producal: 20, Limnophilidae: 69, daitya: 39, octahedral: 137, pegger: 33, index:8, iteration:1 });
CREATE (:Centroid {musica: 92, arte: 118, juegos: 42, peliculas: 33, anime: 46, vida: 33, amanecer: 49, amor: 55, familia: 22, tv: 68, medio_ambiente: 53, mechanotherapeutic: 47, protectorate: 100, phytopaleontological: 86, springlet: 88, diectasis: 112, sconcheon: 146, noncompetitive: 108, bellonion: 62, hami: 143, accusable: 24, operatable: 118, linitis: 48, hoastman: 106, unlanguid: 140, isokurtic: 25, benchboard: 84, gastroplication: 98, alumiferous: 19, chapterful: 81, yeldrock: 45, axopodia: 89, smokebox: 117, fireworky: 114, semideltaic: 137, intimation: 97, tarsioid: 63, fotui: 38, woft: 87, Mandingo: 58, pretincture: 132, pamper: 100, extraneously: 113, consternation: 23, malleate: 104, thisn: 66, ribbony: 105, Lapland: 138, Monticulipora: 73, cetylene: 134, fie: 140, pluvious: 128, gunl: 68, monsieur: 103, producal: 118, Limnophilidae: 122, daitya: 48, octahedral: 78, pegger: 20, index:9, iteration:1 });
CREATE (:Centroid {musica: 97, arte: 124, juegos: 73, peliculas: 92, anime: 95, vida: 139, amanecer: 145, amor: 20, familia: 35, tv: 136, medio_ambiente: 79, mechanotherapeutic: 88, protectorate: 137, phytopaleontological: 66, springlet: 120, diectasis: 141, sconcheon: 19, noncompetitive: 40, bellonion: 143, hami: 143, accusable: 133, operatable: 29, linitis: 12, hoastman: 145, unlanguid: 36, isokurtic: 31, benchboard: 96, gastroplication: 85, alumiferous: 99, chapterful: 37, yeldrock: 12, axopodia: 43, smokebox: 118, fireworky: 141, semideltaic: 19, intimation: 28, tarsioid: 67, fotui: 123, woft: 145, Mandingo: 65, pretincture: 36, pamper: 70, extraneously: 43, consternation: 39, malleate: 84, thisn: 92, ribbony: 146, Lapland: 69, Monticulipora: 118, cetylene: 79, fie: 112, pluvious: 106, gunl: 40, monsieur: 65, producal: 47, Limnophilidae: 85, daitya: 19, octahedral: 106, pegger: 90, index:10, iteration:1 });
MATCH (s:Pais), (c1:Centroid{index: 1, iteration: 1}), (c2:Centroid{index: 2, iteration: 1}), (c3:Centroid{index: 3, iteration: 1}), (c4:Centroid{index: 4, iteration: 1}) , (c5:Centroid{index: 5, iteration: 1}) , (c6:Centroid{index: 6, iteration: 1}) , (c7:Centroid{index: 7, iteration: 1}) , (c8:Centroid{index: 8, iteration: 1}) , (c9:Centroid{index: 9, iteration: 1}) , (c10:Centroid{index: 10, iteration: 1})
SET s.distC1 = (s.musica-c1.musica)^2 + (s.arte-c1.arte)^2 + (s.juegos-c1.juegos)^2 + (s.peliculas-c1.peliculas)^2 + (s.anime-c1.anime)^2 + (s.vida-c1.vida)^2 + (s.amanecer-c1.amanecer)^2 + (s.amor-c1.amor)^2 + (s.familia-c1.familia)^2 + (s.tv-c1.tv)^2 + (s.medio_ambiente-c1.medio_ambiente)^2 + (s.mechanotherapeutic-c1.mechanotherapeutic)^2 + (s.protectorate-c1.protectorate)^2 + (s.phytopaleontological-c1.phytopaleontological)^2 + (s.springlet-c1.springlet)^2 + (s.diectasis-c1.diectasis)^2 + (s.sconcheon-c1.sconcheon)^2 + (s.noncompetitive-c1.noncompetitive)^2 + (s.bellonion-c1.bellonion)^2 + (s.hami-c1.hami)^2 + (s.accusable-c1.accusable)^2 + (s.operatable-c1.operatable)^2 + (s.linitis-c1.linitis)^2 + (s.hoastman-c1.hoastman)^2 + (s.unlanguid-c1.unlanguid)^2 + (s.isokurtic-c1.isokurtic)^2 + (s.benchboard-c1.benchboard)^2 + (s.gastroplication-c1.gastroplication)^2 + (s.alumiferous-c1.alumiferous)^2 + (s.chapterful-c1.chapterful)^2 + (s.yeldrock-c1.yeldrock)^2 + (s.axopodia-c1.axopodia)^2 + (s.smokebox-c1.smokebox)^2 + (s.fireworky-c1.fireworky)^2 + (s.semideltaic-c1.semideltaic)^2 + (s.intimation-c1.intimation)^2 + (s.tarsioid-c1.tarsioid)^2 + (s.fotui-c1.fotui)^2 + (s.woft-c1.woft)^2 + (s.Mandingo-c1.Mandingo)^2 + (s.pretincture-c1.pretincture)^2 + (s.pamper-c1.pamper)^2 + (s.extraneously-c1.extraneously)^2 + (s.consternation-c1.consternation)^2 + (s.malleate-c1.malleate)^2 + (s.thisn-c1.thisn)^2 + (s.ribbony-c1.ribbony)^2 + (s.Lapland-c1.Lapland)^2 + (s.Monticulipora-c1.Monticulipora)^2 + (s.cetylene-c1.cetylene)^2 + (s.fie-c1.fie)^2 + (s.pluvious-c1.pluvious)^2 + (s.gunl-c1.gunl)^2 + (s.monsieur-c1.monsieur)^2 + (s.producal-c1.producal)^2 + (s.Limnophilidae-c1.Limnophilidae)^2 + (s.daitya-c1.daitya)^2 + (s.octahedral-c1.octahedral)^2 + (s.pegger-c1.pegger)^2
SET s.distC2 = (s.musica-c2.musica)^2 + (s.arte-c2.arte)^2 + (s.juegos-c2.juegos)^2 + (s.peliculas-c2.peliculas)^2 + (s.anime-c2.anime)^2 + (s.vida-c2.vida)^2 + (s.amanecer-c2.amanecer)^2 + (s.amor-c2.amor)^2 + (s.familia-c2.familia)^2 + (s.tv-c2.tv)^2 + (s.medio_ambiente-c2.medio_ambiente)^2 + (s.mechanotherapeutic-c2.mechanotherapeutic)^2 + (s.protectorate-c2.protectorate)^2 + (s.phytopaleontological-c2.phytopaleontological)^2 + (s.springlet-c2.springlet)^2 + (s.diectasis-c2.diectasis)^2 + (s.sconcheon-c2.sconcheon)^2 + (s.noncompetitive-c2.noncompetitive)^2 + (s.bellonion-c2.bellonion)^2 + (s.hami-c2.hami)^2 + (s.accusable-c2.accusable)^2 + (s.operatable-c2.operatable)^2 + (s.linitis-c2.linitis)^2 + (s.hoastman-c2.hoastman)^2 + (s.unlanguid-c2.unlanguid)^2 + (s.isokurtic-c2.isokurtic)^2 + (s.benchboard-c2.benchboard)^2 + (s.gastroplication-c2.gastroplication)^2 + (s.alumiferous-c2.alumiferous)^2 + (s.chapterful-c2.chapterful)^2 + (s.yeldrock-c2.yeldrock)^2 + (s.axopodia-c2.axopodia)^2 + (s.smokebox-c2.smokebox)^2 + (s.fireworky-c2.fireworky)^2 + (s.semideltaic-c2.semideltaic)^2 + (s.intimation-c2.intimation)^2 + (s.tarsioid-c2.tarsioid)^2 + (s.fotui-c2.fotui)^2 + (s.woft-c2.woft)^2 + (s.Mandingo-c2.Mandingo)^2 + (s.pretincture-c2.pretincture)^2 + (s.pamper-c2.pamper)^2 + (s.extraneously-c2.extraneously)^2 + (s.consternation-c2.consternation)^2 + (s.malleate-c2.malleate)^2 + (s.thisn-c2.thisn)^2 + (s.ribbony-c2.ribbony)^2 + (s.Lapland-c2.Lapland)^2 + (s.Monticulipora-c2.Monticulipora)^2 + (s.cetylene-c2.cetylene)^2 + (s.fie-c2.fie)^2 + (s.pluvious-c2.pluvious)^2 + (s.gunl-c2.gunl)^2 + (s.monsieur-c2.monsieur)^2 + (s.producal-c2.producal)^2 + (s.Limnophilidae-c2.Limnophilidae)^2 + (s.daitya-c2.daitya)^2 + (s.octahedral-c2.octahedral)^2 + (s.pegger-c2.pegger)^2
SET s.distC3 = (s.musica-c3.musica)^2 + (s.arte-c3.arte)^2 + (s.juegos-c3.juegos)^2 + (s.peliculas-c3.peliculas)^2 + (s.anime-c3.anime)^2 + (s.vida-c3.vida)^2 + (s.amanecer-c3.amanecer)^2 + (s.amor-c3.amor)^2 + (s.familia-c3.familia)^2 + (s.tv-c3.tv)^2 + (s.medio_ambiente-c3.medio_ambiente)^2 + (s.mechanotherapeutic-c3.mechanotherapeutic)^2 + (s.protectorate-c3.protectorate)^2 + (s.phytopaleontological-c3.phytopaleontological)^2 + (s.springlet-c3.springlet)^2 + (s.diectasis-c3.diectasis)^2 + (s.sconcheon-c3.sconcheon)^2 + (s.noncompetitive-c3.noncompetitive)^2 + (s.bellonion-c3.bellonion)^2 + (s.hami-c3.hami)^2 + (s.accusable-c3.accusable)^2 + (s.operatable-c3.operatable)^2 + (s.linitis-c3.linitis)^2 + (s.hoastman-c3.hoastman)^2 + (s.unlanguid-c3.unlanguid)^2 + (s.isokurtic-c3.isokurtic)^2 + (s.benchboard-c3.benchboard)^2 + (s.gastroplication-c3.gastroplication)^2 + (s.alumiferous-c3.alumiferous)^2 + (s.chapterful-c3.chapterful)^2 + (s.yeldrock-c3.yeldrock)^2 + (s.axopodia-c3.axopodia)^2 + (s.smokebox-c3.smokebox)^2 + (s.fireworky-c3.fireworky)^2 + (s.semideltaic-c3.semideltaic)^2 + (s.intimation-c3.intimation)^2 + (s.tarsioid-c3.tarsioid)^2 + (s.fotui-c3.fotui)^2 + (s.woft-c3.woft)^2 + (s.Mandingo-c3.Mandingo)^2 + (s.pretincture-c3.pretincture)^2 + (s.pamper-c3.pamper)^2 + (s.extraneously-c3.extraneously)^2 + (s.consternation-c3.consternation)^2 + (s.malleate-c3.malleate)^2 + (s.thisn-c3.thisn)^2 + (s.ribbony-c3.ribbony)^2 + (s.Lapland-c3.Lapland)^2 + (s.Monticulipora-c3.Monticulipora)^2 + (s.cetylene-c3.cetylene)^2 + (s.fie-c3.fie)^2 + (s.pluvious-c3.pluvious)^2 + (s.gunl-c3.gunl)^2 + (s.monsieur-c3.monsieur)^2 + (s.producal-c3.producal)^2 + (s.Limnophilidae-c3.Limnophilidae)^2 + (s.daitya-c3.daitya)^2 + (s.octahedral-c3.octahedral)^2 + (s.pegger-c3.pegger)^2
SET s.distC4 = (s.musica-c4.musica)^2 + (s.arte-c4.arte)^2 + (s.juegos-c4.juegos)^2 + (s.peliculas-c4.peliculas)^2 + (s.anime-c4.anime)^2 + (s.vida-c4.vida)^2 + (s.amanecer-c4.amanecer)^2 + (s.amor-c4.amor)^2 + (s.familia-c4.familia)^2 + (s.tv-c4.tv)^2 + (s.medio_ambiente-c4.medio_ambiente)^2 + (s.mechanotherapeutic-c4.mechanotherapeutic)^2 + (s.protectorate-c4.protectorate)^2 + (s.phytopaleontological-c4.phytopaleontological)^2 + (s.springlet-c4.springlet)^2 + (s.diectasis-c4.diectasis)^2 + (s.sconcheon-c4.sconcheon)^2 + (s.noncompetitive-c4.noncompetitive)^2 + (s.bellonion-c4.bellonion)^2 + (s.hami-c4.hami)^2 + (s.accusable-c4.accusable)^2 + (s.operatable-c4.operatable)^2 + (s.linitis-c4.linitis)^2 + (s.hoastman-c4.hoastman)^2 + (s.unlanguid-c4.unlanguid)^2 + (s.isokurtic-c4.isokurtic)^2 + (s.benchboard-c4.benchboard)^2 + (s.gastroplication-c4.gastroplication)^2 + (s.alumiferous-c4.alumiferous)^2 + (s.chapterful-c4.chapterful)^2 + (s.yeldrock-c4.yeldrock)^2 + (s.axopodia-c4.axopodia)^2 + (s.smokebox-c4.smokebox)^2 + (s.fireworky-c4.fireworky)^2 + (s.semideltaic-c4.semideltaic)^2 + (s.intimation-c4.intimation)^2 + (s.tarsioid-c4.tarsioid)^2 + (s.fotui-c4.fotui)^2 + (s.woft-c4.woft)^2 + (s.Mandingo-c4.Mandingo)^2 + (s.pretincture-c4.pretincture)^2 + (s.pamper-c4.pamper)^2 + (s.extraneously-c4.extraneously)^2 + (s.consternation-c4.consternation)^2 + (s.malleate-c4.malleate)^2 + (s.thisn-c4.thisn)^2 + (s.ribbony-c4.ribbony)^2 + (s.Lapland-c4.Lapland)^2 + (s.Monticulipora-c4.Monticulipora)^2 + (s.cetylene-c4.cetylene)^2 + (s.fie-c4.fie)^2 + (s.pluvious-c4.pluvious)^2 + (s.gunl-c4.gunl)^2 + (s.monsieur-c4.monsieur)^2 + (s.producal-c4.producal)^2 + (s.Limnophilidae-c4.Limnophilidae)^2 + (s.daitya-c4.daitya)^2 + (s.octahedral-c4.octahedral)^2 + (s.pegger-c4.pegger)^2
SET s.distC5 = (s.musica-c5.musica)^2 + (s.arte-c5.arte)^2 + (s.juegos-c5.juegos)^2 + (s.peliculas-c5.peliculas)^2 + (s.anime-c5.anime)^2 + (s.vida-c5.vida)^2 + (s.amanecer-c5.amanecer)^2 + (s.amor-c5.amor)^2 + (s.familia-c5.familia)^2 + (s.tv-c5.tv)^2 + (s.medio_ambiente-c5.medio_ambiente)^2 + (s.mechanotherapeutic-c5.mechanotherapeutic)^2 + (s.protectorate-c5.protectorate)^2 + (s.phytopaleontological-c5.phytopaleontological)^2 + (s.springlet-c5.springlet)^2 + (s.diectasis-c5.diectasis)^2 + (s.sconcheon-c5.sconcheon)^2 + (s.noncompetitive-c5.noncompetitive)^2 + (s.bellonion-c5.bellonion)^2 + (s.hami-c5.hami)^2 + (s.accusable-c5.accusable)^2 + (s.operatable-c5.operatable)^2 + (s.linitis-c5.linitis)^2 + (s.hoastman-c5.hoastman)^2 + (s.unlanguid-c5.unlanguid)^2 + (s.isokurtic-c5.isokurtic)^2 + (s.benchboard-c5.benchboard)^2 + (s.gastroplication-c5.gastroplication)^2 + (s.alumiferous-c5.alumiferous)^2 + (s.chapterful-c5.chapterful)^2 + (s.yeldrock-c5.yeldrock)^2 + (s.axopodia-c5.axopodia)^2 + (s.smokebox-c5.smokebox)^2 + (s.fireworky-c5.fireworky)^2 + (s.semideltaic-c5.semideltaic)^2 + (s.intimation-c5.intimation)^2 + (s.tarsioid-c5.tarsioid)^2 + (s.fotui-c5.fotui)^2 + (s.woft-c5.woft)^2 + (s.Mandingo-c5.Mandingo)^2 + (s.pretincture-c5.pretincture)^2 + (s.pamper-c5.pamper)^2 + (s.extraneously-c5.extraneously)^2 + (s.consternation-c5.consternation)^2 + (s.malleate-c5.malleate)^2 + (s.thisn-c5.thisn)^2 + (s.ribbony-c5.ribbony)^2 + (s.Lapland-c5.Lapland)^2 + (s.Monticulipora-c5.Monticulipora)^2 + (s.cetylene-c5.cetylene)^2 + (s.fie-c5.fie)^2 + (s.pluvious-c5.pluvious)^2 + (s.gunl-c5.gunl)^2 + (s.monsieur-c5.monsieur)^2 + (s.producal-c5.producal)^2 + (s.Limnophilidae-c5.Limnophilidae)^2 + (s.daitya-c5.daitya)^2 + (s.octahedral-c5.octahedral)^2 + (s.pegger-c5.pegger)^2
SET s.distC6 = (s.musica-c6.musica)^2 + (s.arte-c6.arte)^2 + (s.juegos-c6.juegos)^2 + (s.peliculas-c6.peliculas)^2 + (s.anime-c6.anime)^2 + (s.vida-c6.vida)^2 + (s.amanecer-c6.amanecer)^2 + (s.amor-c6.amor)^2 + (s.familia-c6.familia)^2 + (s.tv-c6.tv)^2 + (s.medio_ambiente-c6.medio_ambiente)^2 + (s.mechanotherapeutic-c6.mechanotherapeutic)^2 + (s.protectorate-c6.protectorate)^2 + (s.phytopaleontological-c6.phytopaleontological)^2 + (s.springlet-c6.springlet)^2 + (s.diectasis-c6.diectasis)^2 + (s.sconcheon-c6.sconcheon)^2 + (s.noncompetitive-c6.noncompetitive)^2 + (s.bellonion-c6.bellonion)^2 + (s.hami-c6.hami)^2 + (s.accusable-c6.accusable)^2 + (s.operatable-c6.operatable)^2 + (s.linitis-c6.linitis)^2 + (s.hoastman-c6.hoastman)^2 + (s.unlanguid-c6.unlanguid)^2 + (s.isokurtic-c6.isokurtic)^2 + (s.benchboard-c6.benchboard)^2 + (s.gastroplication-c6.gastroplication)^2 + (s.alumiferous-c6.alumiferous)^2 + (s.chapterful-c6.chapterful)^2 + (s.yeldrock-c6.yeldrock)^2 + (s.axopodia-c6.axopodia)^2 + (s.smokebox-c6.smokebox)^2 + (s.fireworky-c6.fireworky)^2 + (s.semideltaic-c6.semideltaic)^2 + (s.intimation-c6.intimation)^2 + (s.tarsioid-c6.tarsioid)^2 + (s.fotui-c6.fotui)^2 + (s.woft-c6.woft)^2 + (s.Mandingo-c6.Mandingo)^2 + (s.pretincture-c6.pretincture)^2 + (s.pamper-c6.pamper)^2 + (s.extraneously-c6.extraneously)^2 + (s.consternation-c6.consternation)^2 + (s.malleate-c6.malleate)^2 + (s.thisn-c6.thisn)^2 + (s.ribbony-c6.ribbony)^2 + (s.Lapland-c6.Lapland)^2 + (s.Monticulipora-c6.Monticulipora)^2 + (s.cetylene-c6.cetylene)^2 + (s.fie-c6.fie)^2 + (s.pluvious-c6.pluvious)^2 + (s.gunl-c6.gunl)^2 + (s.monsieur-c6.monsieur)^2 + (s.producal-c6.producal)^2 + (s.Limnophilidae-c6.Limnophilidae)^2 + (s.daitya-c6.daitya)^2 + (s.octahedral-c6.octahedral)^2 + (s.pegger-c6.pegger)^2
SET s.distC7 = (s.musica-c7.musica)^2 + (s.arte-c7.arte)^2 + (s.juegos-c7.juegos)^2 + (s.peliculas-c7.peliculas)^2 + (s.anime-c7.anime)^2 + (s.vida-c7.vida)^2 + (s.amanecer-c7.amanecer)^2 + (s.amor-c7.amor)^2 + (s.familia-c7.familia)^2 + (s.tv-c7.tv)^2 + (s.medio_ambiente-c7.medio_ambiente)^2 + (s.mechanotherapeutic-c7.mechanotherapeutic)^2 + (s.protectorate-c7.protectorate)^2 + (s.phytopaleontological-c7.phytopaleontological)^2 + (s.springlet-c7.springlet)^2 + (s.diectasis-c7.diectasis)^2 + (s.sconcheon-c7.sconcheon)^2 + (s.noncompetitive-c7.noncompetitive)^2 + (s.bellonion-c7.bellonion)^2 + (s.hami-c7.hami)^2 + (s.accusable-c7.accusable)^2 + (s.operatable-c7.operatable)^2 + (s.linitis-c7.linitis)^2 + (s.hoastman-c7.hoastman)^2 + (s.unlanguid-c7.unlanguid)^2 + (s.isokurtic-c7.isokurtic)^2 + (s.benchboard-c7.benchboard)^2 + (s.gastroplication-c7.gastroplication)^2 + (s.alumiferous-c7.alumiferous)^2 + (s.chapterful-c7.chapterful)^2 + (s.yeldrock-c7.yeldrock)^2 + (s.axopodia-c7.axopodia)^2 + (s.smokebox-c7.smokebox)^2 + (s.fireworky-c7.fireworky)^2 + (s.semideltaic-c7.semideltaic)^2 + (s.intimation-c7.intimation)^2 + (s.tarsioid-c7.tarsioid)^2 + (s.fotui-c7.fotui)^2 + (s.woft-c7.woft)^2 + (s.Mandingo-c7.Mandingo)^2 + (s.pretincture-c7.pretincture)^2 + (s.pamper-c7.pamper)^2 + (s.extraneously-c7.extraneously)^2 + (s.consternation-c7.consternation)^2 + (s.malleate-c7.malleate)^2 + (s.thisn-c7.thisn)^2 + (s.ribbony-c7.ribbony)^2 + (s.Lapland-c7.Lapland)^2 + (s.Monticulipora-c7.Monticulipora)^2 + (s.cetylene-c7.cetylene)^2 + (s.fie-c7.fie)^2 + (s.pluvious-c7.pluvious)^2 + (s.gunl-c7.gunl)^2 + (s.monsieur-c7.monsieur)^2 + (s.producal-c7.producal)^2 + (s.Limnophilidae-c7.Limnophilidae)^2 + (s.daitya-c7.daitya)^2 + (s.octahedral-c7.octahedral)^2 + (s.pegger-c7.pegger)^2
SET s.distC8 = (s.musica-c8.musica)^2 + (s.arte-c8.arte)^2 + (s.juegos-c8.juegos)^2 + (s.peliculas-c8.peliculas)^2 + (s.anime-c8.anime)^2 + (s.vida-c8.vida)^2 + (s.amanecer-c8.amanecer)^2 + (s.amor-c8.amor)^2 + (s.familia-c8.familia)^2 + (s.tv-c8.tv)^2 + (s.medio_ambiente-c8.medio_ambiente)^2 + (s.mechanotherapeutic-c8.mechanotherapeutic)^2 + (s.protectorate-c8.protectorate)^2 + (s.phytopaleontological-c8.phytopaleontological)^2 + (s.springlet-c8.springlet)^2 + (s.diectasis-c8.diectasis)^2 + (s.sconcheon-c8.sconcheon)^2 + (s.noncompetitive-c8.noncompetitive)^2 + (s.bellonion-c8.bellonion)^2 + (s.hami-c8.hami)^2 + (s.accusable-c8.accusable)^2 + (s.operatable-c8.operatable)^2 + (s.linitis-c8.linitis)^2 + (s.hoastman-c8.hoastman)^2 + (s.unlanguid-c8.unlanguid)^2 + (s.isokurtic-c8.isokurtic)^2 + (s.benchboard-c8.benchboard)^2 + (s.gastroplication-c8.gastroplication)^2 + (s.alumiferous-c8.alumiferous)^2 + (s.chapterful-c8.chapterful)^2 + (s.yeldrock-c8.yeldrock)^2 + (s.axopodia-c8.axopodia)^2 + (s.smokebox-c8.smokebox)^2 + (s.fireworky-c8.fireworky)^2 + (s.semideltaic-c8.semideltaic)^2 + (s.intimation-c8.intimation)^2 + (s.tarsioid-c8.tarsioid)^2 + (s.fotui-c8.fotui)^2 + (s.woft-c8.woft)^2 + (s.Mandingo-c8.Mandingo)^2 + (s.pretincture-c8.pretincture)^2 + (s.pamper-c8.pamper)^2 + (s.extraneously-c8.extraneously)^2 + (s.consternation-c8.consternation)^2 + (s.malleate-c8.malleate)^2 + (s.thisn-c8.thisn)^2 + (s.ribbony-c8.ribbony)^2 + (s.Lapland-c8.Lapland)^2 + (s.Monticulipora-c8.Monticulipora)^2 + (s.cetylene-c8.cetylene)^2 + (s.fie-c8.fie)^2 + (s.pluvious-c8.pluvious)^2 + (s.gunl-c8.gunl)^2 + (s.monsieur-c8.monsieur)^2 + (s.producal-c8.producal)^2 + (s.Limnophilidae-c8.Limnophilidae)^2 + (s.daitya-c8.daitya)^2 + (s.octahedral-c8.octahedral)^2 + (s.pegger-c8.pegger)^2
SET s.distC9 = (s.musica-c9.musica)^2 + (s.arte-c9.arte)^2 + (s.juegos-c9.juegos)^2 + (s.peliculas-c9.peliculas)^2 + (s.anime-c9.anime)^2 + (s.vida-c9.vida)^2 + (s.amanecer-c9.amanecer)^2 + (s.amor-c9.amor)^2 + (s.familia-c9.familia)^2 + (s.tv-c9.tv)^2 + (s.medio_ambiente-c9.medio_ambiente)^2 + (s.mechanotherapeutic-c9.mechanotherapeutic)^2 + (s.protectorate-c9.protectorate)^2 + (s.phytopaleontological-c9.phytopaleontological)^2 + (s.springlet-c9.springlet)^2 + (s.diectasis-c9.diectasis)^2 + (s.sconcheon-c9.sconcheon)^2 + (s.noncompetitive-c9.noncompetitive)^2 + (s.bellonion-c9.bellonion)^2 + (s.hami-c9.hami)^2 + (s.accusable-c9.accusable)^2 + (s.operatable-c9.operatable)^2 + (s.linitis-c9.linitis)^2 + (s.hoastman-c9.hoastman)^2 + (s.unlanguid-c9.unlanguid)^2 + (s.isokurtic-c9.isokurtic)^2 + (s.benchboard-c9.benchboard)^2 + (s.gastroplication-c9.gastroplication)^2 + (s.alumiferous-c9.alumiferous)^2 + (s.chapterful-c9.chapterful)^2 + (s.yeldrock-c9.yeldrock)^2 + (s.axopodia-c9.axopodia)^2 + (s.smokebox-c9.smokebox)^2 + (s.fireworky-c9.fireworky)^2 + (s.semideltaic-c9.semideltaic)^2 + (s.intimation-c9.intimation)^2 + (s.tarsioid-c9.tarsioid)^2 + (s.fotui-c9.fotui)^2 + (s.woft-c9.woft)^2 + (s.Mandingo-c9.Mandingo)^2 + (s.pretincture-c9.pretincture)^2 + (s.pamper-c9.pamper)^2 + (s.extraneously-c9.extraneously)^2 + (s.consternation-c9.consternation)^2 + (s.malleate-c9.malleate)^2 + (s.thisn-c9.thisn)^2 + (s.ribbony-c9.ribbony)^2 + (s.Lapland-c9.Lapland)^2 + (s.Monticulipora-c9.Monticulipora)^2 + (s.cetylene-c9.cetylene)^2 + (s.fie-c9.fie)^2 + (s.pluvious-c9.pluvious)^2 + (s.gunl-c9.gunl)^2 + (s.monsieur-c9.monsieur)^2 + (s.producal-c9.producal)^2 + (s.Limnophilidae-c9.Limnophilidae)^2 + (s.daitya-c9.daitya)^2 + (s.octahedral-c9.octahedral)^2 + (s.pegger-c9.pegger)^2
SET s.distC10 = (s.musica-c10.musica)^2 + (s.arte-c10.arte)^2 + (s.juegos-c10.juegos)^2 + (s.peliculas-c10.peliculas)^2 + (s.anime-c10.anime)^2 + (s.vida-c10.vida)^2 + (s.amanecer-c10.amanecer)^2 + (s.amor-c10.amor)^2 + (s.familia-c10.familia)^2 + (s.tv-c10.tv)^2 + (s.medio_ambiente-c10.medio_ambiente)^2 + (s.mechanotherapeutic-c10.mechanotherapeutic)^2 + (s.protectorate-c10.protectorate)^2 + (s.phytopaleontological-c10.phytopaleontological)^2 + (s.springlet-c10.springlet)^2 + (s.diectasis-c10.diectasis)^2 + (s.sconcheon-c10.sconcheon)^2 + (s.noncompetitive-c10.noncompetitive)^2 + (s.bellonion-c10.bellonion)^2 + (s.hami-c10.hami)^2 + (s.accusable-c10.accusable)^2 + (s.operatable-c10.operatable)^2 + (s.linitis-c10.linitis)^2 + (s.hoastman-c10.hoastman)^2 + (s.unlanguid-c10.unlanguid)^2 + (s.isokurtic-c10.isokurtic)^2 + (s.benchboard-c10.benchboard)^2 + (s.gastroplication-c10.gastroplication)^2 + (s.alumiferous-c10.alumiferous)^2 + (s.chapterful-c10.chapterful)^2 + (s.yeldrock-c10.yeldrock)^2 + (s.axopodia-c10.axopodia)^2 + (s.smokebox-c10.smokebox)^2 + (s.fireworky-c10.fireworky)^2 + (s.semideltaic-c10.semideltaic)^2 + (s.intimation-c10.intimation)^2 + (s.tarsioid-c10.tarsioid)^2 + (s.fotui-c10.fotui)^2 + (s.woft-c10.woft)^2 + (s.Mandingo-c10.Mandingo)^2 + (s.pretincture-c10.pretincture)^2 + (s.pamper-c10.pamper)^2 + (s.extraneously-c10.extraneously)^2 + (s.consternation-c10.consternation)^2 + (s.malleate-c10.malleate)^2 + (s.thisn-c10.thisn)^2 + (s.ribbony-c10.ribbony)^2 + (s.Lapland-c10.Lapland)^2 + (s.Monticulipora-c10.Monticulipora)^2 + (s.cetylene-c10.cetylene)^2 + (s.fie-c10.fie)^2 + (s.pluvious-c10.pluvious)^2 + (s.gunl-c10.gunl)^2 + (s.monsieur-c10.monsieur)^2 + (s.producal-c10.producal)^2 + (s.Limnophilidae-c10.Limnophilidae)^2 + (s.daitya-c10.daitya)^2 + (s.octahedral-c10.octahedral)^2 + (s.pegger-c10.pegger)^2
WITH s,
case
when s.distC1 <= s.distC2 and s.distC1 <= s.distC3 and s.distC1 <= s.distC4 and s.distC1 <= s.distC5 and s.distC1 <= s.distC6 and s.distC1 <= s.distC7 and s.distC1 <= s.distC8 and s.distC1 <= s.distC9 and s.distC1 <= s.distC10 then
c1
when s.distC2 <= s.distC1 and s.distC2 <= s.distC3 and s.distC2 <= s.distC4 and s.distC2 <= s.distC5 and s.distC2 <= s.distC6 and s.distC2 <= s.distC7 and s.distC2 <= s.distC8 and s.distC2 <= s.distC9 and s.distC2 <= s.distC10 then
c2
when s.distC3 <= s.distC1 and s.distC3 <= s.distC2 and s.distC3 <= s.distC4 and s.distC3 <= s.distC5 and s.distC3 <= s.distC6 and s.distC3 <= s.distC7 and s.distC3 <= s.distC8 and s.distC3 <= s.distC9 and s.distC3 <= s.distC10 then
c3
when s.distC4 <= s.distC1 and s.distC4 <= s.distC2 and s.distC4 <= s.distC3 and s.distC4 <= s.distC5 and s.distC4 <= s.distC6 and s.distC4 <= s.distC7 and s.distC4 <= s.distC8 and s.distC4 <= s.distC9 and s.distC4 <= s.distC10 then
c4
when s.distC5 <= s.distC1 and s.distC5 <= s.distC2 and s.distC5 <= s.distC3 and s.distC5 <= s.distC4 and s.distC5 <= s.distC6 and s.distC5 <= s.distC7 and s.distC5 <= s.distC8 and s.distC5 <= s.distC9 and s.distC5 <= s.distC10 then
c5
when s.distC6 <= s.distC1 and s.distC6 <= s.distC2 and s.distC6 <= s.distC3 and s.distC6 <= s.distC4 and s.distC6 <= s.distC5 and s.distC6 <= s.distC7 and s.distC6 <= s.distC8 and s.distC6 <= s.distC9 and s.distC6 <= s.distC10 then
c6
when s.distC7 <= s.distC1 and s.distC7 <= s.distC2 and s.distC7 <= s.distC3 and s.distC7 <= s.distC4 and s.distC7 <= s.distC5 and s.distC7 <= s.distC6 and s.distC7 <= s.distC8 and s.distC7 <= s.distC9 and s.distC7 <= s.distC10 then
c7
when s.distC8 <= s.distC1 and s.distC8 <= s.distC2 and s.distC8 <= s.distC3 and s.distC8 <= s.distC4 and s.distC8 <= s.distC5 and s.distC8 <= s.distC6 and s.distC8 <= s.distC7 and s.distC8 <= s.distC9 and s.distC8 <= s.distC10 then
c8
when s.distC9 <= s.distC1 and s.distC9 <= s.distC2 and s.distC9 <= s.distC3 and s.distC9 <= s.distC4 and s.distC9 <= s.distC5 and s.distC9 <= s.distC6 and s.distC9 <= s.distC7 and s.distC9 <= s.distC8 and s.distC9 <= s.distC10 then
c9
else
c10
end as minC
CREATE (s)-[:IN_CLUSTER]->(minC)
RETURN *;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment