擅长:python、mysql、java
<p>您可以<code>pd.concat</code>、<code>wow</code>和<code>wow.T</code>然后<code>groupby</code>索引和<code>sum</code>再次:</p>
<pre><code>>>> wow=pd.crosstab(B.F1,
B.F2,
values=B.Count,
aggfunc='sum',
).rename_axis(None).rename_axis(None, axis=1)
>>> wow
A C U
A NaN 5.0 NaN
B NaN 2.0 6.0
C 1.0 NaN NaN
>>> pd.concat([wow, wow.T], sort=True).fillna(0, downcast='infer').groupby(level=0).sum()
A B C U
A 0 0 6 0
B 0 0 2 6
C 6 2 0 0
U 0 6 0 0
</code></pre>