擅长:python、mysql、java
<p>一种方法是将<code>pd.Series.apply</code>与自定义函数和<code>for</code>循环一起使用:</p>
<pre><code>def lookup_prod(ip):
for row in df2.itertuples():
if ip in row[1]:
return row[2]
else:
return 'N/A'
df1['AttrName'] = df1['Product'].apply(lookup_prod)
print(df1)
# ACNo Product AttrName
# 1 12340 HotCare Recipe
# 2 23867 Auction N/A
# 3 98372 Edition Amount
# 4 9837 DietParameter N/A
# 5 54332 Load N/A
</code></pre>
<hr/>
<p><strong>示例2</strong></p>
<p>此方法仍然有效:</p>
^{pr2}$