4.34 dist - Distance

Format: dist(type, $num_1,num_2,\cdots ,n_ k,num_{k+1},num_{k+2},\cdots ,num_{2k}$ )

Compute the distance between two dimension vectors ( $num_1,num_2,\cdots ,n_ k),(num_{k+1},num_{k+2},\cdots ,num_{2k}$ ). Refer to msim for detailed definitions.

euclid: Euclidean distance
cityblock: City Block distance
hamming: Hamming distance

Hamming distance must be specified in character string format(refer to the example below).

Examples

Example 1: Euclidean distance

$ more dat1.csv
id,x1,y1,x2,y2
1,0,0,1,1
2,0,1,2,0
3,,,,
$ mcal c='dist("euclid",${x1},${y1},${x2},${y2})' a=rsl i=dat1.csv o=rsl1.csv
#END# kgcal a=rsl c=dist("euclid",${x1},${y1},${x2},${y2}) i=dat1.csv o=rsl1.csv
$ more rsl1.csv
id,x1,y1,x2,y2,rsl
1,0,0,1,1,1.414213562
2,0,1,2,0,2.236067977
3,,,,,

Example 2: City Block distance

$ mcal c='dist("cityblock",${x1},${y1},${x2},${y2})' a=rsl i=dat1.csv o=rsl2.csv
#END# kgcal a=rsl c=dist("cityblock",${x1},${y1},${x2},${y2}) i=dat1.csv o=rsl2.csv
$ more rsl2.csv
id,x1,y1,x2,y2,rsl
1,0,0,1,1,2
2,0,1,2,0,3
3,,,,,

Example 3: Hamming distance

Hamming distance must be specified in character string format for the calculation of Hamming distance.

$ more dat2.csv
id,x1,y1,x2,y2
1,a,b,a,c
2,0,1,0,1
3,,,,
$ mcal c='dist("hamming",$s{x1},$s{y1},$s{x2},$s{y2})' a=rsl i=dat2.csv o=rsl3.csv
#END# kgcal a=rsl c=dist("hamming",$s{x1},$s{y1},$s{x2},$s{y2}) i=dat2.csv o=rsl3.csv
$ more rsl3.csv
id,x1,y1,x2,y2,rsl
1,a,b,a,c,1
2,0,1,0,1,2
3,,,,,