Converting data from a collection of objects within an object to an array of objects within an array

Question

Converting data from a collection of objects within an object to an array of objects within an array

I am facing a data manipulation challenge and seeking a solution.

I have attempted various mapping methods, but none have been successful.

Below is the input dataset:

   data_input = {
    2000: [{
            _id: 0,
            name: "Jeff",
            value: 130,
            year: 2000
        },
        {
            _id: 1,
            name: "Bill",
            value: 30,
            year: 2000
        }
    ],
    2001: [{
            _id: 0,
            name: "Jeff",
            value: 20,
            year: 2001
        },
        {
            _id: 1,
            name: "Bill",
            value: 100,
            year: 2001
        }
    ]
 }

The desired outcome should be as follows:

   data_output = [{
        year: 2000,
        year_data: [{
                _id: 0,
                name: "Jeff",
                value: 130
            },
            {
                _id: 1,
                name: "Bill",
                value: 30
            }
        ]
    },
    {
        year: 2001,
        year_data: [{
                _id: 0,
                name: "Jeff",
                value: 20
            },
            {
                _id: 1,
                name: "Bill",
                value: 100
            }
        ]
    }
 ]

javascript arrays json

Answer 1

Answer №1

You might consider using Object.entries along with map

The concept here is :-

Utilize object.entries to extract key value pairs from an object and map through them to transform the data
Key represents the year property in the desired structure, while value corresponds to year_data

let data = {2000: [{ _id: 0, name: "Jeff", value:130, year: 2000 }, { _id: 1, name: "Bill", value:30, year: 2000 } ] , 2001 : [{ _id: 0, name: "Jeff", value: 20, year: 2001 }, {_id:1, name: "Bill", value: 100, year: 2001 } ]}

let final = Object.entries(data).map(([year, year_data]) => ({ year, year_data: year_data.map(({year,...rest})=>rest)}))

console.log(final)

Answer 2

You might consider using Object.entries along with map

The concept here is :-

Utilize object.entries to extract key value pairs from an object and map through them to transform the data
Key represents the year property in the desired structure, while value corresponds to year_data

let data = {2000: [{ _id: 0, name: "Jeff", value:130, year: 2000 }, { _id: 1, name: "Bill", value:30, year: 2000 } ] , 2001 : [{ _id: 0, name: "Jeff", value: 20, year: 2001 }, {_id:1, name: "Bill", value: 100, year: 2001 } ]}

let final = Object.entries(data).map(([year, year_data]) => ({ year, year_data: year_data.map(({year,...rest})=>rest)}))

console.log(final)

Answer 3

Answer №2

To extract the year from the rest of the object, you can utilize mapping and destructuring of values.

var data_input = { 2000: [{ _id: 0, name: "Jeff", value: 130, year: 2000 }, { _id: 1, name: "Bill", value: 30, year: 2000 }], 2001: [{ _id: 0, name: "Jeff", value: 20, year: 2001 }, { _id: 1, name: "Bill", value: 100, year: 2001 }] },
    result = Object
        .values(data_input)
        .map(a => ({ year: a[0].year, year_data: a.map(({ year, ...rest }) => rest) }));

console.log(result);

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

Answer 4

To extract the year from the rest of the object, you can utilize mapping and destructuring of values.

var data_input = { 2000: [{ _id: 0, name: "Jeff", value: 130, year: 2000 }, { _id: 1, name: "Bill", value: 30, year: 2000 }], 2001: [{ _id: 0, name: "Jeff", value: 20, year: 2001 }, { _id: 1, name: "Bill", value: 100, year: 2001 }] },
    result = Object
        .values(data_input)
        .map(a => ({ year: a[0].year, year_data: a.map(({ year, ...rest }) => rest) }));

console.log(result);

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

Answer 5

Answer №3

give this a shot

 data = {
    2000: [{
            _id: 0,
            name: "John",
            value: 150,
            year: 2000
        },
        {
            _id: 1,
            name: "Sarah",
            value: 50,
            year: 2000
        }
    ],
    2001: [{
            _id: 0,
            name: "John",
            value: 50,
            year: 2001
        },
        {
            _id: 1,
            name: "Sarah",
            value: 80,
            year: 2001
        }
    ]
 }

var newData = Object.keys(data).map(key => {
  let yearValues = data[key].map(item => {
    delete item.year
    return item
  });
  return {
    year: key,
    values: yearValues
  }
});

console.log(newData);

Answer 6

give this a shot

 data = {
    2000: [{
            _id: 0,
            name: "John",
            value: 150,
            year: 2000
        },
        {
            _id: 1,
            name: "Sarah",
            value: 50,
            year: 2000
        }
    ],
    2001: [{
            _id: 0,
            name: "John",
            value: 50,
            year: 2001
        },
        {
            _id: 1,
            name: "Sarah",
            value: 80,
            year: 2001
        }
    ]
 }

var newData = Object.keys(data).map(key => {
  let yearValues = data[key].map(item => {
    delete item.year
    return item
  });
  return {
    year: key,
    values: yearValues
  }
});

console.log(newData);

Converting data from a collection of objects within an object to an array of objects within an array

Answer №1

Answer №2

Answer №3

Similar questions

Unnecessary socket.io connection in a React component

How can I efficiently remove elements from the end of an array in Vue.js?

Guidance on handling JSON data containing both nested and non-nested structures

Tips for extracting information from a URL and processing it on a webpage

Problem encountered with the JavaScript for loop failing to execute consistently on each iteration

The page refreshes when the anchor element is clicked

Reading data from Firestore in Next.js

Learn the process of extracting various data from a PHP source and saving it in select options through AJAX

Is there a way to automatically fill in a text field when an option is chosen from a dropdown menu populated with a list of objects?

I would like to add a border at the bottom of each item in a ul list

Error message: UnhandledPromiseRejectionWarning in (Node.js, Express.js, MongoDB) - TypeError occurs when trying to access an undefined 'username' property

Guide to integrating the Braintree API with Node.js

Adding an object to an array using the Array.push() method deposits an array

What causes Python to unpredictably eliminate numbers from an array?

Getting a "SyntaxError: Unexpected end of input" error while using jQuery ajax with valid JSON

Execute a JavaScript function when an HTML list element is clicked

Guide on linking JSON information to a personalized class

What is the best way to decrease the border width of a chartjs doughnut chart?

Looking to crop a canvas without changing its dimensions using jQuery

Reactive form allows you to easily format dates