I have a csv with the following data:

world,country,state

World,US,CA

World,US,NJ

World,INDIA,OR

World,INDIA,AP

World,INDIA,TN

I need to convert in to a tree hierarchy as shown below:

{

    "name": "World",
    "children": [
      { "name": "US",
          "children": [
           { "name": "CA" },
           { "name": "NJ" }
         ]
      },
      { "name": "INDIA",
          "children": [
          { "name": "OR" },
          { "name": "TN" },
          { "name": "AP" }
         ]
      }
 ]
};

Then this tree will be used for tree visualization. Can any one help on this?

I have a csv with the following data:

world,country,state

World,US,CA

World,US,NJ

World,INDIA,OR

World,INDIA,AP

World,INDIA,TN

I need to convert in to a tree hierarchy as shown below:

{

    "name": "World",
    "children": [
      { "name": "US",
          "children": [
           { "name": "CA" },
           { "name": "NJ" }
         ]
      },
      { "name": "INDIA",
          "children": [
          { "name": "OR" },
          { "name": "TN" },
          { "name": "AP" }
         ]
      }
 ]
};

Then this tree will be used for tree visualization. Can any one help on this?

• javascript
• d3.js

1 Answer 1

d3.nest is your friend!

Look at the Nest documentation for D3: https://github./d3/d3-collection/blob/master/README.md#nests

And here are some example I wrote when I was learning to use nest: https://gist.github./3176159

This question also helps: D3: use nest function to turn flat data with parent key into a hierarchy