Having trouble properly iterating through a Javascript JSON pull?

Question

Having trouble properly iterating through a Javascript JSON pull?

Here is the code that I am working with:

var input=require('./task.json');
const _ = require(`underscore`);
var dps = [];
for(var element in input) {
    for (var i=0;i>dps.length;i++){
        if(dps[i].Technician===input[element].Technician){
            console.log("name already exists");
            dps[i].count=dps[i].Count+1;

        }

    }
    dps.push({Technician: input[element].Technician, Count:0});
}


  console.log(dps);

This is how my task.json file is structured:

{{
        "TaskID": 35708,
        "TaskDate": "2011-06-20T00:00:00",
        "Technician": "UCH - Billy Metcalf"
    },
{
        "TaskID": 35708,
        "TaskDate": "2011-06-19T00:00:00",
        "Technician": "Edward F. Dawson"
    }
}

When I execute my file using node on data.js, I get a result like this:

[{Technician:'UCH - Billy Metcalf',Count:0},
{Technician:'Edward F. Dawson',Count:0}]

The main objective is to make sure that instead of always setting the count to zero, the program should go through the json file and if it encounters a duplicate entry in the new variable dps, it should increment the count. The new array dps should be unique without any repeating names. For instance, if there are 5 instances of "Edward F. Dawson", then

{Technician:'Edward F. Dawson',Count:5}

javascript json

Answer 1

Answer №1

Give this a try. By going through the code step by step, it should become clear.

let data = require('./task.json');
const _ = require(`underscore`);
let technicians = [];
let foundMatch = 0;

for (let key in data) {
    foundMatch = 0;
    
    for (let i = 0; i < technicians.length; i++) {
        if (technicians[i].Technician === data[key].Technician) {
            console.log("Technician already exists");
            technicians[i].count = technicians[i].Count + 1;
            foundMatch = 1;
        }
        
    }

    if (foundMatch === 0) { // only if we didn't find a match!
        technicians.push({ Technician: data[key].Technician, Count: 1 });
    }
}

console.log(technicians);

Answer 2

Give this a try. By going through the code step by step, it should become clear.

let data = require('./task.json');
const _ = require(`underscore`);
let technicians = [];
let foundMatch = 0;

for (let key in data) {
    foundMatch = 0;
    
    for (let i = 0; i < technicians.length; i++) {
        if (technicians[i].Technician === data[key].Technician) {
            console.log("Technician already exists");
            technicians[i].count = technicians[i].Count + 1;
            foundMatch = 1;
        }
        
    }

    if (foundMatch === 0) { // only if we didn't find a match!
        technicians.push({ Technician: data[key].Technician, Count: 1 });
    }
}

console.log(technicians);

Answer 3

Answer №2

Your task.json file contains invalid JSON syntax. To represent an array of objects, use square brackets [] instead of curly braces {}.

Once you format your JSON data into an array, you can execute the following code:

var input = require('./task.json');
const _ = require(`underscore`);
var dps = [];
input.forEach(function (element) {
    var found = dps.some(function (elem) {
      if (elem.Technician === element.Technician) {
          elem.Count = elem.Count + 1;
          return true;
      }
    });
    if (!found) {
      dps.push({Technician: element.Technician, Count: 1});
    }
});

console.log(dps);

If you prefer a more functional approach, you can also utilize the .reduce() method:

var dps = input.reduce(function (arr, currElem) {
    var found = arr.some(function (elem) {
      if (elem.Technician === currElem.Technician) {
          elem.Count = elem.Count + 1;
          return true;
      }
    });
    if (!found) {
      arr.push({Technician: currElem.Technician, Count: 1});
    }
    return arr;
}, []);

console.log(dps);

See the code in action below:

var input = [{
  "TaskID": 35708,
  "TaskDate": "2011-06-20T00:00:00",
  "Technician": "UCH - Billy Metcalf"
}, {
  "TaskID": 35708,
  "TaskDate": "2011-06-19T00:00:00",
  "Technician": "Edward F. Dawson"
}, {
  "TaskID": 35708,
  "TaskDate": "2011-06-19T00:00:00",
  "Technician": "Edward F. Dawson"
}, {
  "TaskID": 35708,
  "TaskDate": "2011-06-19T00:00:00",
  "Technician": "Edward F. Dawson"
}, ];
var dps = input.reduce(function (arr, currElem) {
    var found = arr.some(function (elem) {
      if (elem.Technician === currElem.Technician) {
          elem.Count = elem.Count + 1;
          return true;
      }
    });
    if (!found) {
      arr.push({Technician: currElem.Technician, Count: 1});
    }
    return arr;
}, []);

console.log(dps);

Answer 4

Your task.json file contains invalid JSON syntax. To represent an array of objects, use square brackets [] instead of curly braces {}.

Once you format your JSON data into an array, you can execute the following code:

var input = require('./task.json');
const _ = require(`underscore`);
var dps = [];
input.forEach(function (element) {
    var found = dps.some(function (elem) {
      if (elem.Technician === element.Technician) {
          elem.Count = elem.Count + 1;
          return true;
      }
    });
    if (!found) {
      dps.push({Technician: element.Technician, Count: 1});
    }
});

console.log(dps);

If you prefer a more functional approach, you can also utilize the .reduce() method:

var dps = input.reduce(function (arr, currElem) {
    var found = arr.some(function (elem) {
      if (elem.Technician === currElem.Technician) {
          elem.Count = elem.Count + 1;
          return true;
      }
    });
    if (!found) {
      arr.push({Technician: currElem.Technician, Count: 1});
    }
    return arr;
}, []);

console.log(dps);

See the code in action below:

var input = [{
  "TaskID": 35708,
  "TaskDate": "2011-06-20T00:00:00",
  "Technician": "UCH - Billy Metcalf"
}, {
  "TaskID": 35708,
  "TaskDate": "2011-06-19T00:00:00",
  "Technician": "Edward F. Dawson"
}, {
  "TaskID": 35708,
  "TaskDate": "2011-06-19T00:00:00",
  "Technician": "Edward F. Dawson"
}, {
  "TaskID": 35708,
  "TaskDate": "2011-06-19T00:00:00",
  "Technician": "Edward F. Dawson"
}, ];
var dps = input.reduce(function (arr, currElem) {
    var found = arr.some(function (elem) {
      if (elem.Technician === currElem.Technician) {
          elem.Count = elem.Count + 1;
          return true;
      }
    });
    if (!found) {
      arr.push({Technician: currElem.Technician, Count: 1});
    }
    return arr;
}, []);

console.log(dps);

Having trouble properly iterating through a Javascript JSON pull?

Answer №1

Answer №2

See the code in action below:

Similar questions

Displaying a list of text elements in a React component

Increasing the value of an external variable in MySQL Query through NodeJS

What is the process for constructing a regular expression (regex) in JavaScript to validate an id?

Using Angular 4's ngModel can result in the transformation of data type from 'number' to 'string'

Updating NPM packages versions is currently restricted

Having trouble with Semantic UI Modal onShow / onVisible functionality?

Activate the jQuery click event by specifying the URL

Issue with undefined object in ExpressJS PUT method

Tips on choosing filters and leveraging the chosen value for searching in a Vue application

Generate a visually dynamic representation of a live website page

Is there a way to navigate by scrolling, moving a centrally-positioned SVG along a path while also resizing the SVG?

What steps can be taken to address an undefined error before the execution of useEffect?

Spinning text within a circular rotation in CSS

When using JSX, it's important to wrap adjacent elements within an enclosing tag to avoid errors. Make sure to properly wrap the JSX tags to

How come when I click on the edit button, the selected data's model doesn't appear in the dropdown menu as I would like it to?

Error validator failed for Mongo Db: Masekhta validation failed with error for _id field, expecting `_id`

Testing the Router.push function using Jest and ReactHere is a guide on how

The $geoNear operator must be the initial stage in a pipeline to be valid

Draggable vue includes a Textarea HTML element that allows users to easily

What is the best way to restrict the size of a table that is filled with data from a database?