擅长:python、mysql、java
<pre><code>dict = {'attmlk1': 'CWT', 'attmmma1': 'CWT', 'attanna1': 'CWT', 'attmsl1': 'RNJ', 'kyqang1': 'RNJ'}
def f(x):
x = str(x)
s = dict[x]
return s
value_list = ['attmlk1','attctl1']
df.loc[df.CREATEDBY.isin(value_list), 'Vendor'] =
df.loc[df.CREATEDBY.isin(value_list), 'CREATEDBY']
df['Vendor'] = df['Vendor'].apply(lambda x: f(x))
</code></pre>
<p><a href="https://i.stack.imgur.com/TokLn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TokLn.png" alt="key error " 'nan'"/></a></p>