擅长:python、mysql、java
<p>这里有一个方法。你知道吗</p>
<p>首先将您的pin df转换成一个字典,将字符串映射到相应的类别。然后使用双列表创建雇员数据框的cat列,以记录与其姓名匹配的所有类别:</p>
<pre><code># Example df
employer = pd.DataFrame({"employer":["wings brand activation i pvt ltd", "bharat fritz werner bangalore"]})
pins = pd.DataFrame({"Name":["trendy wheels pvt ltd", "wings brand activation i pvt ltd"], "FINAL_CATEGORY":["cat a+", "cat b"]})
dict_pins = dict(zip(pins['Name'], pins['FINAL_CATEGORY']))
employer['cat'] = [[dict_pins[key] for key in dict_pins.keys() if x in key] for x in employer['employer']]
</code></pre>
<hr/>
<p>输出:</p>
<pre><code> employer cat
0 wings brand activation i pvt ltd [cat b]
1 bharat fritz werner bangalore []
</code></pre>