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.
Currently, there is no lazy MultiIndex support. This lazy Index object is only a single Index object. However, existing Snowpark pandas DataFrame and Series APIs may support native pandas MultiIndex objects.
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.
Attributes
| Index attribute | Snowpark implemented? (Y/N/P/D) | Notes for current implementation |
values |
Y | |
is_monotonic_increasing |
Y | |
is_monotonic_decreasing |
Y | |
is_unique |
Y | |
has_duplicates |
Y | |
hasnans |
N | |
dtype |
Y | |
inferred_type |
N | |
shape |
Y | |
name |
Y | |
names |
Y | |
nbytes |
N | |
ndim |
Y | |
size |
Y | |
empty |
Y | |
T |
Y | |
memory_usage |
N | |
nlevels |
P | Only single Index supported. |
array |
Y | |
str |
Y |
Methods
| DataFrame method | Snowpark implemented? (Y/N/P/D) | Missing parameters | Notes for current implementation |
all |
P | N for non-integer/boolean types. |
|
any |
P | N for non-integer/boolean types. |
|
argmin |
Y | ||
argmax |
Y | ||
copy |
Y | ||
delete |
N | ||
drop |
N | ||
drop_duplicates |
Y | ||
duplicated |
N | ||
equals |
Y | ||
factorize |
N | ||
identical |
Y | ||
insert |
N | ||
is_ |
N | ||
is_boolean |
Y | ||
is_categorical |
N | ||
is_floating |
Y | ||
is_integer |
Y | ||
is_interval |
N | ||
is_numeric |
Y | ||
is_object |
Y | ||
min |
Y | ||
max |
Y | ||
reindex |
P | N if the method is nearest. |
|
rename |
Y | ||
repeat |
N | ||
where |
N | ||
take |
N | ||
putmask |
N | ||
unique |
Y | ||
nunique |
Y | ||
value_counts |
P | bins |
|
set_names |
Y | ||
droplevel |
N | ||
fillna |
N | ||
dropna |
N | ||
isna |
N | ||
notna |
N | ||
astype |
Y | ||
item |
Y | ||
map |
N | ||
ravel |
N | ||
to_list |
Y | ||
to_series |
Y | ||
to_frame |
Y | ||
to_numpy |
Y | ||
view |
N | ||
argsort |
N | ||
searchsorted |
N | ||
sort_values |
P | key |
Snowpark pandas currently uses stable sort when sorting the index values. Pandas uses quicksort. |
shift |
N | ||
append |
N | ||
join |
N | ||
intersection |
N | ||
union |
N | ||
difference |
N | ||
symmetric_difference |
N | ||
asof |
N | ||
asof_locs |
N | ||
get_indexer |
N | ||
get_indexer_for |
N | ||
get_indexer_non_unique |
N | ||
get_level_values |
N | ||
get_loc |
N | ||
get_slice_bound |
N | ||
isin |
N | ||
slice_indexer |
N | ||
slice_locs |
N | ||
to_pandas |
Y |