Python提取中文关键词

读取数据库中指定属性列中的元素，使用使用TF-idf方式提取关键词，然后将关键词更新到数据库特定列

from jieba.analyse import *
import pymysql
from idlelib.sidebar import EndLineDelegator
with open('sample.txt') as f:
    data = f.read()
db = pymysql.connect("localhost", "root", "szj123456", "demo")
cursor = db.cursor()
sql = "select id,成果简介 from finalresult"
try:
    cursor.execute(sql)
    results = cursor.fetchall()
except:
    print ("Error: unable to fetch data")
for i in results:
    str2 = ""
#     print(i[0])
    str = extract_tags(i[1], topK=3, withWeight=False)
    for j in str:
        str2 = str2 + j + "	"
    sql2 = "update finalresult set 关键词 = '{}' WHERE id = '{}' ".format(str2, i[0])
    cursor.execute(sql2)
    db.commit()
    print(i[0])

参考：https://www.jianshu.com/p/cf383fd471bb