我有一個 csv 格式的數(shù)據(jù)集:continents countries valuesEurope Germany 20Europe France 30Europe Spain 40Asia Singapore 100Asia Japan 300Asia China 30Asia Tiwan 500America USA 50America Canada 35America Brazil 30America Equador 14當(dāng)我解析它使用d3.csv和map然后將數(shù)據(jù)看起來像這樣:[{continents: "Europe", countries: "Germany", values: 20}{continents: "Europe", countries: "France", values: 30} {continents: "Europe", countries: "Spain", values: 40} and so forth. ]我想要做的是按大洲組將格式轉(zhuǎn)換為寬格式,使數(shù)據(jù)看起來像這樣[{continents: "Europe", values: {"Germany" : 20}, {"France" : 30}, {"Spain" : 40}},{continents: "Asia", values: {"Singapore" : 100}, {"Japan" : 300}, {"China" : 30}}] 這就是我目前正在做的事情。d3.csv("/data/data.csv").then(function(csv) { data = csv.map(function(d) { return { continents: d.continents, countries: d.countries, values: +d.values} }); 格式不需要與上面的示例完全相同,但重點是使用屬于各自大洲組的國家和值制作鍵:值對。誰能告訴我怎么做?
d3 數(shù)據(jù)解析/轉(zhuǎn)換(從長到寬)
慕的地6264312
2021-06-22 17:02:19