Splitting the user review comment in excel into sentences while keeping sentiment_score

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)