Options

[SOLVED]Question about Process txt file

wujiangwujiang Member Posts: 12 Contributor II
edited November 2018 in Help
Hello,

I have "txt" file like this:
1 3 9 13 23 25 34 36 38 40 52 54 59 63 67 76 85 86 90 93 98 107 113
2 3 9 14 23 26 34 36 39 40 52 55 59 63 67 76 85 86 90 93 99 108 114
2 4 9 15 23 27 34 36 39 41 52 55 59 63 67 76 85 86 90 93 99 108 115
1 3 10 15 23 25 34 36 38 41 52 54 59 63 67 76 85 86 90 93 98 107 113
2 3 9 16 24 28 34 37 39 40 53 54 59 63 67 76 85 86 90 94 99 109 114
... ...

what I want is read this file like I use "ReadCSV" to read a csv file. After read this file, I want get a table like:
             att1  att2 att3  att4  ... ...
ROW 1: 1       3     9     13    23 25 34 36 38 40 52 54 59 63 67 76 85 86 90 93 98 107 113
ROW 2: 2       3     9     14    23 26 34 36 39 40 52 55 59 63 67 76 85 86 90 93 99 108 114
... ...

I think it is the same thing as read a CSV file by "ReadCSV" but , the probleme is the format of my file is "txt". I used the "Read Document", but I don't know
how can I generate a "table" with "attribute, label ..."

The reason why I ask this question is that I am doing a project to add a algorithm about (association rule) in rapidminer, my adviser require me use a "more general format file" like  "txt file" as my Data source. after read this "txt" file, I can get  "exampleSet"s to do flowing thing I think  ???.

Thanks in advance!

Answers

  • Options
    Marco_BoeckMarco_Boeck Administrator, Moderator, Employee, Member, University Professor Posts: 1,993 RM Engineering
    Hi,

    you can use the "Read CSV" operator anyway. Just open the import wizard, select "All files" and chose your .txt file and click Next. On the second step, chose "Space" as column separator. Then you are pretty much done.

    Regards,
    Marco
  • Options
    wujiangwujiang Member Posts: 12 Contributor II
    It works !!! Thank you very much. :D:D:D
Sign In or Register to comment.