StringMethods supported APIsΒΆ

The following table is structured as follows: The first column contains the method name. The second column is a flag for whether or not there is an implementation in Snowpark for the method in the left column.

Note

Y stands for yes, i.e., supports distributed implementation, N stands for no and API simply errors out, P stands for partial (meaning some parameters may not be supported yet), and D stands for defaults to single node pandas execution via UDF/Sproc.

StringMethods (Series.str)

Snowpark implemented? (Y/N/P/D)

Notes for current implementation

__getitem__

P

N if the key parameter is set to a non-int

scalar value.

capitalize

Y

casefold

N

cat

N

center

N

contains

P

N if the na parameter is set to a non-bool value.

count

Y

decode

N

encode

N

endswith

P

N if the na parameter is set to a non-bool value.

extract

N

extractall

N

find

N

findall

N

fullmatch

N

get

P

N if the i parameter is set to a non-int

value. Also non-string data values such as list and dict are not yet supported.

get_dummies

N

index

N

isalpha

N

isalnum

N

isdecimal

N

isdigit

P

Does not check for special digits, like superscripted and subscripted digits in unicode

islower

Y

isnumeric

N

isspace

N

istitle

Y

isupper

Y

join

N

len

P

Only string and list data values are supported. All column values must be of the same type.

ljust

N

lower

Y

lstrip

P

N if to_strip is non-string.

match

Y

normalize

N

pad

N

partition

N

removeprefix

N

removesuffix

N

repeat

N

replace

P

N if pat is non-string, repl is a non-string, or n is non-numeric or zero.

rfind

N

rindex

N

rjust

N

rpartition

N

rsplit

N

rstrip

P

N if to_strip is non-string.

slice

Y

slice_replace

N

split

P

N if pat is non-string, n is non-numeric, expand is set, or regex is set.

startswith

P

N if the na parameter is set to a non-bool value.

strip

P

N if to_strip is non-string.

swapcase

N

title

Y

translate

P

N if any value in table has multiple characters.

upper

Y

wrap

N

zfill

N