python数据帧中的子字符串

import pandas as pd

# 创建一个示例数据帧
df = pd.DataFrame({'col1': ['apple', 'banana', 'orange'],
                   'col2': ['cat', 'dog', 'elephant'],
                   'col3': ['apple pie', 'banana bread', 'orange juice']})

# 使用str.contains()方法检查包含子字符串的单元格
result = df.apply(lambda x: x.str.contains('apple'))

print(result)

    col1   col2   col3
0   True  False   True
1  False  False  False
2  False  False  False

import pandas as pd

# 创建一个示例数据帧
df = pd.DataFrame({'col1': ['apple', 'banana', 'orange'],
                   'col2': ['cat', 'dog', 'elephant'],
                   'col3': ['apple pie', 'banana bread', 'orange juice']})

# 使用str.extract()方法提取子字符串
result = df.apply(lambda x: x.str.extract('(app\w+)'))

print(result)

     col1 col2   col3
0   apple  NaN  apple
1     NaN  NaN    NaN
2     NaN  NaN    NaN

import pandas as pd

# 创建一个示例数据帧
df = pd.DataFrame({'col1': ['apple', 'banana', 'orange'],
                   'col2': ['cat', 'dog', 'elephant'],
                   'col3': ['apple pie', 'banana bread', 'orange juice']})

# 使用str.findall()方法查找子字符串
result = df.apply(lambda x: x.str.findall('(app\w+)'))

print(result)

       col1 col2      col3
0   [apple]   []   [apple]
1        []   []        []
2        []   []        []