[?] Avoid importing existing data as missing data?

Questions
1

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)

reply1.JPG
reply1.JPG1026×234 42.2 KB

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

reply2.JPG

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

Thanks,
Thad

2

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.

3

Thanks, Szabolcs

I specified column types manually and it worked fine.

Cheers,

Thad