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

User: "HeikoeWin786"
New Altair Community Member
Updated by Jocelyn
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

Sort by:
1 - 2 of 21
    User: "kayman"
    New Altair Community Member
    Accepted Answer
    One way is to split the sentence first and then de-pivot as in the attached example.
    User: "HeikoeWin786"
    New Altair Community Member
    OP
    @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