擅长:python、mysql、java
<p>与<code>.apply</code>一起使用<code>str.findall</code></p>
<p><strong>例如:</strong></p>
<pre><code>data = { "size":["2","5mm","10mm","12-15mm","16-19mm"] }
dt =pd.DataFrame(data=data)
dt["size_m"] = dt["size"].str.findall("(\d+)").apply(lambda x: sum(map(float, x))/len(x))
print(dt)
</code></pre>
<p><strong>输出:</strong></p>
<pre><code> size size_m
0 2 2.0
1 5mm 5.0
2 10mm 10.0
3 12-15mm 13.5
4 16-19mm 17.5
</code></pre>