Options
Splitting the user review comment in excel into sentences while keeping sentiment_score
HeikoeWin786
Member Posts: 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
-
Options
kayman
Member Posts: 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!!
thanks much once again for explanation.
regards,
Heikoe