d3: skipping lines when reading in csv file

Question

I'm trying to read in a csv file with D3 and I'm a little stuck. The way my csv file is formatted is that the first line is a merged cell containing a year then the next line will contain the data descriptions (name, age etc).

Currently I have the following:

var resourceList = [{description: "All Yearly Data",
                            name: "yearlyData",
                            path: "data.csv"};

d3.csv(resourceInfo.path, function(error, d) {
    theData.resources[resourceInfo.name].processed = true;
    theData.resources[resourceInfo.name].error = error;
    theData.resources[resourceInfo.name].data = d;
    theData.numProcessed += 1;      
});

This reads the first line in as the data descriptions and then the following lines as actual data. What I want to do is have an multidimensional array which I could go through by year. Is it possible to skip lines while parsing to make sure I can manage that or no?

Thanks!

[This question](http://stackoverflow.com/questions/17090642/d3-ignore-certain-row-in-csv) should help. — Lars Kotthoff, Nov 20 '13 at 09:17
@LarsKotthoff What I don't think I'm getting is inside of the inner function where I do theData.resources[resourceInfo.name].data = d, If outside I create an array and I push d, the array never holds anything upon the completion of the function... — DragonVet, Nov 20 '13 at 17:02
`d3.csv` is asynchronous -- the code hasn't executed when the function returns. — Lars Kotthoff, Nov 20 '13 at 17:41
So how can I access a specific line of the csv file at any point? — DragonVet, Nov 20 '13 at 17:58
Once the data has loaded, you just need to index into the array of lines passed to the callback. — Lars Kotthoff, Nov 20 '13 at 18:06
@LarsKotthoff Could you give an example? Sorry. I'm fairly new at this — DragonVet, Nov 20 '13 at 18:08

score 0 · Answer 1 · answered Nov 20 '13 at 01:30

one way of getting at this would be to use filter:

d3.csv(resourceInfo.path, function(error, d) {
    var newData = d.filter(function(obs) { return INSERT YOUR FILTER CONDITION HERE;}); 
    ...

d3: skipping lines when reading in csv file

1 Answers1