擅长:python、mysql、java
<p>定义一个字典,使得Key是您请求的结果,值是一个可能性列表。</strong></p>
<pre><code>my_dict = {"C-LEVEL":['CHIEF',"THE CHIEF","MY CHIEF"],"VP-SVP":['VP','PRODUCT VP']}
</code></pre>
<p>要使用虚拟数据:</p>
<pre><code>df=pd.DataFrame({"A":["CHIEF","MY CHIEF","VP","PRODUCT VP","THE CHIEF", "USER"]})
A
0 CHIEF
1 MY CHIEF
2 VP
3 PRODUCT VP
4 THE CHIEF
5 USER
</code></pre>
<p>创建搜索键的函数:</p>
<pre><code>def yourfunc(value):
for k,v in my_dict.items():
if value in my_dict.get(k):
return k
return "N/A"
</code></pre>
<p>最后,用lambda应用函数:</p>
<pre><code>df['Result'] = df['A'].apply(lambda x: yourfunc(x))
</code></pre>
<p>期望结果:</p>
<pre><code> A Result
0 CHIEF C-LEVEL
1 MY CHIEF C-LEVEL
2 VP VP-SVP
3 PRODUCT VP VP-SVP
4 THE CHIEF C-LEVEL
5 USER N/A
</code></pre>
<p>当您看到<strong>“N/A”</strong>结果时,您将知道您需要升级词典。你知道吗</p>