🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Problem with sentiment analysis

User: "regina_moser"
New Altair Community Member
Updated by Jocelyn

I've got a problem with the Sentiment Analysis by Aylien. I chose the Read Excel Operator and the Analyze Sentiment Operator but it doesn't work. You can see my problem in the screenshot. Maybe anyone already had the same problem and can help me.

 

Thanks a lot.

ReginaBildschirmfoto 2018-01-29 um 19.01.59.png

 

Find more posts tagged with

Sort by:
1 - 9 of 91
    User: "Thomas_Ott"
    New Altair Community Member
    Accepted Answer

    The warning is telling you that the data you are passing from Read Excel operator to the Analyze Sentiment operator is not in document form (i.e. DOC). You will likely need to use a Data to Documents operator betwen the two.

    User: "sgenzer"
    Altair Employee

    hello @regina_moser welcome to the community! I'd recommend posting your XML process here (see https://youtu.be/KkgB5QXWXJ8 and "Read Before Posting" on right when you reply) and attach your dataset. This way we can replicate what you're doing and help you better.

    Scott

    User: "regina_moser"
    New Altair Community Member
    OP

    Thank you @Thomas_Ott. I added the Operator you recommended to me but now when I run the process it works until the Analyse Sentiment Operator but it doesn't finish. When I end the process I get the message you can see in the Screenshot. Maybe you can help me one more time? :)

     

    Thank you in advance.Bildschirmfoto 2018-01-30 um 19.05.47.png

    User: "Thomas_Ott"
    New Altair Community Member

    That might because of something on the Aylien side. Not sure what the warning means, did you use up all your API limit?

    User: "regina_moser"
    New Altair Community Member
    OP

    Hello @sgenzer I followed the tutorial you recommended to me. Here's my XML process.

    <?xml version="1.0" encoding="UTF-8"?><process version="8.0.001">
    <operator activated="true" class="read_excel" compatibility="8.0.001" expanded="true" height="68" name="Read Excel" width="90" x="112" y="34">
    <parameter key="excel_file" value="/Users/reginamoser/Desktop/jan17-sep17.xls"/>
    <parameter key="sheet_number" value="1"/>
    <parameter key="imported_cell_range" value="A1:J8860"/>
    <parameter key="encoding" value="SYSTEM"/>
    <parameter key="first_row_as_names" value="false"/>
    <list key="annotations">
    <parameter key="0" value="Name"/>
    </list>
    <parameter key="date_format" value=""/>
    <parameter key="time_zone" value="SYSTEM"/>
    <parameter key="locale" value="German (Austria)"/>
    <list key="data_set_meta_data_information">
    <parameter key="0" value="RATING_ID.true.integer.attribute"/>
    <parameter key="1" value="TITLE.true.polynominal.attribute"/>
    <parameter key="2" value="FREE_TEXT.true.polynominal.attribute"/>
    <parameter key="3" value="BUSINESS_KEY.true.polynominal.attribute"/>
    <parameter key="4" value="VERIFIED.true.integer.attribute"/>
    <parameter key="5" value="REASON.true.polynominal.attribute"/>
    <parameter key="6" value="BRAND.true.polynominal.attribute"/>
    <parameter key="7" value="OVERALL_RATING.true.integer.attribute"/>
    <parameter key="8" value="RECOMMEND.true.integer.attribute"/>
    <parameter key="9" value="VIN.true.polynominal.attribute"/>
    </list>
    <parameter key="read_not_matching_values_as_missings" value="true"/>
    <parameter key="datamanagement" value="double_array"/>
    <parameter key="data_management" value="auto"/>
    </operator>
    </process>
    <?xml version="1.0" encoding="UTF-8"?><process version="8.0.001">
    <operator activated="true" class="text:data_to_documents" compatibility="7.5.000" expanded="true" height="68" name="Data to Documents" width="90" x="313" y="34">
    <parameter key="select_attributes_and_weights" value="false"/>
    <list key="specify_weights"/>
    </operator>
    </process>
    <?xml version="1.0" encoding="UTF-8"?><process version="8.0.001">
    <operator activated="true" class="com.aylien.textapi.rapidminer:aylien_document_sentiment" compatibility="0.2.000" expanded="true" height="82" name="Analyze Sentiment" width="90" x="447" y="34">
    <parameter key="connection" value="Aylien"/>
    <parameter key="sentiment_mode" value="document"/>
    </operator>
    </process>

    Maybe you can help me now?

     

    thank you in advance.

     

    Best regards,

    Regina

    User: "sgenzer"
    Altair Employee

    hmm that's not valid XML code. Did you just copy and paste the whole thing once?  Maybe please try again?

     

    Scott

     

     

     

     

    User: "Thomas_Ott"
    New Altair Community Member

    Don't select the process, copy and paste. Enable your XML view, then select the actual XML code, copy and paste here. 

    User: "regina_moser"
    New Altair Community Member
    OP

    I finally managed it to quit the process successfully.

    Now I have one more question, is it possible to make an excel export from the results?

    I've got IOObjectCollection as a result.

     

    Thank you in advance & best regards,

    Regina

    User: "sgenzer"
    Altair Employee

    hi @regina_moser - sure you can. Just use Documents to Data, followed by Write Excel.


    Scott