Lodash groupby nested array

Question

I`m trying to use the groupBy function of Lodash to reshape a nested array.

I get the book store data, where I retrieve the list of books with their title and the list of their authors.

 [
     {
        "title": "",
        "author": [
          {
            "given": "",
            "family": "",
            "affiliation": []
          },
          {
            "given": "",
            "family": "",
            "affiliation": []
          }
         ]
      },{
        "title": "",
        "author": [
          {
            "given": "",
            "family": "",
            "affiliation": []
          },
          {
            "given": "",
            "family": "",
            "affiliation": []
          }
         ]
      }
    ]

Full example with input and desired output

Then I want to group those books by authors. A book belongs to Many authors and we look for reversing the relation (Later I also which to group them by affiliation and by author, but lets stay simple for the beginning)

result = _.groupBy(result, function(item) {
   return _.map(item.author,'given')
});

My issues is that groupBy doesn`t accept an array of categories to group the item in. I need to find an alternative solution.

xNok · Accepted Answer · 2017-08-03 19:52:15Z

1

Answer Provided to me by the Datalib contributer

standard JavaScript array functions

var byAuthor = books.reduce(function(authors, book) {
  book.author.forEach(function(author) {
    var name = author.family;
    var booksByAuthor = authors[name] || (authors[name] = []);
    booksByAuthor.push(book);
  });
  return authors;
}, {});

Alternative solution

Using json-groupby library

const groupBy = require('json-groupby');

// create a temporary array `authors`
  byBook.forEach(function(item) {
      item.authors = item.author.map(function(x) {
         return x.family;
      })
  });

// groupby authors
  byAuthor= groupBy(byBook, ['authors']);

// delete the temporary array
  Object.keys(byAuthor).forEach(function (key){
    byAuthor[key].forEach(function (item){
      delete item.authors
    });
  });

answered Aug 3, 2017 at 19:52

xNok

1082 silver badges7 bronze badges

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

Comments

Piyush Gupta · Accepted Answer · 2017-08-02 19:19:21Z

0

This lib enables multiple grouping parameters build on top of d3.js and is blazing fast. Maybe you can benefit from it

https://github.com/vega/datalib

answered Aug 2, 2017 at 19:19

Piyush Gupta

714 bronze badges

2 Comments

xNok Over a year ago

Very good suggestion I like the Pandas like syntax. It seems promising to me in terms of manipulating json files as a Dataset.

xNok Over a year ago

Unfortunately datalib is concerned only by "flat" tabular data. So it can`t solver the problem for nested arrays. see discussion on GitHub

Collectives™ on Stack Overflow

Lodash groupby nested array

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related