Group Abstract Group Abstract

Message Boards Message Boards

1
|
7.1K 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
POSTED BY: Thadeu Freitas Filho
2 Replies
Sort By:
POSTED BY: Thadeu Freitas Filho

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
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Tag limit exceeded
Note: Only the first five people you tag will receive an email notification; the other tagged names will appear as links to their profiles.
Reply Preview
Attachments
Remove
or Discard