擅长:python、mysql、java
<p>不是特别令人愉快的解决方案:</p>
<pre><code>df = pd.DataFrame([['Sixers', 'Celtics', 83.4, 100.7],
['Pelicans', 'Sixers', 88.1, 89.2]],
columns=['Visitor', 'Home', 'Visitor_rtg', 'Home_rtg'])
melted = df.melt(['Visitor', 'Home'])
pd.concat([melted.loc[melted['variable'] == 'Visitor_rtg', ['Visitor', 'value']].rename(columns={'Visitor': 'Team'}),
melted.loc[melted['variable'] == 'Home_rtg', ['Home', 'value']].rename(columns={'Home': 'Team'})],
axis=0,
ignore_index=True
).groupby('Team').mean()
</code></pre>