你好,我是javascript的新手,我的项目需要将数组的格式改为新的格式。以下是我的代码:
var array=[
{ Indicator: "Population National (% of population)", Country: "India", Year: "2012", Value: "98.8" },
{ Indicator: "Population National (% of population)", Country: "India", Year: "2013", Value: "99.1" },
{ Indicator: "Population National (% of population)", Country: "Japan", Year: "2012", Value: "99.2" },
{ Indicator: "Population National (% of population)", Country: "Japan", Year: "2013", Value: "99.3" },
{ Indicator: "Population National (% of population)", Country: "China", Year: "2012", Value: "99.4" },
{ Indicator: "Population National (% of population)", Country: "China", Year: "2013", Value: "99.8" },
{ Indicator: "Population Rural (% of population)", Country: "India", Year: "2012", Value: "97.9" },
{ Indicator: "Population Rural (% of population)", Country: "India", Year: "2013", Value: "98.2" },
{ Indicator: "Population Rural (% of population)", Country: "Japan", Year: "2012", Value: "98.4" },
{ Indicator: "Population Rural (% of population)", Country: "Japan", Year: "2013", Value: "98.7" },
{ Indicator: "Population Rural (% of population)", Country: "China", Year: "2012", Value: "99.0" },
{ Indicator: "Population Rural (% of population)", Country: "China", Year: "2013", Value: "98.0" },
{ Indicator: "Population Urban (% of population)", Country: "India", Year: "2012", Value: "99.3" },
{ Indicator: "Population Urban (% of population)", Country: "India", Year: "2013", Value: "93.6" },
{ Indicator: "Population Urban (% of population)", Country: "Japan", Year: "2012", Value: "99.6" },
{ Indicator: "Population Urban (% of population)", Country: "Japan", Year: "2013", Value: "97.6" },
{ Indicator: "Population Urban (% of population)", Country: "China", Year: "2012", Value: "95.6" },
{ Indicator: "Population Urban (% of population)", Country: "China", Year: "2013", Value: "99.6" }];
我需要将这个改为以下内容。
var array=[{"Country":"India", "Indicator": "Population National (% of population)","2012": "98.8","2013": "99.1"},
{"Country":"India", "Indicator": "Population Rural (% of population)","2012": "97.9","2013": "98.2"},
{"Country":"India", "Indicator": "Population Urban (% of population)","2012": "99.3","2013": "93.6"},
{"Country":"Japan", "Indicator": "Population National (% of population)","2012": "99.2","2013": "99.3"},
{"Country":"Japan", "Indicator": "Population Rural (% of population)","2012": "98.4","2013": "98.7"},
{"Country":"Japan", "Indicator": "Population Urban (% of population)","2012": "99.6","2013": "97.6"},
{"Country":"China", "Indicator": "Population National (% of population)","2012": "99.4","2013": "99.8"},
{"Country":"China", "Indicator": "Population Rural (% of population)","2012": "99.0","2013": "98.0"},
{"Country":"China", "Indicator": "Population Urban (% of population)","2012": "95.6","2013": "99.6"}
];
我尝试了每种方法,包括循环遍历数组并创建新数组,但我无法实现所需格式。
这是我的做法。
var excelArr = [],tempCountryArr=[],tempIndicArr=[],tempYearArr=[];
_.each(array, function (val, i) {
if (_.contains(tempCountryArr, val.Country) == false) {
tempCountryArr.push(val.Country);
}
if (_.contains(tempIndicArr, val.Indicator) == false) {
tempIndicArr.push(val.Indicator);
}
if (_.contains(tempYearArr, val.Year) == false) {
tempYearArr.push(val.Year);
}
});
for (var i = 0; i < tempCountryArr.length; i++) {
var countrydata = _.filter(array, function (item) {
return (item.Country == tempCountryArr[i] && item.Indicator == tempIndicArr[i]);
});
var indicator = [];
for (var j = 0; j < countrydata.length; j++) {
for (var k = 0; k < tempYearArr.length; k++) {
var yrArr = "";
var yeardata = _.filter(countrydata, function (item) {
return (item.Year == tempYearArr[k] && item.Indicator == countrydata[j].Indicator && item.Country == tempCountryArr[i]);
});
yrArr = tempYearArr[k];
if (yeardata.length > 0) {
if (yeardata[0].Value != null && yeardata[0].Value != undefined && yeardata[0].Value != "NaN") {
if (excelArr.length != 0 && excelArr[j] != undefined) {
excelArr[j][yrArr] = yeardata[0].Value;
} else {
excelArr.push({ [yrArr]: yeardata[0].Value });
}
} else {
if (excelArr.length != 0 && excelArr[j] != undefined) {
excelArr[j][yrArr] = "NA";
}
else {
excelArr.push({ [yrArr]: "NA" });
}
}
}
else {
if (excelArr.length != 0 && excelArr[j] != undefined) {
excelArr[j][yrArr] = "NA";
}
else {
excelArr.push({ yrArr: "NA" });
}
}
}
excelArr[j].Indicator = countrydata[j].Indicator.toString();
excelArr[j]["Country"] = countrydata[j].Country;
}
}
我需要任何帮助。提前感谢。