回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>这是我<a href="https://stackoverflow.com/questions/39229005/pivot-table-no-numeric-types-to-aggregate/39229396#39229396">question</a>的后续报道。与透视表不同,是否可以将表展平为如下所示:</p>
<pre><code>data = {'year': ['2016', '2016', '2015', '2014', '2013'],
'country':['uk', 'usa', 'fr','fr','uk'],
'sales': [10, 21, 20, 10,12],
'rep': ['john', 'john', 'claire', 'kyle','kyle']
}
pd.DataFrame(data).pivot_table(index='country', columns='year', values=['rep','sales'])
rep sales
year 2013 2014 2015 2016 2013 2014 2015 2016
country
fr None kyle claire None None 10 20 None
uk kyle None None john 12 None None 10
usa None None None john None None None 21
</code></pre>
<p>平桌:</p>
<pre><code> rep_2013 rep_2014 rep_2015 rep_2016 sales_2013 sales_2014 sales_2015 sales_2016
country
fr None kyle claire None None 10 20 None
uk kyle None None john 12 None None 10
usa None None None john None None None 21
</code></pre>