gpt4 book ai didi

json - 如何借助 Underscore.js 库对 JSON 数据的日期进行分组?

转载 作者:行者123 更新时间:2023-12-01 09:56:13 25 4
gpt4 key购买 nike

我有以下 JSON 数据:

var data = [
{ "allocated":"20", "unallocated":"2", "day":"01/01/2014" },
{ "allocated":"12", "unallocated":"0", "day":"02/01/2014" },
{ "allocated":"2", "unallocated":"18", "day":"03/01/2014" },
{ "allocated":"22", "unallocated":"2", "day":"04/01/2014" },
{ "allocated":"3", "unallocated":"13", "day":"05/01/2014" },
{ "allocated":"6", "unallocated":"2.4", "day":"06/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"07/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"08/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"09/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"10/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"11/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"12/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"13/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"14/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"15/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"16/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"17/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"18/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"19/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"20/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"21/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"22/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"23/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"24/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"25/01/2014" }

]

现在我想对这些数据进行 GroupBy“WEEK”。所以,我需要以周为单位的上述数据。使用 underscore.js 库怎么可能?提前致谢

最佳答案

使用 moment.js和下划线的 _.groupBy,您可以执行以下操作:

var data = [
{ "allocated":"20", "unallocated":"2", "day":"01/01/2014" },
{ "allocated":"12", "unallocated":"0", "day":"02/01/2014" },
{ "allocated":"2", "unallocated":"18", "day":"03/01/2014" },
{ "allocated":"22", "unallocated":"2", "day":"04/01/2014" },
{ "allocated":"3", "unallocated":"13", "day":"05/01/2014" },
{ "allocated":"6", "unallocated":"2.4", "day":"06/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"07/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"08/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"09/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"10/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"11/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"12/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"13/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"14/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"15/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"16/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"17/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"18/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"19/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"20/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"21/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"22/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"23/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"24/01/2014" },
{ "allocated":"14", "unallocated":"7", "day":"24/05/2014" },
{ "allocated":"14", "unallocated":"7", "day":"25/01/2014" }

];

var groupedByYear = _.groupBy(data, function(item) {
var dateMoment = moment(item.day,"DD/MM/YYYY");
return dateMoment.week();
});

var weekDiv = document.getElementById("weeks").innerHTML = JSON.stringify(groupedByYear);
<script src="//cdnjs.cloudflare.com/ajax/libs/moment.js/2.8.3/moment.min.js"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/underscore.js/1.7.0/underscore-min.js"></script>
<div id="weeks"></div>

关于json - 如何借助 Underscore.js 库对 JSON 数据的日期进行分组?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/26337074/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com