"Industries": [
{
"Country": null,
"Data": [
{
"Industry": "Aviation",
"Count": 1
}
]
},
{
"Country": "Algeria",
"Data": [
{
"Industry": "Tourism/Hospitality",
"Count": 1
}
]
},
{
"Country": "American Samoa",
"Data": [
{
"Industry": "Commercial/Retail",
"Count": 1
}
]
},
{
"Country": "Angola",
"Data": [
{
"Industry": "Agriculture",
"Count": 1
},
{
"Industry": "Commercial/Retail",
"Count": 1
},
{
"Industry": "Energy/Power Generation",
"Count": 1
},
{
"Industry": "Telecommunication",
"Count": 1
}
]
},
{
"Country": "Antarctica",
"Data": [
{
"Industry": "Agriculture",
"Count": 1
},
{
"Industry": "Waste Management",
"Count": 1
}
]
},
{
"Country": "Australia",
"Data": [
{
"Industry": "Beauty & Wellness",
"Count": 1
}
]
},
{
"Country": "Belgium",
"Data": [
{
"Industry": "Food & Beverages",
"Count": 1
}
]
},
{
"Country": "Belize",
"Data": [
{
"Industry": "Education and Training",
"Count": 1
}
]
},
{
"Country": "Benin",
"Data": [
{
"Industry": "Agriculture",
"Count": 39
},
{
"Industry": "Beauty & Wellness",
"Count": 2
},
{
"Industry": "Commercial/Retail",
"Count": 3
},
{
"Industry": "Construction",
"Count": 1
},
{
"Industry": "Consulting",
"Count": 1
},
{
"Industry": "Education and Training",
"Count": 2
},
{
"Industry": "Energy/Power Generation",
"Count": 3
},
{
"Industry": "Fashion",
"Count": 4
},
{
"Industry": "FMCG",
"Count": 2
},
{
"Industry": "Food & Beverages",
"Count": 6
},
{
"Industry": "Healthcare",
"Count": 1
},
{
"Industry": "ICT",
"Count": 5
},
{
"Industry": "Manufacturing",
"Count": 3
},
{
"Industry": "Telecommunication",
"Count": 1
},
{
"Industry": "Transportation",
"Count": 1
},
{
"Industry": "Waste Management",
"Count": 4
}
]
}
]
}
有了这个json数据，我如何将其转换为
[
{
name: "Agriculture",
data: [0,0,0,1,1,0,0,0,39]
},
{
name: "Aviation",
data: [1,0,0,0,0,0,0,0,0]
},
{
name: "Beauty & Wellness",
data: [0,0,0,0,0,1,0,0,2]
},
{
name: "Commercial/Retail",
data: [0,0,1,1,0,0,0,0,3]
},
{
name: "Construction",
data: [0,0,0,0,0,0,0,0,1]
},
{
name: "Consulting",
data: [0,0,0,0,0,0,0,0,1]
},
{
name: "Education and Training",
data: [0,0,0,0,0,0,0,1,2]
},
{
name: "Energy/Power Generation",
data: [0,0,0,1,0,0,0,0,3]
},
{
name: "Fashion",
data: [0,0,0,0,0,0,0,0,4]
},
{
name: "FMCG",
data: [0,0,0,0,0,0,0,0,2]
},
{
name: "Food & Beverages",
data: [0,0,0,0,0,0,1,0,6]
},
{
name: "Healthcare",
data: [0,0,0,0,0,0,0,0,1]
},
{
name: "ICT",
data: [0,0,0,0,0,0,0,0,5]
},
{
name: "Manufacturing",
data: [0,0,0,0,0,0,0,0,3]
},
{
name: "Telecommunication",
data: [0,0,0,1,0,0,0,0,1]
},
{
name: "Tourism/Hospitality",
data: [0,1,0,0,0,0,0,0,0]
},
{
name: "Transportation",
data: [0,0,0,0,0,0,0,0,1]
}
{
name: "Waste Management",
data: [0,0,0,0,1,0,0,0,4]
}
]
我尝试了以下方法：
let countryData = data.Industries.map(country => country.Country)
document.write(JSON.stringify(countryData))
let industryData = data.Industries.map(industry => {
return industry.Data.map(i => {
return i.Industry
})
})
let flatIndustry = industryData.flat(Infinity).sort()
let filterIndustry = flatIndustry.filter((a, b) => flatIndustry.indexOf(a) === b)
let getCount = data.Industries.map(industry => {
return industry.Data.map((i, index) => {
return i.Count
})
})
注意：将对结果行业数据进行排序，并将检查每个国家/地区是否存在该特定行业，如果不对所排序的行业值附加零（0）或前缀（0）。
我在堆叠的条形图中使用此数据
最佳答案
多个JavaScript函数（如reduce和map）可用于实现所需的格式。查看以下演示：
const data = {
"Industries": [
{
"Country": null,
"Data": [
{
"Industry": "Aviation",
"Count": 1
}
]
},
{
"Country": "Algeria",
"Data": [
{
"Industry": "Tourism/Hospitality",
"Count": 1
}
]
},
{
"Country": "American Samoa",
"Data": [
{
"Industry": "Commercial/Retail",
"Count": 1
}
]
},
{
"Country": "Angola",
"Data": [
{
"Industry": "Agriculture",
"Count": 1
},
{
"Industry": "Commercial/Retail",
"Count": 1
},
{
"Industry": "Energy/Power Generation",
"Count": 1
},
{
"Industry": "Telecommunication",
"Count": 1
}
]
},
{
"Country": "Antarctica",
"Data": [
{
"Industry": "Agriculture",
"Count": 1
},
{
"Industry": "Waste Management",
"Count": 1
}
]
},
{
"Country": "Australia",
"Data": [
{
"Industry": "Beauty & Wellness",
"Count": 1
}
]
},
{
"Country": "Belgium",
"Data": [
{
"Industry": "Food & Beverages",
"Count": 1
}
]
},
{
"Country": "Belize",
"Data": [
{
"Industry": "Education and Training",
"Count": 1
}
]
},
{
"Country": "Benin",
"Data": [
{
"Industry": "Agriculture",
"Count": 39
},
{
"Industry": "Beauty & Wellness",
"Count": 2
},
{
"Industry": "Commercial/Retail",
"Count": 3
},
{
"Industry": "Construction",
"Count": 1
},
{
"Industry": "Consulting",
"Count": 1
},
{
"Industry": "Education and Training",
"Count": 2
},
{
"Industry": "Energy/Power Generation",
"Count": 3
},
{
"Industry": "Fashion",
"Count": 4
},
{
"Industry": "FMCG",
"Count": 2
},
{
"Industry": "Food & Beverages",
"Count": 6
},
{
"Industry": "Healthcare",
"Count": 1
},
{
"Industry": "ICT",
"Count": 5
},
{
"Industry": "Manufacturing",
"Count": 3
},
{
"Industry": "Telecommunication",
"Count": 1
},
{
"Industry": "Transportation",
"Count": 1
},
{
"Industry": "Waste Management",
"Count": 4
}
]
}
]
};
const industries = data.Industries.reduce((acc, cur) => {
const industriesInCountry = cur.Data.map(x => x.Industry);
acc.add(...industriesInCountry);
return acc;
}, new Set());
const industriesCount = Object.values(data.Industries.reduce((acc, cur) => {
industries.forEach(name => {
if(!acc.hasOwnProperty(name)){
acc[name] = { name: name, data: [] };
}
const countOfIndustryInCountry = cur.Data.find(x => x.Industry === name);
acc[name].data.push(countOfIndustryInCountry === undefined ? 0 : countOfIndustryInCountry.Count);
});
return acc;
}, {}));
console.log(industriesCount)