Community & Support
Learn
Marketplace
Discussions
Categories
Discussions
General
Platform
Academic
Partner
Regional
User Groups
Documentation
Events
Altair Exchange
Share or Download Projects
Resources
News & Instructions
Programs
YouTube
Employee Resources
This tab can be seen by employees only. Please do not share these resources externally.
Groups
Join a User Group
Support
Altair RISE
A program to recognize and reward our most engaged community members
Nominate Yourself Now!
Home
Discussions
Community Q&A
Splitting the user review comment in excel into sentences while keeping sentiment_score
HeikoeWin786
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
Find more posts tagged with
AI Studio
Excel
Sentiment Analysis
Accepted answers
kayman
One way is to split the sentence first and then de-pivot as in the attached example.
split_by_sentence.rmp
All comments
kayman
One way is to split the sentence first and then de-pivot as in the attached example.
split_by_sentence.rmp
HeikoeWin786
@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,
Heikoe
Quick Links
All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)
Groups
