擅长:python、mysql、java
<p>这是直接的频率转换,参见<a href="http://pandas.pydata.org/pandas-docs/stable/timedeltas.html#frequency-conversion" rel="nofollow">here</a></p>
<pre><code>In [16]: df = pd.DataFrame({'Duration': ['4h 26min. 2sec.',
'0h 8min. 34sec.',
'0h 12min. 17sec.']})
In [17]: df
Out[17]:
Duration
0 4h 26min. 2sec.
1 0h 8min. 34sec.
2 0h 12min. 17sec.
</code></pre>
<p>这些几乎都是标准的形式,只是简单的。在</p>
^{pr2}$
<p>以分钟为单位的浮动结果</p>
<pre><code>In [19]: pd.to_timedelta(df.Duration.str.replace('\.','')) / np.timedelta64(1,'m')
Out[19]:
0 266.033333
1 8.566667
2 12.283333
Name: Duration, dtype: float64
</code></pre>
<p>这会截断</p>
<pre><code>In [20]: pd.to_timedelta(df.Duration.str.replace('\.','')).astype('timedelta64[m]')
Out[20]:
0 266
1 8
2 12
Name: Duration, dtype: float64
</code></pre>