在匹配列顺序不同时，根据部分字符串匹配合并来自另一个数据帧的值

import pandas as pd

# 创建两个数据帧
df1 = pd.DataFrame({'列A': ['abc123', 'def456', 'ghi789'],
                    '列B': [1, 2, 3]})
df2 = pd.DataFrame({'列C': ['123', '456', '789'],
                    '列D': ['value1', 'value2', 'value3']})

# 进行部分字符串匹配
merged_df = df1.merge(df2[df2['列C'].apply(lambda x: any(substring in x for substring in df1['列A']))],
                      left_on='列A', right_on=df2['列C'].apply(lambda x: any(substring in x for substring in df1['列A'])),
                      suffixes=('', '_merged'))

# 选择需要的列
merged_df = merged_df[['列A', '列B', '列D']]

print(merged_df)