Combine key value pairs in a JSON object into a list using Javascript

Question

Combine key value pairs in a JSON object into a list using Javascript

In my dataset, I have JSON files containing information spanning from the year 2008 to 2020, along with additional data keys like location and name:

{"2008": 50, "2009": 60, "2010": 70, "2011": 80, etc...}

My goal is to organize these years into a new key and include it in the existing array:

{metric:
    [{"year": 2008, "perc": 50},
     {"year": 2009, "perc": 60},
     {"year": 2010, "perc": 70},
     {"year": 2011, "perc": 80}],
 "2008": 50, 
 "2009": 60,
 "2010": 70, 
 "2011": 80,
 etc...
}

To accomplish this, I believe I need to establish a range between 2008 and 2020. If any keys fall within this range, they should be added to the metrics group and included in the array.

javascript arrays json

Answer 1

Answer №1

If you have an object instead of an array, you can iterate through it using a for-in loop or a for-of loop on Object.entries. Once you have accessed the values, you can convert the year to a number and check if it falls within your specified range. If it does, you can add it to the metric array:

const data = {"2008": 50, "2009": 60, "2010": 70, "2011": 80, "2001": 20, "2002:": 30};
// Loop through the object
for (const [year, perc] of Object.entries(data)) {
    // Convert the year to a number
    const yearValue = +year; // Refer to note below
    if (yearValue >= 2008 && yearValue <= 2020) {
        // Year is in range, access the `metric` array
        const metric = data.metric ?? (data.metric = []);
        // Add the values
        metric.push({year, perc});
    }
}

console.log(data);

(I included some out-of-range years to demonstrate how the range works.)

Utilizing unary + for conversion to a number is just one approach; there are several options available, which I discuss in detail in my answer here.

Answer 2

If you have an object instead of an array, you can iterate through it using a for-in loop or a for-of loop on Object.entries. Once you have accessed the values, you can convert the year to a number and check if it falls within your specified range. If it does, you can add it to the metric array:

const data = {"2008": 50, "2009": 60, "2010": 70, "2011": 80, "2001": 20, "2002:": 30};
// Loop through the object
for (const [year, perc] of Object.entries(data)) {
    // Convert the year to a number
    const yearValue = +year; // Refer to note below
    if (yearValue >= 2008 && yearValue <= 2020) {
        // Year is in range, access the `metric` array
        const metric = data.metric ?? (data.metric = []);
        // Add the values
        metric.push({year, perc});
    }
}

console.log(data);

(I included some out-of-range years to demonstrate how the range works.)

Utilizing unary + for conversion to a number is just one approach; there are several options available, which I discuss in detail in my answer here.

Answer 3

Answer №2

You should iterate through the object and create a fresh one

const transformObject = obj => {
    // Define initial object
    let output = {
        metric: []
    }

    // Loop through the object
    for (const key in obj) {

        // Check if the property exists in the object
        if (Object.hasOwnProperty.call(obj, key)) {

            // Check if the key falls within a certain range and add it to the 'metric' array if not
            if (!(/20(0[8-9]|1[0-9]|20)/gm).test(key)) output.metric.push({
                'year': key,
                'perc': obj[key]
            });
                
            // Add the value to the output object if the key falls between 2008 and 2020
            else output[key] = obj[key]
        }
    }

    // Return the new object
    return output;
}

Answer 4

You should iterate through the object and create a fresh one

const transformObject = obj => {
    // Define initial object
    let output = {
        metric: []
    }

    // Loop through the object
    for (const key in obj) {

        // Check if the property exists in the object
        if (Object.hasOwnProperty.call(obj, key)) {

            // Check if the key falls within a certain range and add it to the 'metric' array if not
            if (!(/20(0[8-9]|1[0-9]|20)/gm).test(key)) output.metric.push({
                'year': key,
                'perc': obj[key]
            });
                
            // Add the value to the output object if the key falls between 2008 and 2020
            else output[key] = obj[key]
        }
    }

    // Return the new object
    return output;
}

Combine key value pairs in a JSON object into a list using Javascript

Answer №1

Answer №2

Similar questions

AJAX request post parameters not recognized in ColdFusion form scope

Show side by side using javascript

What is the best way to retrieve a single value from this JSON array?

Inform the PHP backend that the browser has been closed by the frontend Angular application

Converting a NumPy Array containing characters into a string

Challenges with rendering in Vue.js when setting up a simplistic Trello-style system using Mongoose and MongoDB

Eliminating the page loading 'hiccup' during jQuery processing

Starting service upon startup in Angularjs

Ensure the accuracy and secure storage of information in Laravel using axios

Leverage Express.js route variables for universal access

Looking for assistance with organizing a JSON array

The process of refreshing a TableView using JSON data

Creating a primary index file as part of the package building process in a node environment

Visualizing network graphs using JavaScript

Transform the HTML pattern regex into JavaScript format

The map functionality is failing to render on the three.js object

Discovering the indices within an array that satisfy a specific condition using Python and the numpy library

I am facing a challenge with AngularJS where I am unable to navigate between pages using the

What is the best method for obtaining a spring controller's object using AJAX?

Choosing the Best Data Format for a 2D RPG: XML, YAML, or JSON