How can I create a hierarchy structure for a array/object data in nodejs?

Question

I have the data in the below format:

[{ Country: 'USA', State: 'CA', City: 'LA', District: 'LA-1',Town: 'LA-1,LA-1a,LA_AZ_A',Area: 'Area 51'},
     { Country: 'USA', State: 'CA', City: 'LA', District: 'LA-2' },
     { Country: 'USA', State: 'CA', City: 'LA', District: 'LA-3' },
     { Country: 'USA', State: 'CA', City: 'LA', District: 'LA-4' },
     { Country: 'USA', State: 'CA', City: 'LA', District: 'LA-5' },
     { Country: 'USA', State: 'CA', City: 'SJ', District: 'SJ-1' },
     { Country: 'USA', State: 'CA', City: 'SJ', District: 'SJ-2' },
     { Country: 'USA', State: 'CA', City: 'SJ', District: 'SJ-3' },
     { Country: 'USA', State: 'CA', City: 'SJ', District: 'SJ-4' } ]

The last two columns i.e Town and Area are optional.

Based, on this data, how can I create a hierarchy? The output expected is like this (I have created this in excel just to show the hierarchy that I need but as array/object)

In conclusion, how can I create a hierarchical data structure?

Any help is appreciated. Thank you.

Please learn the difference between JSON and the Object Literal Notation. — str
– str, Commented Dec 10, 2020 at 8:19

Rami Jarrar · Accepted Answer · 2020-12-10 08:31:27Z

3

Using lodash to build the hierarchy

let groupBy = (data, attrs) => {
    if (!attrs.length) return data
    const grouped = _.groupBy(data, attrs[0])

    // handles optional attributes
    if (grouped['undefined']) {
        return grouped['undefined']
    }

    return _.mapValues(grouped, 
        values => groupBy(values, attrs.slice(1)))
}

And you can call it like this

groupBy(data, ['Country', 'State', 'City', 'District', 'Town'])

answered Dec 10, 2020 at 8:31

Rami Jarrar

4,6537 gold badges39 silver badges54 bronze badges

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

1 Comment

the_new_guy Over a year ago

Thanks. Its working but the output I'm getting is repeating based on what I pass in the attributes like Country,State,CIty,District and town.

mitsos1os · Accepted Answer · 2020-12-10 09:30:30Z

1

If you want a hierarchical object you could also try this with plain JS:

const group = (data, fields) => {
  return data.reduce((final, dataEntry) => { // iterate dataset lines
    let tempObj = final;
    fields.forEach((field) => { // iterate fields
      const dataField = dataEntry[field];
      if (dataField == null) return; // empty field in object
      if (!tempObj.hasOwnProperty(dataField)) { // initialize
        tempObj[dataField] = {};
      }
      tempObj = tempObj[dataField];
    });
    return final;
  }, {});
};

const result = group(dataset, ['Country', 'State', 'City', 'District', 'Town', 'Area']);

where dataset is the initial array you provided

answered Dec 10, 2020 at 9:30

mitsos1os

2,3101 gold badge23 silver badges34 bronze badges

Collectives™ on Stack Overflow

How can I create a hierarchy structure for a array/object data in nodejs?

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related