擅长:python、mysql、java
<p>下面是一个基于一些虚构数据的例子。别理我在数据帧里放的那些废话,我只是随便输入一些东西来获取一个df样本。在</p>
<pre><code>import pandas as pd
import re
x = pd.DataFrame({'Location': ['Chicago','Houston','Los Angeles','Boston','NYC','blah'],
'Comments': ['chicago is winter','la is summer','boston is winter','dallas is spring','NYC is spring','seattle foo'],
'Dir': ['N','S','E','W','S','E']})
y = pd.DataFrame({'Location': ['Miami','Dallas'],
'Season': ['Spring','Fall']})
def findval(row):
comment, location, season = map(lambda x: str(x).lower(),row)
return location in comment or season in comment
merged = pd.concat([x,y])
merged['Helper'] = merged[['Comments','Location','Season']].apply(findval,axis=1)
print(merged)
filtered = merged[merged['Helper'] == True]
print(filtered)
</code></pre>
<p>您可以不连接数据帧,然后创建一个助手来查看一列的字符串是否在另一列中找到。一旦有了helper列,只需过滤掉True</p>