Splitting the user review comment in excel into sentences while keeping sentiment_score
HeikoeWin786
New Altair Community Member
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
-
One way is to split the sentence first and then de-pivot as in the attached example.5
Answers
-
One way is to split the sentence first and then de-pivot as in the attached example.5
-
@kayman
This work like a charm
Thanks a lot for all your know-how!!
I had customized with my dataset and all looks good!!
thanks much once again for explanation.
regards,
Heikoe0