soundex¶
In [ ]:
soundex(expr1,)
Returns the Soundex encoding of varchar strings as a four-character string.
Parameters¶
| Name | Type | Optional | Description |
|---|---|---|---|
expr | object | ❌ | Expression. |
In [6]:
from verticapy import *
df = tablesample({"x": ['hello', 'apple', 'heroes', 'allo']}).to_vdf()
display(df)
 | Abc xVarchar(6) |
| 1 | hello |
| 2 | apple |
| 3 | heroes |
| 4 | allo |
Rows: 1-4 | Column: x | Type: varchar(6)
In [8]:
# Importing the stats module
import verticapy.stats as st
# Applying the week function
df["soundex_x"] = st.soundex(df["x"],)
display(df)
| Abc xVarchar(6) | Abc soundex_xVarchar(4) |
| 1 | hello | H400 |
| 2 | apple | A140 |
| 3 | heroes | H620 |
| 4 | allo | A400 |
Rows: 1-4 | Columns: 2