使用Lodash在对象数组中创建多个groupBy和sumBy

Question

我有以下数据:

const rawData=[
{
Order_Date: "2020-08-11",
Region: "South",
Product_Name: "Bookcase",
Sales: 261.96
},
{
Order_Date: "2020-08-13",
Region: "South",
Product_Name: "Stacking Chairs",
Sales: 731.94
},
{
Order_Date: "2020-10-06",
Region: "South",
Product_Name: "Stacking Chairs",
Sales: 700.45
},
{
Order_Date: "2020-12-06",
Region: "East",
Product_Name: "Self-Adhesive Address Labels for Typewriters by Universal",
Sales: 14.62
},
{
Order_Date: "2019-11-15",
Region: "East",
Product_Name: "Table",
Sales: 957
},
{
Order_Date: "2019-11-10",
Region: "East",
Product_Name: "Eldon Fold",
Sales: 22
}
]

预期输出:

[
{
Region: "South",
data: [
{
Order_Date: "2020-08",
Sales: 993.90
},
{
Order_Date: "2020-10",
Sales: 700.45
},
]
},
{
Region: "East",
data: [
{
Order_Date: "2019-11",
Sales: 989
},
{
Order_Date: "2020-12",
Sales: 14.62
},
]
}
]

我想首先按地区分组，对于每个地区，我想按Order_Date的年和月('YYYY-MM')分组，并按每个Order_Date('YYYY-MM')组的销售额求和。

我尝试了以下代码，但无法获得预期的输出。我不明白如何处理多个组

const groupByRegion = _(rawData).groupBy('Region').value();
const groupByRegionDate = _.forEach(groupByRegion, (value, key) => {
groupByRegion[key] = _.groupBy(groupByRegion[key], (item) =>
moment(item.Order_Date).startOf('month').format('YYYY-MM')
);
});

Answer 1

let data = [{ "Order_Date": "2020-08-11", "Region": "South", "Product_Name": "Bookcase", "Sales": 261.96 }, { "Order_Date": "2020-08-11", "Region": "South", "Product_Name": "Stacking Chairs", "Sales": 731.94 }, { "Order_Date": "2020-10-06", "Region": "South", "Product_Name": "Stacking Chairs", "Sales": 700.45 }, { "Order_Date": "2020-12-06", "Region": "East", "Product_Name": "Typewriters by Universal", "Sales": 14.62 }, { "Order_Date": "2019-11-10", "Region": "East", "Product_Name": "Table", "Sales": 957 }, { "Order_Date": "2019-11-10", "Region": "East", "Product_Name": "Eldon Fold", "Sales": 22 }]
let results = []
for (let item of data) {
let { Region, Order_Date, Sales } = item;
let group = results.find(v => v.Region == Region);
if (!group) results.push(group = { Region, data: [] });
let groupItem = group.data.find(v => v.Order_Date == Order_Date);
if (!groupItem)
group.data.push({ Order_Date, Sales })
else
groupItem.Sales += Sales;
}
console.log(results)