Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
Import Data Mismatched
hongxiangy
Member Posts: 3 Contributor I
When I was trying to import data from excel, and the id of the data shown in the RapidMiner is not matching the ones in excel. I've tried to change the type, however, it doesn't work.. Any idea why this is happening and how to solve the problme? Thanks!
0
Best Answer
-
zprekopcsak RapidMiner Certified Expert, Member Posts: 47 Guru
I did a quick test and this is actually an Excel data representation issue. If you create a CSV file including the following three lines:
id
802334127760489980
624764543663741950and open it in Excel then it will show it as
id
802334127760489000
624764543663741000Tested with Excel 2016 for Mac.
1
Answers
Please post your excel file and the XML code of your process.
Is your excel column using Rounding?
Thanks. Below is the XML code and I've attached part of the excel file.
Hi Thomas, I don't think the numbers are rounded in the excel file. I'm guessing the number is out of the range of the Rapidminer's "real number type"? Any idea how to fix the problem? Thanks a lot.