擅长:python、mysql、java
<p>使用<a href="https://docs.scipy.org/doc/numpy/reference/generated/numpy.select.html" rel="nofollow noreferrer">^{<cd1>}</a>和<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.isin.html" rel="nofollow noreferrer">^{<cd2>}</a></p>
<pre><code>m = ['CollgCr', 'Veenker']
l = ["Mitchel", "OldTown", "BrkSide", "Sawyer", "NAmes", "IDOTRR","MeadowV", "Edwards", "NPkVill", "BrDale", "SWISU", "Blueste"]
df['new_col'] = np.select([df.city.isin(l), df.city.isin(m)], ['lower', 'middle'], default='upper')
city new_col
0 CollgCr middle
1 Veenker middle
2 CollgCr middle
3 Crawfor upper
4 NoRidge upper
5 Mitchel lower
6 Somerst upper
7 NWAmes upper
8 OldTown lower
9 BrkSide lower
</code></pre>