jaro_winkler_distance¶

In [ ]:

jaro_winkler_distance(expr1, 
                      expr2,)

Calculates and returns the Jaro-Winkler distance between two strings.

Parameters¶

Name	Type	Optional	Description
expr1	object	❌	Expression.
expr2	object	❌	Expression.

Returns¶

str_sql : SQL expression.

Example¶

In [10]:

from verticapy import *
df = tablesample({"x": ['hello', 'apple', 'heroes', 'allo']}).to_vdf()
display(df)

	Abc x Varchar(6)
1	hello
2	apple
3	heroes
4	allo

Rows: 1-4 | Column: x | Type: varchar(6)

In [11]:

# Importing the stats module
import verticapy.stats as st

# Applying the week function
df["jaro_winkler_distance_x"] = st.jaro_winkler_distance(df["x"], 'heyllow')
display(df)

	Abc x Varchar(6)	123 jaro_winkler_distance_x Float(22)
1	hello	0.923809523809524
2	apple	0.447619047619048
3	heroes	0.714285714285714
4	allo	0.726190476190476

Rows: 1-4 | Columns: 2