Message Boards Message Boards

1
|
5167 Views
|
2 Replies
|
3 Total Likes
View groups...
Share
Share this post:

[?] Avoid importing existing data as missing data?

Hello, Community

I have imported data from a csv file using the following code:

data = SemanticImport[ "C:\\Users\\Thadeu\\Documents\\Kaggle\\train.csv"]

When I investigate the imported data, I see missing values on the DataSet (house$size for example) enter image description here

that are not missing from the original data (notice house$size and nbaths as well) enter image description here

What's going on? Is it possible to fix it?

Thanks, Thad

2 Replies

It probably has decided that that is an integer column based on the first or first few lines, and it won't import a floating point number like 1.5 as it doesn't fit that column's data type. Try specifying column types manually.

POSTED BY: Szabolcs Horvát

Thanks, Szabolcs

I specified column types manually and it worked fine.

Cheers,

Thad

Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Reply Preview
Attachments
Remove
or Discard

Group Abstract Group Abstract