RaqForum 43 No.
269 View  • 
     ...

Missing value analysis

 

Calculate the missing number and missing rate for each variable in Titanic data.

A

1

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

2

=A1.fname()

3

=A2.((y=~,A1.align@a([true,false],!eval(y))))

4

=A2.new(~:col,A3(#)(1).len():null_no,round(null_no/A1.len(),3):null_rate)

A2 Get field names

A3 The variables in A1 are divided into two groups according to whether they are missing

..

A4 Count the number and proportion of missing groups in A3, obtain the missing number and missing rate of each variable.

..


 
 •  269 View  •