manipulating array of json data

Question

I have a project where I have to take some data from a GoogleSheet document and send it to database. I get the data from googlesheet document, but the problem is how is the data structured.

[
  {
    class: "A",
    name: "Alex",
    age: 13
  },
  {
    class: "A",
    name: "Mary",
    age: 14
  },
  {
    class: "B",
    name: "John",
    age: 13
  },
  {
    class: "B",
    name: "William",
    age: 12
  }
]

The problem is I want my JSON object to look like this

[
  "A": {
    {
      name: "Alex",
      age: 13
    },
    {
      name: "Mary",
      age: 13
    }
  },
  "B": {
    {
      name: "John",
      age: 13
    },
    {
      name: "William",
      age: 13
    }
  }
]

Any idea how can I do that? I want to group my objects over an element, like the class. All the people with the same class value to be in the same group/json.

Have you tried looking at the Array.prototype.reduce function? — fubar
– fubar, Commented Oct 13, 2020 at 12:11
The output you are looking for is not a valid json. It should be array of objects something like {"A":[{"name":"Alex","age":13},{"name":"Mary","age":14}]} — Nithish
– Nithish, Commented Oct 13, 2020 at 12:22

Nithish · Accepted Answer · 2020-10-13 12:35:26Z

1

You can make use of Array.reduce and format it.

let data = [{class:"A",name:"Alex",age:13},{class:"A",name:"Mary",age:14},{class:"B",name:"John",age:13},{class:"B",name:"William",age:12}];

//destructuring and renaming it to `_` as `class` is a pre-defined identifier in javascript
const formatData = (data) => data.reduce((res, {
  class: _,
  ...rest
}) => {
//(res[_] || []) --> If the `class` prop is not already present in the res object, then using empty array
//If already present spreading res[_] and adding the current object to the existing array
  res[_] = [...(res[_] || []), { ...rest }]
  return res;
}, {})

console.log(formatData(data))

.as-console-wrapper {
  max-height: 100% !important;
}

You can have a look at Destructuring Assignment for more info about destructuring and assigning new variable names.

edited Oct 13, 2020 at 12:35

answered Oct 13, 2020 at 12:08

Nithish

6,1273 gold badges13 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

manipulating array of json data

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related