Javascript群和给出错误结果
Javascript群和给出错误结果
提问于 2020-08-26 16:48:27
我有这个字典列表，data，我想应用groupby，然后做的和，但是在最后的聚合中，我得到的是end_date，而不是2020-05-17 00:00:00+00。
请告诉我哪里做错了。
输入数据:-
data = [
{start_date: "2020-05-11 00:00:00+00", end_date: "2020-05-17 00:00:00+00", id: "ola", amount: 10},
{start_date: "2020-05-11 00:00:00+00", end_date: "2020-05-17 00:00:00+00", id: "ola", amount: 2}
]预期结果:-
start_date: "2020-05-11 00:00:00+00", end_date: "2020-05-17 00:00:00+00", amount: 12}当前结果:-
start_date: "2020-05-11 00:00:00+00", end_date: "2020-05-11 00:00:00+00", amount: 12}群公式:-
var result = _(data)
.groupBy(x => x.start_date, y => y.end_date)
.map((value, key) => ({start_date: key, end_date : key, amount: _.sumBy(value, 'amount')}))
.value();如果有任何其他解决方案与Javascript，请建议。谢谢
回答 2
Stack Overflow用户
发布于 2020-08-26 16:56:51
因为您是在链接data，所以下一个groupBy只需接受一个param (这是转换文档中键的迭代器)。
您可以制作start_date和end_date组合的组密钥。
const data = [
{
start_date: "2020-05-11 00:00:00+00",
end_date: "2020-05-17 00:00:00+00",
id: "ola",
amount: 10,
},
{
start_date: "2020-05-11 00:00:00+00",
end_date: "2020-05-17 00:00:00+00",
id: "ola",
amount: 2,
},
]
const result = _(data)
.groupBy((obj) => [obj.start_date, obj.end_date].join("to"))
.map((value, key) => ({
start_date: key.split("to")[0],
end_date: key.split("to")[1],
amount: _.sumBy(value, "amount"),
}))
.value()
console.log(result)<script src="https://cdn.jsdelivr.net/npm/lodash@4.17.20/lodash.min.js"></script>
Stack Overflow用户
发布于 2020-08-26 17:00:55
使用开始和结束作为键的简单约简循环
data = [{
start_date: "2020-05-11 00:00:00+00",
end_date: "2020-05-17 00:00:00+00",
id: "ola",
amount: 10
},
{
start_date: "2020-05-11 00:00:00+00",
end_date: "2020-05-17 00:00:00+00",
id: "ola",
amount: 2
}
]
const groupIt = data => {
const groupings = data.reduce((grps, item) => {
const { start_date, end_date, amount } = item;
const key = `${start_date}-${end_date}`;
grps[key] = grps[key] || { start_date, end_date, amount: 0 };
grps[key].amount += amount;
return grps;
}, {});
return Object.values(groupings);
}
const result = groupIt(data);
console.log(result);
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/63602188
复制相关文章
相似问题
腾讯云开发者
