擅长:python、mysql、java
<p>以下是另一种解决方案:</p>
<pre><code>In [53]: (pd.to_datetime(df['duration'], format='PT%MM%SS', errors='coerce') -
...: pd.to_datetime('1900-01-01')).dt.total_seconds()
...:
Out[53]:
0 427.0
1 434.0
2 405.0
Name: duration, dtype: float64
</code></pre>
<p>数据:</p>
^{pr2}$
<p>说明:</p>
<pre><code>In [55]: pd.to_datetime(df['duration'], format='PT%MM%SS', errors='coerce')
Out[55]:
0 1900-01-01 00:07:07
1 1900-01-01 00:07:14
2 1900-01-01 00:06:45
Name: duration, dtype: datetime64[ns]
</code></pre>