The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
"Read CSV with correctly guessed types"
Learner III
Hello,
first of all i have to say that RapidMiner is really great! Its really nice to work with it.
I have a small problem with importing CSV files, i followed the tutorial video and it works fine (creating a data table in the repository). But this way the data is static and does not get updates of the original file. So my question is, is there a way to update the repository data table?
I tried to workaround it, by loading the CSV directly but this way the datatypes are incorrect (integer everywhere). Is this normal? Which operator does the import wizard apply to get the correct types? I tried guess types but it does not work.
Regards
Jonas
first of all i have to say that RapidMiner is really great! Its really nice to work with it.
I have a small problem with importing CSV files, i followed the tutorial video and it works fine (creating a data table in the repository). But this way the data is static and does not get updates of the original file. So my question is, is there a way to update the repository data table?
I tried to workaround it, by loading the CSV directly but this way the datatypes are incorrect (integer everywhere). Is this normal? Which operator does the import wizard apply to get the correct types? I tried guess types but it does not work.
Regards
Jonas
Tagged:
0
Answers
the import wizard as well as the read csv operator will be greatly improved in the upcoming 5.1 version.
The current implementation searches the first 1000 lines of your data and guesses the value types by choosing the most specific common type. Might it be the case, that the first 1000 lines of your csv file are all integer?
Greetings,
Sebastian