RaqForum 43 No.
264 View  • 
     ...

Delete missing value

 

For example, in the Titanic data, the field Embarked has two missing values, so the missing sample can be deleted directly

A

1

=file("D://titanic.csv").import@qtc()

2

=A1.select(Embarked==null)

3

=A1.delete(A2)

A2 Select the samples with Embarked missing information. We can see that only two passengers, number 62 and number 830, are missing port information

..

A3 Delete A2 from A1

It should be noted that the method of directly deleting will lose information and lead to deviation of data distribution, so it is not commonly used, and more cases are filled with missing values. In this book we will introduce several common filling methods for readers' reference.


 
 •  264 View  •