擅长:python、mysql、java
<p>您可以使用如下迭代方法:</p>
<pre class="lang-py prettyprint-override"><code>def find_substr(employer, pincode):
employer = employer.set_index("employer")
for words in employer.index.map(str.split):
length = len(words)
found = False
while length > 0 and not found:
substr = ' '.join(words[:length]).replace('(', '\(')
mask = pincode.Name.str.contains(substr)
if mask.any():
employer.loc[' '.join(words), 'cat'] = pincode.loc[mask, 'FINAL_CATEGORY'].values[0]
found = True
length -= 1
employer = employer.reset_index()
return employer
employer = find_substr(employer, pincode)
print(employer)
</code></pre>
<pre><code> employer cat
0 wings brand activation i pvt ltd cat b
1 hofincons infotech &industrial services pvt .ltd NaN
2 bharat fritz werner bangalore NaN
3 kludi rak indpvt ltd NaN
</code></pre>