Python商品分析

from aip import AipNlp

from openpyxl import load_workbook

APP_ID='…'

API_KEY='…'

SECRET_KEY='…'

client=AipNlp(APP_ID,API_KEY ,SECRET_KEY )

 

wb=load_workbook('京东评论按分类-好中差评.xlsx')

ws=wb.active

 

pos,mid,neg=0,0,0

for row in range(2,ws.max_row+1)

    comment=ws.cell(column=4,row=row).value

    option={}

    option['type']=11

    result=client.commentTag(comment,option)

    print("option:",result)

 

    if len(result['items'])==0:

        print('no comments')

    else:

        for view in result['items']:

            if view['sentiment']==2:

                print('positive information',view['prop'],view['adj'])

                pos+=1

            elif view['sentiment']==1:

                print('neutral information',view['prop'],view['adj'])

                mid+=1

            else:

                print('negative information',view['prop'],view['adj'])

                neg+=1

print("Total:",pos+mid+neg)

print('pos:total=',round(pos*100/(pos+mid+neg),2),'%')

print('mid:total=',round(mid*100/(pos+mid+neg),2),'%')

print('neg:total=',round(neg*100/(pos+mid+neg),2),'%')