使用Python工具库SnowNLP对评论数据进行情感标注

评论数据comments.xlsx

安装snownlp

python -m pip install snownlp -i  https://pypi.tuna.tsinghua.edu.cn/simple/ 
1

from openpyxl import load_workbook
from snownlp import SnowNLP

wb1 = load_workbook("C:/Users/zhour/Documents/comments.xlsx")
ws1 = wb1.active
id=1
for row in ws1.iter_rows(min_row=1):
    values = [cell.value for cell in row]
    s = SnowNLP(values[0])
    ws1["{}{}".format('B', id)]=s.sentiments
    id+=1
wb1.save("C:/Users/zhour/Documents/commentsTag.xlsx")    


1
2
3
4
5
6
7
8
9
10
11
12
13
14

标注后的数据集commentsTag.xlsx