Row/Attribute performance after importing (Missing rows and attributes)
Hello,
I have some text files to import to Rapid Miner. For samples:
- Total record: 1408866
- Column/Attribute: 71
* After importing the file into RapidMiner
- Total record: 148773 (missing 93 records)
2. I have another text file
- Total record: 287147
- Column/Attribute: 269
* After importing the file into RapidMiner
- Total record: 287109 (missing 38 records)
- Column/Attribute: 35
Then I was trying to re-import the file and uncheck "Skip comments". The first file remained the same, the second file showed the exact record but only 265 attributes.
Is there any problem with the importing feature? How can I get full rows/attributes always from the file?
Thank you.
Ut
Find more posts tagged with
You will have to use the Read CSV operator and go more to the manual import. Use the Import Wizard button on the Read CSV operator it self and then select ALL FILES in the dropdown box for the File Selector to select the TXT file. It should load just fine then and you can use the wizard to format it.
You will have to use the Read CSV operator and go more to the manual import. Use the Import Wizard button on the Read CSV operator it self and then select ALL FILES in the dropdown box for the File Selector to select the TXT file. It should load just fine then and you can use the wizard to format it.
What kind of file is this CSV?
Are you using the read csv operator or the import wizard
If using the read csv operator, on the last screen it has a checkbox to select first 100 rows for preview, uncheck that and see if you see errors or warnings at the bottom of the screen