回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>如下图所示,它是一个包含图书数据的json,书店每年都会调整图书价格。目标是获得每本书的年平均书价,并将其显示在表格中</p>
<p><strong>Json</strong></p>
<pre><code>[
{
"Year":"2009",
"Book store":"ABC Store",
"Book name":"Happy Prince"
"Book price":"10"
},
{
"Year":"2009",
"Book store":"ABC Store",
"Book name":"Happy Prince"
"Book price":"14"
},
"Year":"2009",
"Book store":"ABC Store",
"Book name":"Happy Prince"
"Book price":"13"
},
"Year":"2009",
"Book store":"ABC Store",
"Book name":"Jane"
"Book price":"10"
},
"Year":"2009",
"Book store":"ABC Store",
"Book name":"Jane"
"Book price":"12"
},
"Year":"2010",
"Book store":"ABC Store",
"Book name":"Happy Prince"
"Book price":"15"
},
"Year":"2010",
"Book store":"ABC Store",
"Book name":"Happy Prince"
"Book price":"10"
},
"Year":"2010",
"Book store":"ABC Store",
"Book name":"Jane"
"Book price":"15"
},
"Year":"2010",
"Book store":"ABC Store",
"Book name":"Jane"
"Book price":"11"
},
]
</code></pre>
<p>每本书的年平均价格表
<a href="https://i.stack.imgur.com/9mjLu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9mjLu.png" alt="enter image description here"/></a></p>