nodes = { // this is a JS Array of Objects; the key-value pairs consist of the column headers and the cell data let names =[]; let tmp = 0; let cluster = "other" let clusterid = 1 let clusterX = 0 let clusterY = 0 let m = 10 data.forEach(function (d,i) { if(!isNaN(d.month3)){ switch (true) { case ((+d["Local price"] < +d.month3) && (+d.month3 < +d.month6) && (+d.month6 < +d.month9)): cluster = "0<3<6<9" clusterid = 1 clusterX = 800 clusterY = 10 break; case ((+d["Local price"] > +d.month3) && (+d.month3 > +d.month6) && (+d.month6 > +d.month9)): cluster = "0>3>6>9" clusterid = 2 clusterX = 100 clusterY = 450 break; case ((+d["Local price"] < +d.month3) && (+d.month3 < +d.month6)): cluster = "0<3<6" clusterid = 3 clusterX = 800 clusterY = 250 break; case ((+d["Local price"] > +d.month3) && (+d.month3 > +d.month6)): cluster = "0>3>6" clusterid = 4 clusterX = 300 clusterY = 250 break; case ((+d["Local price"] <= +d.month3)) : cluster = "0<3" clusterid = 5 clusterX = 800 clusterY = 450 break; case ((+d["Local price"] >= +d.month3)): cluster = "0>3" clusterid = 6 clusterX = 100 clusterY = 10 break; } let focusX = 110 * Math.cos(clusterid / m * Math.PI * 2) let focusY = 110 * Math.sin(clusterid / m * Math.PI * 2) return names.push({"id": i,"cluster": cluster, "radius": 25, "name": d.ShortCode, "m3": +d.month3,"m6": +d.month6,"m9": +d.month9,"m12": +d.month12,"focusX": clusterX,"focusY": clusterY}) }}) return names; }