擅长:python、mysql、java
<p>这里有一个可能的解决方案-</p>
<pre class="lang-py prettyprint-override"><code>import pandas as pd
df = pd.DataFrame(data=['InterfaceA', 'Up', 'Up', 9000, 'InterfaceB', 'Down', 'Down', 9001],
index=['Interface', 'State', 'Line Status', 'ID', 'Interface', 'State', 'Line Status', 'ID'])
df = df.T
print(df.groupby(df.columns.values, axis=1).agg(lambda x: x.values.tolist()).sum().apply(pd.Series).T)
</code></pre>
<pre><code> ID Interface Line Status State
0 9000 InterfaceA Up Up
1 9001 InterfaceB Down Down
</code></pre>
<p>本<a href="https://stackoverflow.com/a/50083006/10733051">answer</a>的学分</p>