从两个数据帧中获取匹配字符串的索引

import pandas as pd
import numpy as np

df1 = pd.DataFrame({'Column1': ['apple', 'banana', 'orange', 'grape'],
                    'Column2': ['cat', 'dog', 'elephant', 'monkey']})

df2 = pd.DataFrame({'Column3': ['This is an apple', 'I like bananas', 'Orange juice', 'Grapes are tasty'],
                    'Column4': ['apple', 'banana', 'orange', 'grape']})

matching_indices = df2[df2['Column3'].str.contains('|'.join(df1['Column1']))].index

print(matching_indices)

import pandas as pd
import numpy as np

df1 = pd.DataFrame({'Column1': ['apple', 'banana', 'orange', 'grape'],
                    'Column2': ['cat', 'dog', 'elephant', 'monkey']})

df2 = pd.DataFrame({'Column3': ['This is an apple', 'I like bananas', 'Orange juice', 'Grapes are tasty'],
                    'Column4': ['apple', 'banana', 'orange', 'grape']})

matching_indices = df2[df2['Column3'].str.contains('|'.join(df1['Column1']))].index
print(matching_indices)

Int64Index([0, 1, 2, 3], dtype='int64')