擅长:python、mysql、java
<p>似乎问题来自列rep和sales的不同类型,如果将sales转换为<code>str</code>类型并将aggfunc指定为<code>sum</code>,那么它可以正常工作:</p>
<pre><code>df.sales = df.sales.astype(str)
pd.pivot_table(df, index=['country'], columns=['year'], values=['rep', 'sales'], aggfunc='sum')
# 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>