Extract distinct data from JSON object

Question

Extract distinct data from JSON object

Here is a JSON object that needs to be parsed:

var data =JSON.parse('[{"Title":"Test 1","State":"Colorado"}, 
                       {"Title":"Test 1","State":"Arizona"},
                       {"Title":"Test 2","State":"Utah"},
                       {"Title":"Test 2","State":"Arizona"},
                       {"Title":"Test 3","State":"Arizona"}]');

The desired output after parsing the data object should be as follows:

resultData = [{"Title":"Test 1", State: ["Colorado", "Arizona"]},
              {"Title":"Test 2", State: ["Utah", "Arizona"]},
              {"Title":"Test 3", State: ["Arizona"]}]

There has been an attempt made with the following code:

var resultData = {},
groupBy = "Title";

for (var i = 0; i < data.length; i++) {
    if (!resultData[data[i][groupBy]])
        resultData[data[groupBy]] = [];
    resultData[data[i][groupBy]].push(data[i]);
};

However, the current output is not as expected:

resultData = [{Test 1: [{State: "Colorado"}, {State: "Arizona"}]},
              {Test 2: [{State: "Utah"}, {State: "Arizona"}]},
              {Test 3: [{State: "Arizona"}]}]

If anyone can provide assistance in achieving the desired output, it would be greatly appreciated.

javascript json parsing object

Answer 1

Answer №1

Your goal can be efficiently achieved using the reduce method:

Step 1 - Parsing Data

var data = JSON.parse('[{"Title":"Test 1","State":"Colorado"}, 
                       {"Title":"Test 1","State":"Arizona"},
                       {"Title":"Test 2","State":"Utah"},
                       {"Title":"Test 2","State":"Arizona"},
                       {"Title":"Test 3","State":"Arizona"}]');

Step 2 - Combining States with Same Title

var titles = data.reduce(function(acc, item){
    var title = item.Title;
    var state = item.State;

    if (!Object.prototype.hasOwnProperty.call(acc, title)){
        acc[title] = [];
    }

    acc[title].push(state);
    return acc;
}, {});

Step 3 - Building Final Array from Combined States

var resultData = Object.keys(titles).map(function(title){
    return {
        Title: title,
        State: titles[title]
    }
});

This code block demonstrates the above steps in JavaScript for achieving the desired outcome.

Answer 2

Your goal can be efficiently achieved using the reduce method:

Step 1 - Parsing Data

var data = JSON.parse('[{"Title":"Test 1","State":"Colorado"}, 
                       {"Title":"Test 1","State":"Arizona"},
                       {"Title":"Test 2","State":"Utah"},
                       {"Title":"Test 2","State":"Arizona"},
                       {"Title":"Test 3","State":"Arizona"}]');

Step 2 - Combining States with Same Title

var titles = data.reduce(function(acc, item){
    var title = item.Title;
    var state = item.State;

    if (!Object.prototype.hasOwnProperty.call(acc, title)){
        acc[title] = [];
    }

    acc[title].push(state);
    return acc;
}, {});

Step 3 - Building Final Array from Combined States

var resultData = Object.keys(titles).map(function(title){
    return {
        Title: title,
        State: titles[title]
    }
});

This code block demonstrates the above steps in JavaScript for achieving the desired outcome.

Answer 3

Answer №2

A potential solution involves utilizing a single loop strategy that incorporates a closure over a hash table for organizing the data into specific groups.

var information = [{ Name: "Test 1", Location: "Colorado" }, { Name: "Test 1", Location: "Arizona" }, { Name: "Test 2", Location: "Utah" }, { Name: "Test 2", Location: "Arizona" }, { Name: "Test 3", Location: "Arizona" }],
    key = 'Name',
    groupedInformation = information.reduce(function (group) {
        return function (result, object) {
            if (!group[object[key]]) {
                group[object[key]] = [];
                result.push({ Name: object.Name, Locations: group[object[key]] });
            }
            group[object[key]].push(object.Location);
            return result;
        };
    }(Object.create(null)), []);

console.log(groupedInformation);

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

Answer 4

A potential solution involves utilizing a single loop strategy that incorporates a closure over a hash table for organizing the data into specific groups.

var information = [{ Name: "Test 1", Location: "Colorado" }, { Name: "Test 1", Location: "Arizona" }, { Name: "Test 2", Location: "Utah" }, { Name: "Test 2", Location: "Arizona" }, { Name: "Test 3", Location: "Arizona" }],
    key = 'Name',
    groupedInformation = information.reduce(function (group) {
        return function (result, object) {
            if (!group[object[key]]) {
                group[object[key]] = [];
                result.push({ Name: object.Name, Locations: group[object[key]] });
            }
            group[object[key]].push(object.Location);
            return result;
        };
    }(Object.create(null)), []);

console.log(groupedInformation);

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

Extract distinct data from JSON object

Answer №1

Step 1 - Parsing Data

Step 2 - Combining States with Same Title

Step 3 - Building Final Array from Combined States

Answer №2

Similar questions

Trigger an event in Angular using TypeScript when a key is pressed

My attempt at automatically submitting the form using jQuery to the ajax function was unsuccessful, and no error messages were displayed

Having trouble installing the json gem on Ubuntu using Ruby 2.2.3

What is the method for incorporating input value into a li list item?

Retrieve an object using a variable

Failure to execute Ajax request when searching for a query

Creating dynamic child components in Vue.js version 2

Organize table information using rowspan functionality

Are you utilizing content loaded through jquery load in your work?

Create a KML layer on a Google Map by uploading from a text input field

Navigating through JSON data retrieved from a MySQL database or within Xcode

Tips for including HTML tags within a string using node.js, express, and ejs

"How can you enhance the performance of JavaScript and CSS in a Chrome Extension without using exclude_matches/globs or excluding domains

What are the steps for showcasing a personalized HTML tag on a web page

Getting your JS project off the ground with NPM!

Empty array is logged by the server after sending a JavaScript variable through post request

Search a location database using the user's current coordinates

Executing a setInterval function in NodeJs without prolonging the process's lifespan

Credit for the Position swipejs

Tips on manually refreshing AngularJS view using ControllerAs syntax?