擅长:python、mysql、java
<p>熊猫套餐能很好地处理这个问题。</p>
<pre><code>>>> import pandas
>>> df=pandas.DataFrame(data, columns=['Fruit', 'Shop', 'Price'])
>>> df.pivot(index='Fruit', columns='Shop', values='Price')
Shop Coles IGA Woolworths
Fruit
Apple 1.5 1.7 1.6
Banana 0.5 0.7 0.6
Cherry 5.0 NaN NaN
Date 2.0 NaN 2.1
Elderberry NaN 10.0 NaN
</code></pre>
<p>文件:
<a href="http://pandas.pydata.org/pandas-docs/stable/reshaping.html" rel="noreferrer">http://pandas.pydata.org/pandas-docs/stable/reshaping.html</a></p>
<p>一些学习熊猫的IPython笔记本:
<a href="https://bitbucket.org/hrojas/learn-pandas" rel="noreferrer">https://bitbucket.org/hrojas/learn-pandas</a></p>
<p>希望这会有帮助。<br/>
致意<br/>
帕特里克·布罗克曼</p>