The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 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

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, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,533 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.