擅长:python、mysql、java
<p>尝试使用正则表达式</p>
<p><strong>Ex:</strong></p>
<pre><code>import re
def p_time(val):
try:
t = 0
h = re.search(r"(\d+) hour(s)?", val)
if h:
t += int(h.group(1)) * 60
m = re.search(r"(\d+) minute(s)?", val)
if m:
t += int(m.group(1))
return t
except:
pass
return 0
s = pd.Series(['1 hour and 59 minutes','2 hours', np.nan, '38 minutes', '4 hours and 31 minute'])
print(s.apply(p_time).astype(int))
</code></pre>
<p><strong>输出:</strong></p>
<pre><code>0 119
1 120
2 0
3 38
4 271
dtype: int32
</code></pre>