The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
Splitting the user review comment in excel into sentences while keeping sentiment_score
HeikoeWin786
Member Posts: 64 
Contributor I
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
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