擅长:python、mysql、java
<p>类似于<a href="https://stackoverflow.com/a/52761490/9209546">@jezrael's</a>的解决方案,但是可以使用<a href="https://docs.python.org/3/library/collections.html#collections.ChainMap" rel="nofollow noreferrer">^{<cd1>}</a>代替创建新字典:</p>
<pre><code>from collections import ChainMap
# dataframe setup
df = pd.DataFrame({'col1': ['Non Profit', 'Other-501c3', '501c3', 'Sole Proprietor']})
# create ChainMap
L1 = ['Non Profit', 'Other-501c3', '501c3','NON-Profit', 'Not-for-profit']
L2 = ['Sole Proprietor','Sole Proprietorship']
d = ChainMap(dict.fromkeys(L1, 'non-profit'), dict.fromkeys(L2, 'Sole Proprietor'))
# map values
df['new'] = df['col1'].map(d.get)
print(df)
col1 new
0 Non Profit non-profit
1 Other-501c3 non-profit
2 501c3 non-profit
3 Sole Proprietor Sole Proprietor
</code></pre>