The Altair Community is migrating to a new platform to provide a better experience for you. The RapidMiner Community will merge with the Altair Community at the same time. In preparation for the migration, both communities are on read-only mode from July 15th - July 24th, 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.
Options

Import Data Mismatched

hongxiangyhongxiangy Member Posts: 3 Contributor I
edited November 2018 in Help

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!ID in excel.pngID in RapidMiner.png

Best Answer

  • Options
    zprekopcsakzprekopcsak RapidMiner Certified Expert, Member Posts: 47 Guru
    Solution Accepted

    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
    624764543663741950

     

     

    and open it in Excel then it will show it as

    id
    802334127760489000
    624764543663741000

    Tested with Excel 2016 for Mac.

     

Answers

  • Options
    qwertz2qwertz2 Member Posts: 49 Guru

     

    Please post your excel file and the XML code of your process.

  • Options
    Thomas_OttThomas_Ott RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,761 Unicorn

    Is your excel column using Rounding?

  • Options
    hongxiangyhongxiangy Member Posts: 3 Contributor I

    Thanks. Below is the XML code and I've attached part of the excel file. 


    @qwertz2 wrote:

     

    Please post your excel file and the XML code of your process.




  • Options
    hongxiangyhongxiangy Member Posts: 3 Contributor I

    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.

Sign In or Register to comment.