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

  • 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

  • qwertz2qwertz2 Member Posts: 49 Guru

     

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

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

    Is your excel column using Rounding?

  • 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.




  • 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.