Remove Duplicates from Json file using Javascript

Question

I have a json file like below (test.json). I am unsuccessfully trying to parse the test array and remove duplicates of any "name" below

      {
    "test": [{
            "name": "jeb",
            "occupation": "teacher"
        },

        {
            "name": "jeb",
            "occupation": "writer"
        },
        {
            "name": "bob",
            "occupation": "skydiver"
        }

    ]
}

So far, my code is the following:

var xmlhttp = new XMLHttpRequest();
xmlhttp.onreadystatechange = function() {
    if (this.readyState == 4 && this.status == 200) {
        var myObj = JSON.parse(this.responseText);
        var i;
        var test= myObj.test.length;

        for (i=0; i<=myObj.test.length; i++) {
          var name = myObj.test[i].name;
          var occupation = myObj.test[i].occupation;
          console.log(name + " and " + occupation)

        }
      }
}
xmlhttp.open("GET", "test.json", true);
xmlhttp.send();

and it prints out:

jeb and teacher
jeb and writer
bob and skydiver

I would like the end result to be be:

jeb and teacher, writer
bob and skydiver

Any help is appreciated. Thank you!

CertainPerformance · Accepted Answer · 2018-06-26 06:09:31Z

3

It would probably be best to reduce into an object indexed by name, whose value is an array of occupations, and then once the object is created, you can iterate over it and print the occupations of each name:

const obj = {
  "test": [{
    "name": "jeb",
    "occupation": "teacher"
  },{
    "name": "jeb",
    "occupation": "writer"
  },{
    "name": "bob",
    "occupation": "skydiver"
  }]
};

const namesByOccupation = obj.test.reduce((a, { name, occupation }) => {
  if (!a[name]) a[name] = [];
  a[name].push(occupation);
  return a;
}, {});
Object.entries(namesByOccupation).forEach(([name, occupations]) => {
  console.log(name + ' and ' + occupations.join(', '));
});

answered Jun 26, 2018 at 6:09

CertainPerformance

373k55 gold badges354 silver badges359 bronze badges

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

Collectives™ on Stack Overflow

Remove Duplicates from Json file using Javascript

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