Supported pandas APIs#

The table below shows implementation of pandas APIs on MaxFrame on certain engines. If the API is not fully supported, unsupported item will be shown in the detail column.

Series API#

API

SQL Engine

SPE

Details

add(), radd()

P

Y

SQL engine: argument level and fill_value not supported.

all()

P

Y

SQL engine: argument skipna, level and min_count not supported.

any()

P

Y

SQL engine: argument skipna, level and min_count not supported.

apply()

N

Y

astype()

P

Y

SQL engine: converting to categorical types not supported.

case_when()

Y

Y

count()

P

Y

SQL engine: argument skipna, level and min_count not supported.

div(), rdiv()

P

Y

SQL engine: argument level and fill_value not supported.

drop_duplicates()

P

Y

SQL engine: maintaining original order of data not supported.

eq(), ne()

P

Y

SQL engine: argument level and fill_value not supported.

fillna()

P

Y

SQL engine: argument downcast, limit and method not supported.

floordiv(), rfloordiv()

P

Y

SQL engine: argument level and fill_value not supported.

ge(), gt()

P

Y

SQL engine: argument level and fill_value not supported.

series[item] (or `__getitem__)

N

Y

iloc()

P

Y

SQL engine: Non-continuous indexes or negative indexes (for instance, df.iloc[[1, 3]], df.iloc[1:10:2] or df.iloc[-3:]) not supported.

isin()

P

Y

SQL engine: index input not supported.

isna()

Y

Y

isnull()

Y

Y

le(), lt()

P

Y

SQL engine: argument level and fill_value not supported.

map()

P

Y

SQL engine: argument arg only supports functions and non-derivative dicts with simple scalars.

max()

P

Y

SQL engine: argument skipna, level and min_count not supported.

mean()

P

Y

SQL engine: argument skipna, level and min_count not supported.

min()

P

Y

SQL engine: argument skipna, level and min_count not supported.

mod(), rmod()

P

Y

SQL engine: argument level and fill_value not supported.

mul(), rmul()

P

Y

SQL engine: argument level and fill_value not supported.

nunique()

P

Y

SQL engine: argument skipna, level and min_count not supported. dropna==False not supported.

pow(), rpow()

P

Y

SQL engine: argument level and fill_value not supported.

rename()

N

Y

replace()

P

Y

SQL engine: when the argument regex is True, list or dict typed to_replace not supported. list or dict typed regex argument not supported.

sample()

P

Y

SQL engine: argument replace and weights not supported. frac>1 not supported.

sem()

P

Y

SQL engine: argument skipna, level and min_count not supported.

set_axis()

N

Y

series[item] = value (or `__setitem__)

P

Y

SQL engine: not supported when item is callable or DataFrame / Series or index of series and item are different.

sort_index()

P

Y

SQL engine: na_position=='last' not supported.

sort_values()

P

Y

SQL engine: na_position=='last' not supported.

sub(), rsub()

P

Y

SQL engine: argument level and fill_value not supported.

sum()

P

Y

SQL engine: argument skipna, level and min_count not supported.

transform()

P

Y

SQL engine: not supported when func is dict-like or list-like.

truediv(), rtruediv()

P

Y

SQL engine: argument level and fill_value not supported.

value_counts()

N

Y

var()

P

Y

SQL engine: argument skipna, level and min_count not supported.

DataFrame API#

API

SQL Engine

SPE

Details

add(), radd()

P

Y

SQL engine: argument axis, level and fill_value not supported.

all()

P

Y

SQL engine: argument skipna, level and min_count not supported. axis==1 not supported.

any()

P

Y

SQL engine: argument skipna, level and min_count not supported. axis==1 not supported.

apply()

P

Y

SQL engine: axis==0 not supported. Series output for axis==1 not supported.

astype()

P

Y

SQL engine: converting to categorical types not supported.

count()

P

Y

SQL engine: argument skipna, level and min_count not supported. axis==1 not supported.

div(), rdiv()

P

Y

SQL engine: argument axis, level and fill_value not supported.

drop()

Y

Y

drop_duplicates()

P

Y

SQL engine: maintaining original order of data not supported.

eq(), ne()

P

Y

SQL engine: argument axis, level and fill_value not supported.

fillna()

P

Y

SQL engine: argument downcast, limit and method not supported. axis==1 not supported.

floordiv(), rfloordiv()

P

Y

SQL engine: argument axis, level and fill_value not supported.

ge(), gt()

P

Y

SQL engine: argument axis, level and fill_value not supported.

df[item] (or `__getitem__)

P

Y

SQL engine: when index of item and df are different, boolean indexing not supported.

iloc()

P

Y

SQL engine: single row selection with df.iloc[1] not supported. Non-continuous indexes or negative indexes (for instance, df.iloc[[1, 3]], df.iloc[1:10:2] or df.iloc[-3:]) not supported.

isin()

P

Y

SQL engine: index input not supported.

isna()

Y

Y

isnull()

Y

Y

__invert__

Y

Y

le(), lt()

P

Y

SQL engine: argument axis, level and fill_value not supported.

max()

P

Y

SQL engine: argument skipna, level and min_count not supported. axis==1 not supported.

mean()

P

Y

SQL engine: argument skipna, level and min_count not supported. axis==1 not supported.

merge()

P

Y

SQL engine: argument indicator and validate not supported.

min()

P

Y

SQL engine: argument skipna, level and min_count not supported. axis==1 not supported.

mod(), rmod()

P

Y

SQL engine: argument axis, level and fill_value not supported.

mul(), rmul()

P

Y

SQL engine: argument axis, level and fill_value not supported.

notna()

Y

Y

notnull()

Y

Y

nunique()

P

Y

SQL engine: argument skipna, level and min_count not supported. axis==1 or dropna==False not supported.

pow(), rpow()

P

Y

SQL engine: argument axis, level and fill_value not supported.

rename()

P

Y

SQL engine: argument index not supported.

replace()

P

Y

SQL engine: when the argument regex is True, list or dict typed to_replace not supported. list or dict typed regex argument not supported.

sample()

P

Y

SQL engine: argument replace and weights not supported. axis==1 or frac>1 not supported.

sem()

P

Y

SQL engine: argument skipna, level and min_count not supported. axis==1 not supported.

set_axis()

P

Y

SQL engine: argument skipna, level and min_count not supported. axis==0 not supported.

df[item] = value (or `__setitem__)

P

Y

SQL engine: not supported when item is callable or DataFrame / Series or index of df and item are different.

sort_index()

P

Y

SQL engine: axis==1 or na_position=='last' not supported.

sort_values()

P

Y

SQL engine: axis==1 or na_position=='last' not supported.

sub(), rsub()

P

Y

SQL engine: argument axis, level and fill_value not supported.

sum()

P

Y

SQL engine: argument skipna, level and min_count not supported. axis==1 not supported.

transform()

P

Y

SQL engine: not supported when axis==1 and func is dict-like or list-like.

truediv(), rtruediv()

P

Y

SQL engine: argument axis, level and fill_value not supported.

value_counts()

N

Y

var()

P

Y

SQL engine: argument skipna, level and min_count not supported. axis==1 not supported.

Index API#

API

SQL Engine

SPE

Details

all()

N

Y

any()

N

Y

astype()

P

Y

SQL engine: converting to categorical types not supported.

count()

N

Y

drop_duplicates()

P

Y

SQL engine: maintaining original order of data not supported.

series[item] (or `__getitem__)

N

Y

iloc()

P

Y

SQL engine: Non-continuous indexes or negative indexes (for instance, df.iloc[[1, 3]], df.iloc[1:10:2] or df.iloc[-3:]) not supported.

isna()

Y

Y

isnull()

Y

Y

max()

N

Y

mean()

N

Y

min()

N

Y

nunique()

N

Y

sort_values()

N

Y

value_counts()

N

Y