Splitting the user review comment in excel into sentences while keeping sentiment_score
HeikoeWin786
MemberPosts:64
Contributor II
Dear all,
I have a dataset which has review field and sentiment_score field, in excel format.
I want to split the reviews into sentences but keep the sentiment_score as assigned, and generate ID for each sentence.
Can anyone please recommend me how I can achieve that?
Thanks much in advance.
Heikoe
I have a dataset which has review field and sentiment_score field, in excel format.
I want to split the reviews into sentences but keep the sentiment_score as assigned, and generate ID for each sentence.
Can anyone please recommend me how I can achieve that?
Thanks much in advance.
Heikoe
Tagged:
0
Best Answer
-
kayman
MemberPosts:662
Unicorn
One way is to split the sentence first and then de-pivot as in the attached example.5
Answers
This work like a charm
I had customized with my dataset and all looks good!!
对explana多再次表示感谢tion.
regards,
Heikoe