Problem with import of excel file

New Altair Community Member

Updated Nov 5, 2024 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

Banned

@LeMark,
Hello

Could you please take an screenshot from "sales"?

Altair Employee

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

New Altair Community Member

OP

Hi, problem is solved. I changed the format of column sales. Thanks!

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.

New Altair Community Member

OP

@Telcontar120 Thanks for the hint!

Quick Links