11.11英文识别推荐

import pandas as pd
from sklearn.feature_extraction.text import TfidfVectorizer
from sklearn.metrics.pairwise import linear_kernel

# 示例数据
data = {
    'product_id': [1, 2, 3],
    'description': ['English learning book', 'Travel guide in English', 'English dictionary']
}
df = pd.DataFrame(data)

# 使用TF-IDF向量化描述
tfidf = TfidfVectorizer(stop_words='english')
df['description'] = df['description'].fillna('')
tfidf_matrix = tfidf.fit_transform(df['description'])

# 计算相似度
cosine_sim = linear_kernel(tfidf_matrix, tfidf_matrix)

# 推荐函数
def get_recommendations(title, cosine_sim=cosine_sim):
    idx = df.index[df['description'] == title].tolist()[0]
    sim_scores = list(enumerate(cosine_sim[idx]))
    sim_scores = sorted(sim_scores, key=lambda x: x[1], reverse=True)
    sim_scores = sim_scores[1:3]  # 获取最相似的两个产品
    product_indices = [i[0] for i in sim_scores]
    return df['product_id'].iloc[product_indices]

# 示例调用
print(get_recommendations('English learning book'))