我是python新手,我使用excel来执行此操作,但我的数据越来越大,我想用python来做,因为它更快。
我有一个数组的str,我想提取如果str的细胞包含一个数组提取str。
我在excel中使用索引匹配
=INDEX(results,MATCH(TRUE,ISNUMBER(SEARCH(things,A1)),0))
results = array of values that i want to be extracted
search = str to search in the cell
简化一下,
x =[狗,猫,狮子]
我想要一个在属性
中搜索x的函数output
1 a quick brown FALSE
2 cute dog puppy dog
3 nice cat cat
4 he saw a lion lion
请注意,左和右修剪不起作用,因为在搜索值的列中没有模式。
编辑:
import pandas as pd
data = ['sukuna', 'vessel', 'itadori', 'megumi']
df = pd.Series(data)
def t(x):
for item in ['uku', 'ita', 'egu', 'rrr']:
if item in x:
return item
return False
print(df.apply(t))
output:
0 uku
1 False
2 False
3 False
dtype: object
import pandas as pd
data = pd.Series(["a quick brown", "cute dog puppy", "nice cat", "he saw a lion"])
def t(x):
for item in ["dog", "cat", "lion"]:
if item in x:
return item
return False
print(data)
print(data.apply(t))