pd.Index 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.

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

N

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 Index values are tuple-like, or 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

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