擅长:python、mysql、java
<p>使用自定义函数(基于regex替换):</p>
<pre><code>In [98]: pat = re.compile(r'[^\d]+')
In [99]: def trim_non_num(s):
...: if isinstance(s, str):
...: return int(pat.sub('', s))
...: elif isinstance(s, list):
...: return [int(pat.sub('', i)) for i in s]
...: return s
...:
In [100]: df['col'].apply(trim_non_num)
Out[100]:
0 [6, 12]
1 14
2 26
3 NaN
4 1
Name: col, dtype: object
</code></pre>