在pandas单元格的列表中查找数字，并从第二个DF返回相应的字符串值

import pandas as pd

# 创建示例数据
data1 = {'Numbers': [[1, 2, 3], [4, 5, 6], [7, 8, 9]]}
data2 = {'Numbers': [2, 5, 8], 'Strings': ['String1', 'String2', 'String3']}
df1 = pd.DataFrame(data1)
df2 = pd.DataFrame(data2)

# 定义函数，用于在df2中查找相应的字符串值
def find_string(row):
    number = row['Numbers']
    string = df2[df2['Numbers'] == number]['Strings'].values[0]
    return string

# 在df1中应用函数，查找相应的字符串值
df1['Strings'] = df1['Numbers'].apply(lambda x: find_string({'Numbers': x}))

# 打印结果
print(df1)

   Numbers  Strings
0  [1, 2, 3]  String1
1  [4, 5, 6]  String2
2  [7, 8, 9]  String3