从dataframe列获取最相似的值到特定的字符串python

import pandas as pd
from difflib import SequenceMatcher

# 创建示例DataFrame
df = pd.DataFrame({'column': ['apple', 'banana', 'orange', 'peach', 'pear']})
target = 'pen'

# 定义一个函数，用于计算字符串相似度
def similarity(s1, s2):
    return SequenceMatcher(None, s1, s2).ratio()

# 在DataFrame的column列中查找与target最相似的值
most_similar_value = max(df['column'], key=lambda x: similarity(x, target))