How to group by and merge in java-script object ES5

Question

I have a object like this

{
"User 1":[
{"count":"1","stage":"A","jCount":"10","name":"User 1","stageId":"A1"},
{"count":"8","stage":"B","jCount":"10","name":"User 1","stageId":"B1"},
],

"User 2":[
{"count":"7","stage":"C","jCount":"8","name":"User 2","stageId":"C1"},
{"count":"8","stage":"B","jCount":"8","name":"User 2","stageId":"B1"},
{"count":"9","stage":"A","jCount":"8","name":"User 2","stageId":"A1"},
{"count":"8","stage":"D","jCount":"8","name":"User 2","stageId":"D1"},
],

"User 3":[
{"count":"6","stage":"D","jCount":"6","name":"User 3","stageId":"D1"},
{"count":"8","stage":"B","jCount":"6","name":"User 3","stageId":"B1"},
{"count":"1","stage":"A","jCount":"6","name":"User 3","stageId":"A1"},
],
/* Many more users */
}

I am tring to change my object in this format

[
{
"name":"User 1",
"jCount":10,
"stageIdCountA1":1,
"stageIdCountB1":8,
"stageIdCountC1":0,
"stageIdCountD1":0,
},{
"name":"User 2",
"jCount":8,
"stageIdCountA1":9,
"stageIdCountB1":8,
"stageIdCountC1":7,
"stageIdCountD1":8,
},{
"name":"User 3",
"jCount":6,
"stageIdCountA1":1,
"stageIdCountB1":8,
"stageIdCountC1":0,
"stageIdCountD1":6,
},
/* Many more users */
]

There is max only 4 stages are there A1,B1,C1,D1 and jCount is common in user array of child objects

if there is no stage it should print 0

I tried to do manipulation in angularjs view but its becoming difficult.

CertainPerformance · Accepted Answer · 2018-06-02 01:04:21Z

2

You can use map to map each user object to an item in an array, and reduce inside the map function to turn the array of stages into a single object:

const input={"User 1":[{"count":"1","stage":"A","jCount":"10","name":"User 1","stageId":"A1"},{"count":"8","stage":"B","jCount":"10","name":"User 1","stageId":"B1"},],"User 2":[{"count":"7","stage":"C","jCount":"8","name":"User 2","stageId":"C1"},{"count":"8","stage":"B","jCount":"8","name":"User 2","stageId":"B1"},{"count":"9","stage":"A","jCount":"8","name":"User 2","stageId":"A1"},{"count":"8","stage":"D","jCount":"8","name":"User 2","stageId":"D1"},],"User 3":[{"count":"6","stage":"D","jCount":"6","name":"User 3","stageId":"D1"},{"count":"8","stage":"B","jCount":"6","name":"User 3","stageId":"B1"},{"count":"1","stage":"A","jCount":"6","name":"User 3","stageId":"A1"},],};

const stages = ['A', 'B', 'C', 'D'];
const output = Object.entries(input).map(([name, arr]) => {
  const { jCount } = arr[0];
  const stageCounts = stages.reduce((a, stageName) => {
    const propName = 'stageIdCount' + stageName;
    const foundStage = arr.find(({ stage }) => stageName === stage);
    const count = foundStage ? foundStage.count : 0;
    a[propName] = count;
    return a;
  }, {});
  return { name, jCount, ...stageCounts };
});
console.log(output);

If you can't use spread syntax (which you should - integrate Babel into your build process if at all possible), then replace

return { name, jCount, ...stageCounts };

with

return Object.assign({ name, jCount }, stageCounts);

edited Jun 2, 2018 at 1:04

answered Jun 2, 2018 at 0:54

CertainPerformance

373k55 gold badges354 silver badges359 bronze badges

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

3 Comments

Mr world wide Over a year ago

can you tell in ES2015 pls

Felix Kling Over a year ago

@Mrworldwide: return Object.assign({name, jCount}, stageCounts);.

Keith Over a year ago

@Mrworldwide Save yourself a life of pain,.. set yourself up a toolchain that transpiles.. Having to worry about ES5, ES6, ES2015, etc etc,. Is not something I can stomach..

J. Pichardo · Accepted Answer · 2018-06-02 01:46:17Z

Using ES6 and Object.entries you can do something like:

const obj = {
  'User 1': [
{ count: '1', stage: 'A', jCount: '10', name: 'User 1', stageId: 'A1' },
{ count: '8', stage: 'B', jCount: '10', name: 'User 1', stageId: 'B1' }
  ],

  'User 2': [
{ count: '7', stage: 'C', jCount: '8', name: 'User 2', stageId: 'C1' },
{ count: '8', stage: 'B', jCount: '8', name: 'User 2', stageId: 'B1' },
{ count: '9', stage: 'A', jCount: '8', name: 'User 2', stageId: 'A1' },
{ count: '8', stage: 'D', jCount: '8', name: 'User 2', stageId: 'D1' }
  ],

  'User 3': [
{ count: '6', stage: 'D', jCount: '6', name: 'User 3', stageId: 'D1' },
{ count: '8', stage: 'B', jCount: '6', name: 'User 3', stageId: 'B1' },
{ count: '1', stage: 'A', jCount: '6', name: 'User 3', stageId: 'A1' }
  ]
  /* Many more users */
};

const stages = ['A1', 'B1', 'C1', 'D1'];

const getCount = (stage, user) => {
  const stageItem = obj[user.name].find(s => s.stageId === stage);
  return stageItem ? stageItem.count : 0;
};

const r = Object.entries(obj)
  .map(([name, user]) => ({ name, jCount: user[0].jCount }))
  .map(user => {
const stagesCounts = stages
  .map(stage => ({
    [`stageIdCount${stage}`]: getCount(stage, user)
  }))
  .reduce((acc, stage) => ({ ...acc, ...stage }), {});
return { ...user, ...stagesCounts };
  });

console.log(r);

Update (ES5)

const obj = {
  'User 1': [
    { count: '1', stage: 'A', jCount: '10', name: 'User 1', stageId: 'A1' },
    { count: '8', stage: 'B', jCount: '10', name: 'User 1', stageId: 'B1' }
  ],

  'User 2': [
    { count: '7', stage: 'C', jCount: '8', name: 'User 2', stageId: 'C1' },
    { count: '8', stage: 'B', jCount: '8', name: 'User 2', stageId: 'B1' },
    { count: '9', stage: 'A', jCount: '8', name: 'User 2', stageId: 'A1' },
    { count: '8', stage: 'D', jCount: '8', name: 'User 2', stageId: 'D1' }
  ],

  'User 3': [
    { count: '6', stage: 'D', jCount: '6', name: 'User 3', stageId: 'D1' },
    { count: '8', stage: 'B', jCount: '6', name: 'User 3', stageId: 'B1' },
    { count: '1', stage: 'A', jCount: '6', name: 'User 3', stageId: 'A1' }
  ]
  /* Many more users */
};

const stages = ['A1', 'B1', 'C1', 'D1'];

function getCount(stage, user) {
  const stageItem = obj[user.name].find(s => s.stageId === stage);
  return stageItem ? stageItem.count : 0;
}

function mapStages(user) {
  return stages
    .map(stage => ({
      [`stageIdCount${stage}`]: getCount(stage, user)
    }))
    .reduce((acc, stage) => ({ ...acc, ...stage }), {});
}

const r = Object.entries(obj)
  .map(function(entry) {
    return { name: entry[0], jCount: entry[1][0].jCount };
  })
  .map(function(user) {
    return Object.assign(user, mapStages(user));
  });

console.log(r);

Mr world wide · Accepted Answer · 2018-06-02 02:02:47Z

This is how I found my solution:

var obj = {
	'User 1': [
		{ count: '1', stage: 'A', jCount: '10', name: 'User 1', stageId: 'A1' },
		{ count: '8', stage: 'B', jCount: '10', name: 'User 1', stageId: 'B1' }
	],
	
	'User 2': [
		{ count: '7', stage: 'C', jCount: '8', name: 'User 2', stageId: 'C1' },
		{ count: '8', stage: 'B', jCount: '8', name: 'User 2', stageId: 'B1' },
		{ count: '9', stage: 'A', jCount: '8', name: 'User 2', stageId: 'A1' },
		{ count: '8', stage: 'D', jCount: '8', name: 'User 2', stageId: 'D1' }
	],
	
	'User 3': [
		{ count: '6', stage: 'D', jCount: '6', name: 'User 3', stageId: 'D1' },
		{ count: '8', stage: 'B', jCount: '6', name: 'User 3', stageId: 'B1' },
		{ count: '1', stage: 'A', jCount: '6', name: 'User 3', stageId: 'A1' }
	]
	/* Many more users */
};

var stages = ['A1', 'B1', 'C1', 'D1'];

function getCount(stage, user) {
	var stageItem = obj[user.name].find(function (s) {
		return s.stageId === stage;
	});
	return stageItem ? stageItem.count : 0;
}

var _extends = Object.assign || function (target) { for (var i = 1; i < arguments.length; i++) { var source = arguments[i]; for (var key in source) { if (Object.prototype.hasOwnProperty.call(source, key)) { target[key] = source[key]; } } } return target; };

function _defineProperty(obj, key, value) { if (key in obj) { Object.defineProperty(obj, key, { value: value, enumerable: true, configurable: true, writable: true }); } else { obj[key] = value; } return obj; }

function mapStages(user) {
	return stages.map(function (stage) {
		return _defineProperty({}, "stageIdCount" + stage, getCount(stage, user));
		}).reduce(function (acc, stage) {
		return _extends({}, acc, stage);
	}, {});
}

var r = Object.entries(obj)
.map(function(entry) {
	return { name: entry[0], jCount: entry[1][0].jCount };
})
.map(function(user) {
	return Object.assign(user, mapStages(user));
});

console.log(r);

Collectives™ on Stack Overflow

How to group by and merge in java-script object ES5

3 Answers 3

3 Comments

Update (ES5)

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Update (ES5)

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related