"Question regarding text mining tutorial: problems with reading .txt file"

Hello,

I am a newbie to this and I've been studying text mining tutorial video posted by Rapidminer on youtube. (https://www.youtube.com/watch?v=VbNhvYQZ2v0&t=717s)

However, when I used the operation of import configuration wizard in reading csv, I was unable to read the .txt file properly i.e. my result is different from what's shown on the youtube video, which there are two attributes, one is the review and the other is the sentimental score. (please see the picture below)

I tried changing the file enconding; nevertheless, it still does not work. Moreover, when I uncheck the 'use quotes', it turned out that there's no data found.

Could anyone help me with this problem?

Thank you in advance,

Find more posts tagged with

AI Studio

Text Mining + NLP

Tutorials + Training

Accepted answers

All comments

kayman

could you share (a part of) your txt file?

Seems there is a clear issue with your separator, are you sure it is comma delimited?

doubleuax2

Sure, I downloaded from it from here, and I used the first amazon file. (.txt.ioo) For the seperators, I tried changing all of them; however, the data still showed a lot of symbols.