merging arraying in d3.js

[Kuhu Gupta]

My elex.csv is in this format-

"CONUM",PIXPMK","PIXMAR

"1","461","436" "2","398","428", "3","447","436" I want my dataset in this format-

var dataset1 = [ [1, 417], [1, 436], [2, 398], [2, 428], [3, 447], [3, 436]];

I have tried several times to get the fetch the data from csv in this form but all in vain.please help me out.I am attaching my code-

var dataset1 = [];

d3.csv("elex.csv", function(data) { dataset1 = data.map(function(d) { return [ [+d["CONUM"], +d["PIXMAR"]],[+d["CONUM"],+d["PIXPMK"]]]; }); console.log(dataset1) });

this returns me dataset1 as [[[1,417],[1,436]],[[2,398],[2,428]]]

[Curran]

Hi Kuhu,

Try this solution:

var dataset1 = [];

d3.csv("elex.csv", function(data) {

  data.forEach(function(d) {

    dataset1.push([+d.CONUM, +d.PIXMAR]);

    dataset1.push([+d.CONUM, +d.PIXPMK]);

  });

  console.log(dataset1);

});

map gives one entry per input row, but since you want two output entries per input row, you can use forEach to execute a function for each input row that creates the two output entries and adds them to dataset1.

All the best,

Curran

Datavis.tech