Sentiment Analysis

LoloyLoloy Member Posts: 10 Learner I
Please, I need your help. I collected tweets and put them all in one excel sheet to make a sentiment analysis. Each time I try that, it shows me this message "Process failed. API Engine error: no content to analyze [212]. Can you pls help me? I would appreciate your guidance.

Answers

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,314 RM Data Scientist
    Hi,
    what exactly did you do to get this error?
    BR,
    Martin
    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
  • LoloyLoloy Member Posts: 10 Learner I
    Thanks so much, Martin. I collected tweets for a couple of months and stored them in an Excel sheet. And now, I want to do the sentiment analysis, but each time I try that, I get that error message. I tried to use all attributes as trials within the sentiment analysis parameters, but nothing worked. Please, I would appreciate your help. Thanks!

  • LoloyLoloy Member Posts: 10 Learner I
    Please @MartinLiebig let me know if you need any more information. Thanks!
  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,314 RM Data Scientist
    Hi,
    the error comes from the API the operator is calling, not from RM itself. I suppose you have either missing or empty lines in your text.

    Cheers,
    Martin
    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
  • LoloyLoloy Member Posts: 10 Learner I
    edited January 17
    Thanks so much @MartinLiebig .Yeah, there are missing and empty lines. It is big data. So I tried to make auto cleaning in RapidMiner, but it didnt work out. Also, I tried to do the cleaning within the excel sheet by following these steps : 

    Removing Blank Rows with Find & Select

    1. Click Find & Select.
    2. Click to Go to Special.
    3. Choose Blanks.
    4. Click OK, and then all the blank rows/cells will be highlighted.
    5. Choose the Delete under Cells section on the Home Tab.
    6. Click Delete Sheet Rows.

    But the cleaning did not work properly; it took days, and even after, the excel keeps showing that it is not responding. 


    Please, is there any way to clean my dataset properly to be able to run "Sentiment analysis"? Please, I would appreciate your help.


  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,314 RM Data Scientist
    Hi @Loloy ,
    did you try to use Filter Examples and remove all missing examples? Maybe also use trim first.

    BR,
    Martin
    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
  • LoloyLoloy Member Posts: 10 Learner I
    Pls @MartinLiebig Something like that ? unfortunately it did not work as well

    23.png 43.7K
  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,314 RM Data Scientist
    Hi,
    how did you configure your Filter Examples?

    BR,
    Martin
    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
  • LoloyLoloy Member Posts: 10 Learner I
    Thanks so much @MartinLiebig . It seems that I am putting in the wrong filters. I tried a random filter, and it worked, but I got the wrong results as it shows only 18 tweets. Pls, Can you help me to know the right filter? lp me

  • LoloyLoloy Member Posts: 10 Learner I
    and pls @MartinLiebig do you mean by "Filter example configuration " by filter examples rules or something else?

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,314 RM Data Scientist
    I would try
    text is not missing
    first.

    Best,
    Martin
    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
  • LoloyLoloy Member Posts: 10 Learner I
    edited January 19
    Unfortunately, it did not work. Pls @MartinLiebig what do you think 


  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,314 RM Data Scientist
    Hi,
    did you try to use the trim operator before, as suggested earlier?
    BR,
    Martin
    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
  • LoloyLoloy Member Posts: 10 Learner I
    edited January 19
    It did not work. I am trying it again now. Pls @MartinLiebig What is the right attribute filter type ?
  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,314 RM Data Scientist
    Hi,
    please use trim on your attribute and read the documentation of trim.

    Best,
    Martin
    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
    Loloy
  • LoloyLoloy Member Posts: 10 Learner I
    I will go through the documentation, give it another try, and keep you updated. Thanks a lot @MartinLiebig
Sign In or Register to comment.