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.

Problem with import of excel file

LeMarcLeMarc Member Posts: 72 Contributor II
edited June 2020 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:

Answers

  • sara20sara20 Member Posts: 110 Unicorn
    @LeMark,
    Hello

    Could you please take an screenshot from "sales"?

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,525 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
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • LeMarcLeMarc Member Posts: 72 Contributor II
    Hi, problem is solved. I changed the format of column sales. Thanks!
  • Telcontar120Telcontar120 RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635 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
  • LeMarcLeMarc Member Posts: 72 Contributor II
    @Telcontar120 Thanks for the hint!
Sign In or Register to comment.