我的基本数据结构..
[{
month: 'Jan',day:1
cat: 'A',
type:'val', val: 20
},{
month: 'Jan',day:1
cat: 'B',
type:'val', val: 5
},{
month: 'Jan',day:2
cat: 'A',
type:'val', val: 10
},{
month: 'Jan',day:2
cat: 'B',
type:'val', val: 10
},{
month: 'Feb',day:1
cat: 'A',
type:'val', val: 30
},{
month: 'Feb',day:1
cat: 'B',
type:'val', val: 10
},{
month: 'Feb',day:2
cat: 'A',
type:'val', val: 20
},{
month: 'Feb',day:2
cat: 'B',
type:'val', val: 20
}];
以下是我需要做的:
a)为每个独特的属性'cat'和" day"获取财产" val",说cat:'a'and day:1
b)在上述步骤中进行所有值的平均值,因此,对于每个唯一的属性"猫"one_answers" Day",我们都会得到AVG。val
c)在数组中找到具有上述属性" cat"one_answers" day"
的所有对象d)克隆对象,使数组中的原始对象不会更改
e)将克隆的对象类型更新为'avg',然后将val更新为'avg value recd在步骤(b)中'
f)将新对象添加到基本数据阵列中。
因此,最后,数组将具有较早的值的两倍,并且在数组中要进行的新对象将如下。
{
month: 'Jan',day:1
cat: 'A',
type:'avg', val: 25 //20+30/2
},{
month: 'Jan',day:1
cat: 'B','
type:'avg', val: 7.5 //5+10/2
},{
month: 'Jan',day:2
cat: 'A',
type:'avg', val: 15 //10+20/2
},{
month: 'Jan',day:2
cat: 'B',
type:'avg', val: 15 //10+20/2
},{
month: 'Feb',day:1
cat: 'A',
type:'avg', val: 25
},{
month: 'Feb',day:1
cat: 'B',
type:'avg', val: 7.5
},{
month: 'Feb',day:2
cat: 'A',
type:'avg', val: 15
},{
month: 'Feb',day:2
cat: 'B',
type:'avg', val: 15
}
答案:感谢Nina,我能够解决这个问题,我无法正确解释我的req ..以下是我想要的..
hash = Object.create(null),
result = data.map(function (a, i) {
var key = a.day + '|' + a.cat;
this[key] = this[key] || { indices: [], sum: 0 };
this[key].indices.push(i);
this[key].sum += a.val;
return { month: a.month, day: a.day, cat: a.cat, type: 'avg' };
}, hash);
Object.keys(hash).forEach(function (k) {
hash[k].indices.forEach(function (i) {
result[i].val = hash[k].sum / hash[k].indices.length;
});
});
final_result= $.merge( $.merge( [], data ), result );
这是普通javaScript中的建议,其对象为平均计算的想要组的哈希表。
var data = [{ month: 'Jan', day: 1, cat: 'A', type: 'val', val: 20 }, { month: 'Jan', day: 1, cat: 'B', type: 'val', val: 5 }, { month: 'Jan', day: 2, cat: 'A', type: 'val', val: 10 }, { month: 'Jan', day: 2, cat: 'B', type: 'val', val: 10 }, { month: 'Feb', day: 1, cat: 'A', type: 'val', val: 30 }, { month: 'Feb', day: 1, cat: 'B', type: 'val', val: 10 }, { month: 'Feb', day: 2, cat: 'A', type: 'val', val: 20 }, { month: 'Feb', day: 2, cat: 'B', type: 'val', val: 20 }],
hash = Object.create(null),
result = data.map(function (a, i) {
var key = a.day + '|' + a.cat;
this[key] = this[key] || { indices: [], sum: 0 };
this[key].indices.push(i);
this[key].sum += a.val;
return { month: a.month, day: a.day, cat: a.cat, type: 'avg' };
}, hash);
Object.keys(hash).forEach(function (k) {
hash[k].indices.forEach(function (i) {
result[i].val = hash[k].sum / hash[k].indices.length;
});
});
console.log(result);