擅长:python、mysql、java
<p>如果您的熊猫不支持<code>explode</code>:</p>
<pre><code>df['play_length'] = pd.to_timedelta(df['play_length'])
new_df = pd.concat((df[['play_length']],
df['away_lineup'].str.split(',\s*', expand=True)),
axis=1)
(new_df.melt(id_vars=['play_length'],
value_vars=new_df.columns[1:],
value_name='artist')
.groupby('artist').play_length.sum()
)
</code></pre>
<p>输出:</p>
<pre><code>artist
Ben Simmons 00:01:07
Dario Saric 00:01:21
JJ Redick 00:00:14
Joel Embiid 00:01:21
Markelle Fultz 00:01:21
Robert Covington 00:01:21
Name: play_length, dtype: timedelta64[ns]
</code></pre>