How to create an array of nested objects from a csv file in D3.js?

Question

This question uses the same data as one of my previous questions, but the question is different. I have a csv file that looks like this:

name,score,date
Bob,93,2014
Bob,85,2015
Barry,70,2015
...

No two people have the same name, but a person can have multiple entries. How can I create an array within the d3.csv callback function that looks like this?:

[{name: "Bob", values: [
   {score: 93, date: 2014},
   {score: 85, date: 2015}]}
 {name: "Barry", values: [
   {score: 70, date: 2015}]},
...

Normally I would be able to do this with plain javascript, but accessing property values with arrayName[objectIndex].objectPropertyName doesn't work within the d3 callback function.

somename · Accepted Answer · 2015-09-17 22:05:06Z

2

d3.nest() function that will convert your csv data into key value pairs. Look at this plnkr link to view the objects in console. To get minimum maximum data see this updated plnkr.

d3.csv("data.csv", function(error, data) {
    console.log(data);
    var updated = d3.nest().key(function(d) {
        return d.name;
    }).sortKeys(d3.ascending).entries(data);
    console.log(updated);
})

edited Sep 17, 2015 at 22:05

answered Sep 17, 2015 at 20:08

somename

92813 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user2829582 Over a year ago

I used d3.nest() prior to your answer. I was trying to get the max score but was having difficulty accessing the values when using d3.max().

somename Over a year ago

see my updated answer I used min maximum function in d3 to plot the scales.

Collectives™ on Stack Overflow

How to create an array of nested objects from a csv file in D3.js?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related