擅长:python、mysql、java
<p>考虑数据帧<code>df</code></p>
<pre><code>df = pd.DataFrame(dict(Salary=['200-400', '500', '600-700']))
df
Salary
0 200-400
1 500
2 600-700
</code></pre>
<p><strong><code>pandas</code></strong><br/>
<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.str.split.html" rel="nofollow noreferrer"><strong>^{<cd3>}</strong></a></p>
^{pr2}$
<p><strong><code>numpy</code></strong><br/>
<a href="https://docs.scipy.org/doc/numpy-1.12.0/reference/generated/numpy.core.defchararray.split.html" rel="nofollow noreferrer"><strong>^{<cd5>}</strong></a></p>
<pre><code>splits = np.core.defchararray.split(df.Salary.values.astype(str), '-')
df.assign(Salary=np.array([x[0] for x in splits], dtype=float))
Salary
0 200.0
1 500.0
2 600.0
</code></pre>