多维数组的最佳JSON结构是什么
多维数组的最佳JSON结构是什么
提问于 2018-06-07 14:56:05
我有下面的excel表格。我希望在json结构中表示该表。
最好的结构是什么？
回答 4
Stack Overflow用户
回答已采纳
发布于 2018-06-07 15:23:22
这是JSON结构。请检查并确认。
{
"men": [
{
"USA": [
{
"during12months": {
"1997": "9.5%",
"2002": "16.6%",
"2012": "12.2%"
},
"earlier12months": {
"1997": "8.3%",
"2002": "7.8%",
"2012": "22.9%"
},
"never": {
"1997": "82.2%",
"2002": "75.6%",
"2012": "64.9%"
}
}
],
"Europe": [
{
"during12months": {
"1997": "9.2%",
"2002": "14.4%",
"2012": "13.7%"
},
"earlier12months": {
"1997": "11.3%",
"2002": "8.2%",
"2012": "18.5%"
},
"never": {
"1997": "79.5%",
"2002": "77.4%",
"2012": "67.8%"
}
}
]
}
],
"women": [
{
"USA": [
{
"during12months": {
"1997": "12.1%",
"2002": "15.5%",
"2012": "13.4%"
},
"earlier12months": {
"1997": "7.0%",
"2002": "8.4%",
"2012": "23.6%"
},
"never": {
"1997": "80.9%",
"2002": "76.1%",
"2012": "63.0%"
}
}
],
"Europe": [
{
"during12months": {
"1997": "12.6%",
"2002": "17.6%",
"2012": "14.9%"
},
"earlier12months": {
"1997": "8.8%",
"2002": "8.2%",
"2012": "16.9%"
},
"never": {
"1997": "78.6%",
"2002": "74.2%",
"2012": "68.2%"
}
}
]
}
],
"total": [
{
"USA": [
{
"during12months": {
"1997": "10.8%",
"2002": "16.0%",
"2012": "12.8%"
},
"earlier12months": {
"1997": "7.7%",
"2002": "8.1%",
"2012": "23.3%"
},
"never": {
"1997": "81.5%",
"2002": "75.9%",
"2012": "63.9%"
}
}
],
"Europe": [
{
"during12months": {
"1997": "11.0%",
"2002": "16.0%",
"2012": "14.3%"
},
"earlier12months": {
"1997": "10.0%",
"2002": "8.2%",
"2012": "17.7%"
},
"never": {
"1997": "79.0%",
"2002": "75.8%",
"2012": "68.0%"
}
}
]
}
]
}要获取列的查询，请执行以下操作：
{
"men": [
{
"Europe": [
{
"earlier12months": {
"1997": "11.3%",
"2002": "8.2%",
"2012": "18.5%"
}
}
]
}
],
"women": [
{
"Europe": [
{
"earlier12months": {
"1997": "8.8%",
"2002": "8.2%",
"2012": "16.9%"
}
}
]
}
],
"total": [
{
"Europe": [
{
"earlier12months": {
"1997": "10.0%",
"2002": "8.2%",
"2012": "17.7%"
}
}
]
}
]
}希望能对你有所帮助
谢谢Muthu
Stack Overflow用户
发布于 2018-06-07 15:12:53
最好的结构？那得看情况。一种方法是创建一个对象(单元格)数组。每个单元格都包含“百分比”、“国家”、“性别”和“年份”等属性。这样，您就可以轻松地对这些列进行排序。
另一种方法是创建只具有X和Y属性的单元格的二维数组，以显示它们在表格中的位置。你必须发送一些关于表格本身的信息。
Stack Overflow用户
发布于 2018-06-07 15:31:19
对于更难的版本..哈哈！
来源：
{
"rows":
[
{ row:"Men",
data:{ rows:[
{ row:"1997",data:{
cols:[
{ col:"USA", data: {
cols:[
{ col:"during last 12", data:"9.5%"},
{ col:"earlier than 12", data:"9.5%"},
{ col:"never", data:"9.5%"} ] }}
,
{ col:"Europe", data: {}}] } },
{ row:"2002",data:{} },
{ row:"2002",data:{} }] }}
,
{ row:"Women" }
,
{ row:"Total" }
]
}搞笑点。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/50734739
复制相关文章
相似问题