[SOLVED]Question about Process txt file
wujiang
New Altair Community Member
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!
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!
Tagged:
0
Answers
-
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,
Marco0 -
It works !!! Thank you very much.
0
