...

2.7 Distinct count

 
spl-cookbook(224)

Perform distinct count at summarizing data in a table sequence. Now we are trying to find the most suitable field for acting as the primary key.

PassengerId Survived Pclass Name Sex Age
1 0 3 “Braund, Mr. Owen Harris” male 22
2 1 1 “Cumings, Mrs. John Bradley” female 38
3 1 3 “Heikkinen, Miss. Laina” female 26
4 1 1 “Futrelle, Mrs. Jacques Heath” female 35
5 0 3 “Allen, Mr. William Henry” male 35
6 0 3 “Moran, Mr. James” male
7 0 1 “McCarthy, Mr. Timothy J” male 54
… … … … … …

SPL script:

A
1 =T(“titanic_train.xlsx”)
2 =A1.fno().new(A1.fname(~):Name,A1.field(~).icount():DCount)
3 =A2.select(DCount==A1.len())

A2 Use icount() function to count the non-duplicate members in each field.
A3 Get the field where the distinct count result is equivalent to the length of all members in each value.
 

spl-cookbook(224)
 
 •  167 View  •