read document with excel sheet

fafa
fafa New Altair Community Member
edited November 5 in Community Q&A
i have text in excel sheet how i can do stemming then write in author excel sheet . i try with read document then process document and write document but the read does not work . 

Answers

  • kayman
    kayman New Altair Community Member
    In order to work with text it is important that the process flow knows what your text field is.
    Rapidminer considers any 'string data' as nominal by default, not as the unstructured text (document) you might expect so if you don't clearly state this the document process will happily ignore all of your data indeed. 

    Therefore the steps to take are as follows : 
    -> Import your excel file
    -> Change the field you like to do stemming on from nominal to text, either during import using the wizard or afterwards using the nominal to text operator
    -> now run your document conversion workflow (tokenisation / stemming etc)
    -> safe back as excel

    Hope this helps