RapidMiner 9.7 is Now Available

Lots of amazing new improvements including true version control! Learn more about what's new here.

CLICK HERE TO DOWNLOAD

Problem with import of excel file

LeMarcLeMarc Member Posts: 57 Contributor II
edited June 29 in Help
Hello,

I tried to import data from an excel file. However theres always an error message which says

"Failed to parse the content in column 'sales':
Cause: unpearsable real numbers:"-" "

Within the feature sale there are some values of 0.

Does anyone have a suggestion how to solve?

Thank you!

Tagged:

Comments

  • sara20sara20 Member Posts: 83  Guru
    @LeMark,
    Hello

    Could you please take an screenshot from "sales"?

    "لطفا تا پایان دوره کرونا از ماسک استفاده کنید"

    Regards
    Sara

    LeMarc
  • mschmitzmschmitz Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 2,462  RM Data Scientist
    seems like some of your "numbers" are rather something like 1-2?

    I would recommend to use "read all columns as polynominal" option and parse the numbers later.

    Best,
    Martin
    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
    LeMarc
  • LeMarcLeMarc Member Posts: 57 Contributor II
    Hi, problem is solved. I changed the format of column sales. Thanks!
  • Telcontar120Telcontar120 Moderator, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,408   Unicorn
    You may also have missing values or zero value represented by the hyphen "-" in which case you can use declare missing value or replace operator to solve that problem.

    Brian T.
    Lindon Ventures 
    Data Science Consulting from Certified RapidMiner Experts
    LeMarcmschmitz
  • LeMarcLeMarc Member Posts: 57 Contributor II
    @Telcontar120 Thanks for the hint!
Sign In or Register to comment.