擅长:python、mysql、java
<p>从前面的问题,使用<code>replace</code>,关于它为什么工作,您可以检查<a href="https://stackoverflow.com/questions/46944650/replace-value-by-using-regex-to-np-nan">link</a></p>
<pre><code>s=df.Borough.replace(dict(zip(l,[1,2,3,4,5])),regex=True)
pd.to_numeric(s,errors = 'coerce').fillna(0).astype(int)
Out[44]:
0 3
1 5 # notice here still change to 5
2 1
3 2
4 0
Name: Borough, dtype: int32
</code></pre>
<hr/>
<p>数据输入</p>
<pre><code>df = pd.DataFrame({
'Borough': ['QUEENS', 'BRONX 777', 'MANHATTAN', 'BROOKLYN', 'INVALID']})
l = ['MANHATTAN', 'BROOKLYN', 'QUEENS', 'STATEN ISLAND','BRONX']
</code></pre>