Group Abstract Group Abstract

Message Boards Message Boards

0
|
11.1K Views
|
4 Replies
|
1 Total Like
View groups...
Share
Share this post:

[?] Delete missing values of a dataset?

Hello, Mathematica Community I have imported the following data as a DataSet into Mathematica enter image description here

and I'm trying to run the following Linear Model enter image description here

When I run the following code, I get all that missing data enter image description here

But I'm unable to select the rows with missing data enter image description here

Nothing shows up. Can someone please help me to select those rows and delete them? Because when I examine the original data, I can't find the rows with missing data either so I am curious to see Mathematica's output. Thank you in advance,

Thad
POSTED BY: Thadeu Freitas Filho
4 Replies
Sort By:

Thanks, Chris P I imported the data from a csv type format (filename = train.csv) using

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

I'll start a new question. Thanks
POSTED BY: Thadeu Freitas Filho

Thanks, Chris P And I think you are spot on because when I investigate further, I see missing values on the DataSet (house$size) enter image description here

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

What's going on? Do you know how I can fix this?

Thanks, Thad
POSTED BY: Thadeu Freitas Filho
Chris P
Chris P
Posted 8 years ago

If I understand well, the problem seems to be when you import the original data into Mathematica. I just remark that the missing nbaths value is a real (1.5) whereas all the others are integers (1) ...

Anyway, you should start a new question, telling precisely how you imported the data, what format the original data are, and give a minimal example.

-
POSTED BY: Chris P
Chris P
Chris P
Posted 8 years ago
POSTED BY: Chris P
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