Determining the number of occurrences of a particular variable in a JSON-indexed object using JavaScript

Question

Determining the number of occurrences of a particular variable in a JSON-indexed object using JavaScript

Seeking some guidance as I navigate through unlabelled data for the first time. The challenge lies in determining the total count of department_count from the JSON object below.

No matter how many solutions I try or logic I implement, I keep running into roadblocks and failing to retrieve the desired output.

With a total of 3 departments, the expected result should be 3. An alternative approach is to calculate the sum of department_count in each iteration.

THE DESIRED RESULT IS 3

var myObject =[
{
  "school_id":"1",
  "school_name":"XYZ",
  "department_count":1,
  "department":[
     {
        "id":"stu1",
        "name":"sammy",
        "height":88,
        "weight":2,
        "bmi":1,
        "type":"Healthy"
     }
  ]
},
{
  "school_id":"2",
  "school_name":"ABC",
  "department_count":2,
  "department":[
     {
        "id":"stu2",
        "name":"Sam",
        "height":5,
        "weight":2,
        "bmi":1,
        "type":"Skinny"
     },
     {
        "id":"stu3",
        "name":"REd",
        "height":0,
        "weight":0,
        "bmi":0,
        "type":""
     }
   ]
}
]

javascript arrays

Answer 1

Answer №1

Perhaps this solution could be of use to you.

var myObject =[
   {
      "school_id":"1",
      "school_name":"XYZ",
      "department_count":1,
      "department":[
         {
            "id":"stu1",
            "name":"sammy",
            "height":88,
            "weight":2,
            "bmi":1,
            "type":"Healthy"
         }
      ]
   },
   {
      "school_id":"2",
      "school_name":"ABC",
      "department_count":2,
      "department":[
         {
            "id":"stu2",
            "name":"Sam",
            "height":5,
            "weight":2,
            "bmi":1,
            "type":"Skinny"
         },
         {
            "id":"stu3",
            "name":"REd",
            "height":0,
            "weight":0,
            "bmi":0,
            "type":""
         }
      ]
   }
]

let total = 0
for (let i = 0; i < myObject.length; i++) { 
  total += myObject[i].department_count
}

console.log(total);

Answer 2

Perhaps this solution could be of use to you.

var myObject =[
   {
      "school_id":"1",
      "school_name":"XYZ",
      "department_count":1,
      "department":[
         {
            "id":"stu1",
            "name":"sammy",
            "height":88,
            "weight":2,
            "bmi":1,
            "type":"Healthy"
         }
      ]
   },
   {
      "school_id":"2",
      "school_name":"ABC",
      "department_count":2,
      "department":[
         {
            "id":"stu2",
            "name":"Sam",
            "height":5,
            "weight":2,
            "bmi":1,
            "type":"Skinny"
         },
         {
            "id":"stu3",
            "name":"REd",
            "height":0,
            "weight":0,
            "bmi":0,
            "type":""
         }
      ]
   }
]

let total = 0
for (let i = 0; i < myObject.length; i++) { 
  total += myObject[i].department_count
}

console.log(total);

Answer 3

Answer №2

To achieve this, all you need is a handy sumBy function. I also suggest checking out the following resource: 30 seconds of code. You'll definitely gain more insights from it.

const sumBy = (arr, fn) =>
  arr
    .map(typeof fn === 'function' ? fn : val => val[fn])
    .reduce((acc, val) => acc + val, 0);

var myObject =[
{
  "school_id":"1",
  "school_name":"XYZ",
  "department_count":1,
  "department":[
     {
        "id":"stu1",
        "name":"sammy",
        "height":88,
        "weight":2,
        "bmi":1,
        "type":"Healthy"
     }
  ]
},
{
  "school_id":"2",
  "school_name":"ABC",
  "department_count":2,
  "department":[
     {
        "id":"stu2",
        "name":"Sam",
        "height":5,
        "weight":2,
        "bmi":1,
        "type":"Skinny"
     },
     {
        "id":"stu3",
        "name":"REd",
        "height":0,
        "weight":0,
        "bmi":0,
        "type":""
     }
   ]
}
];

var results = sumBy(myObject, x => x.department_count);
console.log(results);

Answer 4

To achieve this, all you need is a handy sumBy function. I also suggest checking out the following resource: 30 seconds of code. You'll definitely gain more insights from it.

const sumBy = (arr, fn) =>
  arr
    .map(typeof fn === 'function' ? fn : val => val[fn])
    .reduce((acc, val) => acc + val, 0);

var myObject =[
{
  "school_id":"1",
  "school_name":"XYZ",
  "department_count":1,
  "department":[
     {
        "id":"stu1",
        "name":"sammy",
        "height":88,
        "weight":2,
        "bmi":1,
        "type":"Healthy"
     }
  ]
},
{
  "school_id":"2",
  "school_name":"ABC",
  "department_count":2,
  "department":[
     {
        "id":"stu2",
        "name":"Sam",
        "height":5,
        "weight":2,
        "bmi":1,
        "type":"Skinny"
     },
     {
        "id":"stu3",
        "name":"REd",
        "height":0,
        "weight":0,
        "bmi":0,
        "type":""
     }
   ]
}
];

var results = sumBy(myObject, x => x.department_count);
console.log(results);

Answer 5

Answer №3

When the department_count value has been established, you can simply retrieve the total number of objects in the array as totalDepartments without needing to iterate through it

let totalDepartments = myObject.length

Answer 6

When the department_count value has been established, you can simply retrieve the total number of objects in the array as totalDepartments without needing to iterate through it

let totalDepartments = myObject.length

Answer 7

Answer №4

A unique counter with duplicate check

const schoolsData =[
{
  "school_id":"1",
  "school_name":"XYZ",
  "department_count":1,
  "department":[
     {
        "id":"stu1",
        "name":"sammy",
        "height":88,
        "weight":2,
        "bmi":1,
        "type":"Healthy"
     }
  ]
},
{
  "school_id":"2",
  "school_name":"ABC",
  "department_count":2,
  "department":[
     {
        "id":"stu2",
        "name":"Sam",
        "height":5,
        "weight":2,
        "bmi":1,
        "type":"Skinny"
     },
     {
        "id":"stu3",
        "name":"REd",
        "height":0,
        "weight":0,
        "bmi":0,
        "type":""
     }
   ]
}
]
var uniqueSchoolNames=[]
var count=0;
schoolsData.forEach(school=>{
if(!uniqueSchoolNames.includes(school.school_name))
{ uniqueSchoolNames.push(school.school_name);count++;
}})
console.log(count);

Answer 8

A unique counter with duplicate check

const schoolsData =[
{
  "school_id":"1",
  "school_name":"XYZ",
  "department_count":1,
  "department":[
     {
        "id":"stu1",
        "name":"sammy",
        "height":88,
        "weight":2,
        "bmi":1,
        "type":"Healthy"
     }
  ]
},
{
  "school_id":"2",
  "school_name":"ABC",
  "department_count":2,
  "department":[
     {
        "id":"stu2",
        "name":"Sam",
        "height":5,
        "weight":2,
        "bmi":1,
        "type":"Skinny"
     },
     {
        "id":"stu3",
        "name":"REd",
        "height":0,
        "weight":0,
        "bmi":0,
        "type":""
     }
   ]
}
]
var uniqueSchoolNames=[]
var count=0;
schoolsData.forEach(school=>{
if(!uniqueSchoolNames.includes(school.school_name))
{ uniqueSchoolNames.push(school.school_name);count++;
}})
console.log(count);

Answer 9

Answer №5

To accomplish this task, you can utilize the Array.prototype.reduce() method:

const students = [{school_id: '1', school_name: 'XYZ', department_count: 1, department: [{id: 'stu1', name: 'Sammy', height: 88, weight: 2, bmi: 1, type: 'Healthy'},]}, {school_id: '2', school_name: 'ABC', department_count: 2, department: [{id: 'stu2', name: 'Sam', height: 5, weight: 2, bmi: 1, type: 'Skinny'}, {id: 'stu3', name: 'Red', height: 0, weight: 0, bmi: 0, type: ''}]}];

const totalDepartments = students.reduce((acc, { department_count }) => acc + department_count, 0);

console.log(totalDepartments);

Answer 10

To accomplish this task, you can utilize the Array.prototype.reduce() method:

const students = [{school_id: '1', school_name: 'XYZ', department_count: 1, department: [{id: 'stu1', name: 'Sammy', height: 88, weight: 2, bmi: 1, type: 'Healthy'},]}, {school_id: '2', school_name: 'ABC', department_count: 2, department: [{id: 'stu2', name: 'Sam', height: 5, weight: 2, bmi: 1, type: 'Skinny'}, {id: 'stu3', name: 'Red', height: 0, weight: 0, bmi: 0, type: ''}]}];

const totalDepartments = students.reduce((acc, { department_count }) => acc + department_count, 0);

console.log(totalDepartments);

Answer 11

Answer №6

There are numerous techniques available, but what you really need is a method that involves looping.

One approach is to utilize the Array.reduce function.

const myObject = [{"school_id":"1","school_name":"XYZ","department_count":1,"department":[{"id":"stu1","name":"sammy","height":88,"weight":2,"bmi":1,"type":"Healthy"}]},{"school_id":"2","school_name":"ABC","department_count":2,"department":[{"id":"stu2","name":"Sam","height":5,"weight":2,"bmi":1,"type":"Skinny"},{"id":"stu3","name":"REd","height":0,"weight":0,"bmi":0,"type":""}]}];
const sum = myObject.reduce((acc, curr) => {
  acc += curr.department_count;
  return acc;
}, 0);
console.log(sum);

Edit: You could also use Object destructuring to improve readability of the code.

const myObject = [{"school_id":"1","school_name":"XYZ","department_count":1,"department":[{"id":"stu1","name":"sammy","height":88,"weight":2,"bmi":1,"type":"Healthy"}]},{"school_id":"2","school_name":"ABC","department_count":2,"department":[{"id":"stu2","name":"Sam","height":5,"weight":2,"bmi":1,"type":"Skinny"},{"id":"stu3","name":"REd","height":0,"weight":0,"bmi":0,"type":""}]}];
const sum = myObject.reduce((acc, {department_count}) => acc + department_count, 0);
console.log(sum);

Answer 12

There are numerous techniques available, but what you really need is a method that involves looping.

One approach is to utilize the Array.reduce function.

const myObject = [{"school_id":"1","school_name":"XYZ","department_count":1,"department":[{"id":"stu1","name":"sammy","height":88,"weight":2,"bmi":1,"type":"Healthy"}]},{"school_id":"2","school_name":"ABC","department_count":2,"department":[{"id":"stu2","name":"Sam","height":5,"weight":2,"bmi":1,"type":"Skinny"},{"id":"stu3","name":"REd","height":0,"weight":0,"bmi":0,"type":""}]}];
const sum = myObject.reduce((acc, curr) => {
  acc += curr.department_count;
  return acc;
}, 0);
console.log(sum);

Edit: You could also use Object destructuring to improve readability of the code.

const myObject = [{"school_id":"1","school_name":"XYZ","department_count":1,"department":[{"id":"stu1","name":"sammy","height":88,"weight":2,"bmi":1,"type":"Healthy"}]},{"school_id":"2","school_name":"ABC","department_count":2,"department":[{"id":"stu2","name":"Sam","height":5,"weight":2,"bmi":1,"type":"Skinny"},{"id":"stu3","name":"REd","height":0,"weight":0,"bmi":0,"type":""}]}];
const sum = myObject.reduce((acc, {department_count}) => acc + department_count, 0);
console.log(sum);

Determining the number of occurrences of a particular variable in a JSON-indexed object using JavaScript

Answer №1

Answer №2

Answer №3

Answer №4

Answer №5

Answer №6

Similar questions

"Downloading an image from an encoded base64 canvas triggers an error due to exceeding the maxUrlLength

Slider for jQuery or Ajax framework

Performing correlation calculations using complex for loops in MATLAB

"Attempt to create angular fork results in an unsuccessful build

Obtaining a file from the Firebase database

Error encountered when attempting to retrieve posts using Axios: Unexpected symbol detected, expected a comma (25:4)

Implementing a redirect and setting a background image dynamically in ASP.NET using code-behind

Strategies for sending data to child components in Vue

Exploitable Weakness Found in NestJS Version 8.4.5

What is the top choice for creating a shallow copy of an array

Mastering the Art of Binding Option Data from API Responses in Vue.js

Guide to streaming audio files using vue.js

Using the strtok function to separate a set of strings into individual characters in C

In a set of numbers, one specific number is repeated n/2 times while the remaining n/2 numbers are all different from each other

Printing a Page Using Angular 5

Save information in a session using html and javascript

Excessive image display | HTML and CSS synergize

Concentrate on the HTML element once it becomes active

Stop Carousel when hovering over individual items (Owl Beta 2)

Issues with rendering Google Maps on google-maps-react persists, stuck endlessly in loading phase