🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Problem with import of excel file

User: "LeMarc"
New Altair Community Member
Updated by Jocelyn
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!

Find more posts tagged with

Sort by:
1 - 5 of 51
    @LeMark,
    Hello

    Could you please take an screenshot from "sales"?

    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
    User: "LeMarc"
    New Altair Community Member
    OP
    Hi, problem is solved. I changed the format of column sales. Thanks!
    User: "Telcontar120"
    New Altair Community Member
    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.

    User: "LeMarc"
    New Altair Community Member
    OP
    @Telcontar120 Thanks for the hint!