擅长:python、mysql、java
<p>您可以先按行对<code>origin</code>和<code>dest</code>列进行排序,然后执行<code>groupby</code>,<code>sum</code>,因为结果看起来并不关心<code>origin</code>和{<cd2>}的顺序:</p>
<pre><code>import pandas as pd
df.reset_index(["origin", "dest"])
od = df.loc[:,'origin':'dest'].as_matrix()
od.sort()
df[['air1','air2']] = pd.DataFrame(od)
df.groupby(['air1','air2']).sum()
a b c d e f
air1 air2
BOS DCA 2 4 6 8 10 12
JFK 2 4 6 8 10 12
DCA JFK 2 4 6 8 10 12
</code></pre>