擅长:python、mysql、java
<p>看起来像这样pandas.pivot_表()<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.pivot_table.html" rel="nofollow noreferrer">pivot_table</a>对我来说,请注意,如果您认为会有重复的话,可以添加一个agg函数(从示例中看来,每天只读取一次)。在</p>
<pre><code>import pandas as pd
instrument=['KYG2615B1014','KYG2615B1014','KYG2615B1014', 'JP3843250006', 'JP3843250006', 'JP3843250006']
date=['11/29/2017', '11/28/2017', '11/27/2017', '11/29/2017', '11/28/2017', '11/27/2017']
total_return=[0.0, -10.679612, -8.035714, 0.348086, 0.349301, 0.200000]
stacked = pd.DataFrame(dict(Instrument=instrument, Date=date, Total_return=total_return)
pd.pivot_table(stacked, values='Total_return', index='Instrument', columns='Date')
</code></pre>
<p>这将返回以下结果:</p>
^{pr2}$