How to count the occurrences of the values of an array in a array of objects

Question

I have an array of objects like this

[
  {
    entry: 1,
    answer: "[\"aaa\",\"bbb\"]"
  },
  {
    entry: 2,
    answer: "[\"ccc\",\"bbb\"]"
  },
  {
    entry: 3,
    answer: "[\"ccc\",\"bbb\"]"
  }
]

Note that the value in answer is a stringified array. I would like to count how many occourrence of each answer and get back an object like

{
  "aaa": 1,
  "ccc": 2,
  "bbb": 3,
}

what I tried so far:

const countAnswers = (ans) => {
    return ans.reduce(function (obj, v) {
        obj[v.answer] = (obj[v.answer] || 0) + 1;
        return obj;
    }, {});
};

this function counts any occourrence of the stringified answer but I don't understand how to revert the stringify array and count the elements within it.

Anton Podolsky · Accepted Answer · 2023-02-03 14:39:40Z

1

Use JSON.parse().

const countAnswers = (ans) => {
    return ans.reduce(function (obj, v) {
        const answersParsed = JSON.parse(v.answer);
        
        answersParsed.forEach((answer) => {
            obj[answer] = (obj[answer] || 0) + 1;
        });
        
        return obj;
    }, {});
};

const answers = [
  {
    entry: 1,
    answer: "[\"aaa\",\"bbb\"]"
  },
  {
    entry: 2,
    answer: "[\"ccc\",\"bbb\"]"
  },
  {
    entry: 3,
    answer: "[\"ccc\",\"bbb\"]"
  }
];

console.log(countAnswers(answers));

answered Feb 3, 2023 at 14:39

Anton Podolsky

8504 silver badges11 bronze badges

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

Comments

Andrew Parks · Accepted Answer · 2023-02-03 14:38:48Z

1

const data = [{"entry":1,"answer":"[\"aaa\",\"bbb\"]"},{"entry":2,"answer":"[\"ccc\",\"bbb\"]"},{"entry":3,"answer":"[\"ccc\",\"bbb\"]"}]

let r = 
  data.flatMap(i=>JSON.parse(i.answer)).reduce((a,c)=>(a[c]??=0,a[c]++,a),{})

console.log(r)

answered Feb 3, 2023 at 14:38

Andrew Parks

8,1672 gold badges21 silver badges35 bronze badges

Comments

Moritz Ringler · Accepted Answer · 2023-02-03 14:38:49Z

1

This seems to work:

const data = [
    {
      entry: 1,
      answer: "[\"aaa\",\"bbb\"]"
    },
    {
      entry: 2,
      answer: "[\"ccc\",\"bbb\"]"
    },
    {
      entry: 3,
      answer: "[\"ccc\",\"bbb\"]"
    }
  ]
  
  const result = data.reduce( (c,e) => (JSON.parse(e.answer).forEach(a => c[a] = (c[a] ?? 0) + 1), c), {} );
  console.log(result)

  console.log('sorted', Object.fromEntries(Object.entries(result).sort( (e1, e2) => e1[0].localeCompare(e2[0]))))

answered Feb 3, 2023 at 14:38

Moritz Ringler

16.4k10 gold badges29 silver badges45 bronze badges

Collectives™ on Stack Overflow

How to count the occurrences of the values of an array in a array of objects

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related