# 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   | DPE   | SPE   | Details                                                                                                                                                  |
|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------|-------|-------|----------------------------------------------------------------------------------------------------------------------------------------------------------|
| [`add()`](../../reference/dataframe/generated/maxframe.dataframe.Series.add.md#maxframe.dataframe.Series.add), [`radd()`](../../reference/dataframe/generated/maxframe.dataframe.Series.radd.md#maxframe.dataframe.Series.radd)                                                                                                                                        | P            | Y     | Y     | SQL engine: argument `level` and `fill_value` not supported.                                                                                             |
| [`add_prefix()`](../../reference/dataframe/generated/maxframe.dataframe.Series.add_prefix.md#maxframe.dataframe.Series.add_prefix)                                                                                                                                                                                                                                     | Y            | Y     | Y     |                                                                                                                                                          |
| [`add_suffix()`](../../reference/dataframe/generated/maxframe.dataframe.Series.add_suffix.md#maxframe.dataframe.Series.add_suffix)                                                                                                                                                                                                                                     | Y            | Y     | Y     |                                                                                                                                                          |
| [`agg()`](../../reference/dataframe/generated/maxframe.dataframe.Series.agg.md#maxframe.dataframe.Series.agg)                                                                                                                                                                                                                                                          | P            | Y     | Y     | SQL engine: customized aggregation not supported.                                                                                                        |
| [`align()`](../../reference/dataframe/generated/maxframe.dataframe.Series.align.md#maxframe.dataframe.Series.align)                                                                                                                                                                                                                                                    | N            | Y     | Y     |                                                                                                                                                          |
| [`all()`](../../reference/dataframe/generated/maxframe.dataframe.Series.all.md#maxframe.dataframe.Series.all)                                                                                                                                                                                                                                                          | P            | Y     | Y     | SQL engine: argument `skipna`, `level` and `min_count` not supported.                                                                                    |
| [`any()`](../../reference/dataframe/generated/maxframe.dataframe.Series.any.md#maxframe.dataframe.Series.any)                                                                                                                                                                                                                                                          | P            | Y     | Y     | SQL engine: argument `skipna`, `level` and `min_count` not supported.                                                                                    |
| [`append()`](../../reference/dataframe/generated/maxframe.dataframe.Series.append.md#maxframe.dataframe.Series.append)                                                                                                                                                                                                                                                 | P            | Y     | Y     |                                                                                                                                                          |
| [`apply()`](../../reference/dataframe/generated/maxframe.dataframe.Series.apply.md#maxframe.dataframe.Series.apply)                                                                                                                                                                                                                                                    | P            | Y     | Y     |                                                                                                                                                          |
| [`argmax()`](../../reference/dataframe/generated/maxframe.dataframe.Series.argmax.md#maxframe.dataframe.Series.argmax)                                                                                                                                                                                                                                                 | N            | Y     | N     |                                                                                                                                                          |
| [`argmin()`](../../reference/dataframe/generated/maxframe.dataframe.Series.argmin.md#maxframe.dataframe.Series.argmin)                                                                                                                                                                                                                                                 | N            | Y     | N     |                                                                                                                                                          |
| [`argsort()`](../../reference/dataframe/generated/maxframe.dataframe.Series.argsort.md#maxframe.dataframe.Series.argsort)                                                                                                                                                                                                                                              | N            | Y     | N     |                                                                                                                                                          |
| [`astype()`](../../reference/dataframe/generated/maxframe.dataframe.Series.astype.md#maxframe.dataframe.Series.astype)                                                                                                                                                                                                                                                 | P            | Y     | Y     | SQL engine: converting to categorical types not supported.                                                                                               |
| `autocorr()`                                                                                                                                                                                                                                                                                                                                                           | N            | P     | Y     | DPE engine: only pearson correlation coefficient is supported.                                                                                           |
| [`between()`](../../reference/dataframe/generated/maxframe.dataframe.Series.between.md#maxframe.dataframe.Series.between)                                                                                                                                                                                                                                              | Y            | Y     | Y     |                                                                                                                                                          |
| [`case_when()`](../../reference/dataframe/generated/maxframe.dataframe.Series.case_when.md#maxframe.dataframe.Series.case_when)                                                                                                                                                                                                                                        | Y            | N     | Y     |                                                                                                                                                          |
| [`clip()`](../../reference/dataframe/generated/maxframe.dataframe.Series.clip.md#maxframe.dataframe.Series.clip)                                                                                                                                                                                                                                                       | N            | Y     | Y     |                                                                                                                                                          |
| [`compare()`](../../reference/dataframe/generated/maxframe.dataframe.Series.compare.md#maxframe.dataframe.Series.compare)                                                                                                                                                                                                                                              | N            | Y     | Y     |                                                                                                                                                          |
| [`corr()`](../../reference/dataframe/generated/maxframe.dataframe.Series.corr.md#maxframe.dataframe.Series.corr)                                                                                                                                                                                                                                                       | N            | P     | Y     | DPE engine: only pearson correlation coefficient is supported.                                                                                           |
| [`count()`](../../reference/dataframe/generated/maxframe.dataframe.Series.count.md#maxframe.dataframe.Series.count)                                                                                                                                                                                                                                                    | P            | Y     | Y     | SQL engine: argument `skipna`, `level` and `min_count` not supported.                                                                                    |
| [`cov()`](../../reference/dataframe/generated/maxframe.dataframe.Series.cov.md#maxframe.dataframe.Series.cov)                                                                                                                                                                                                                                                          | N            | Y     | Y     |                                                                                                                                                          |
| `cummax()`                                                                                                                                                                                                                                                                                                                                                             | N            | Y     | Y     |                                                                                                                                                          |
| `cummin()`                                                                                                                                                                                                                                                                                                                                                             | N            | Y     | Y     |                                                                                                                                                          |
| `cumprod()`                                                                                                                                                                                                                                                                                                                                                            | N            | Y     | Y     |                                                                                                                                                          |
| `cumsum()`                                                                                                                                                                                                                                                                                                                                                             | N            | Y     | Y     |                                                                                                                                                          |
| [`describe()`](../../reference/dataframe/generated/maxframe.dataframe.Series.describe.md#maxframe.dataframe.Series.describe)                                                                                                                                                                                                                                           | Y            | P     | Y     | DPE engine: medians and percentiles not supported by now.                                                                                                |
| `diff()`                                                                                                                                                                                                                                                                                                                                                               | N            | Y     | Y     |                                                                                                                                                          |
| [`div()`](../../reference/dataframe/generated/maxframe.dataframe.Series.div.md#maxframe.dataframe.Series.div), [`rdiv()`](../../reference/dataframe/generated/maxframe.dataframe.Series.rdiv.md#maxframe.dataframe.Series.rdiv)                                                                                                                                        | P            | Y     | Y     | SQL engine: argument `level` and `fill_value` not supported.                                                                                             |
| `dot()`                                                                                                                                                                                                                                                                                                                                                                | N            | Y     | Y     |                                                                                                                                                          |
| [`drop()`](../../reference/dataframe/generated/maxframe.dataframe.Series.drop.md#maxframe.dataframe.Series.drop)                                                                                                                                                                                                                                                       | Y            | Y     | Y     |                                                                                                                                                          |
| [`drop_duplicates()`](../../reference/dataframe/generated/maxframe.dataframe.Series.drop_duplicates.md#maxframe.dataframe.Series.drop_duplicates)                                                                                                                                                                                                                      | P            | Y     | Y     | SQL engine: maintaining original order of data not supported.                                                                                            |
| [`droplevel()`](../../reference/dataframe/generated/maxframe.dataframe.Series.droplevel.md#maxframe.dataframe.Series.droplevel)                                                                                                                                                                                                                                        | N            | Y     | Y     |                                                                                                                                                          |
| [`dropna()`](../../reference/dataframe/generated/maxframe.dataframe.Series.dropna.md#maxframe.dataframe.Series.dropna)                                                                                                                                                                                                                                                 | Y            | Y     | Y     |                                                                                                                                                          |
| `duplicated()`                                                                                                                                                                                                                                                                                                                                                         | N            | Y     | Y     |                                                                                                                                                          |
| `empty()`                                                                                                                                                                                                                                                                                                                                                              | Y            | Y     | Y     |                                                                                                                                                          |
| [`eq()`](../../reference/dataframe/generated/maxframe.dataframe.Series.eq.md#maxframe.dataframe.Series.eq), [`ne()`](../../reference/dataframe/generated/maxframe.dataframe.Series.ne.md#maxframe.dataframe.Series.ne)                                                                                                                                                 | P            | Y     | Y     | SQL engine: argument `level` and `fill_value` not supported.                                                                                             |
| [`explode()`](../../reference/dataframe/generated/maxframe.dataframe.Series.explode.md#maxframe.dataframe.Series.explode)                                                                                                                                                                                                                                              | Y            | Y     | Y     |                                                                                                                                                          |
| [`fillna()`](../../reference/dataframe/generated/maxframe.dataframe.Series.fillna.md#maxframe.dataframe.Series.fillna)                                                                                                                                                                                                                                                 | P            | Y     | Y     | SQL engine: argument `downcast`, `limit` and `method` not supported.                                                                                     |
| [`filter()`](../../reference/dataframe/generated/maxframe.dataframe.Series.filter.md#maxframe.dataframe.Series.filter)                                                                                                                                                                                                                                                 | N            | Y     | Y     |                                                                                                                                                          |
| [`first_valid_index()`](../../reference/dataframe/generated/maxframe.dataframe.Series.first_valid_index.md#maxframe.dataframe.Series.first_valid_index)                                                                                                                                                                                                                | N            | Y     | Y     |                                                                                                                                                          |
| [`floordiv()`](../../reference/dataframe/generated/maxframe.dataframe.Series.floordiv.md#maxframe.dataframe.Series.floordiv), [`rfloordiv()`](../../reference/dataframe/generated/maxframe.dataframe.Series.rfloordiv.md#maxframe.dataframe.Series.rfloordiv)                                                                                                          | P            | Y     | Y     | SQL engine: argument `level` and `fill_value` not supported.                                                                                             |
| [`ge()`](../../reference/dataframe/generated/maxframe.dataframe.Series.ge.md#maxframe.dataframe.Series.ge), [`gt()`](../../reference/dataframe/generated/maxframe.dataframe.Series.gt.md#maxframe.dataframe.Series.gt)                                                                                                                                                 | P            | Y     | Y     | SQL engine: argument `level` and `fill_value` not supported.                                                                                             |
| `series[item]` (or ``__getitem__`)                                                                                                                                                                                                                                                                                                                                     | N            | Y     | Y     |                                                                                                                                                          |
| `hasnans()`                                                                                                                                                                                                                                                                                                                                                            | N            | Y     | Y     |                                                                                                                                                          |
| [`head()`](../../reference/dataframe/generated/maxframe.dataframe.Series.head.md#maxframe.dataframe.Series.head)                                                                                                                                                                                                                                                       | Y            | Y     | Y     |                                                                                                                                                          |
| `hist()`                                                                                                                                                                                                                                                                                                                                                               | Y            | Y     | Y     |                                                                                                                                                          |
| [`iat()`](../../reference/dataframe/generated/maxframe.dataframe.Series.iat.md#maxframe.dataframe.Series.iat)                                                                                                                                                                                                                                                          | N            | Y     | Y     |                                                                                                                                                          |
| [`idxmax()`](../../reference/dataframe/generated/maxframe.dataframe.Series.idxmax.md#maxframe.dataframe.Series.idxmax)                                                                                                                                                                                                                                                 | N            | Y     | Y     |                                                                                                                                                          |
| [`idxmin()`](../../reference/dataframe/generated/maxframe.dataframe.Series.idxmin.md#maxframe.dataframe.Series.idxmin)                                                                                                                                                                                                                                                 | N            | Y     | Y     |                                                                                                                                                          |
| [`iloc()`](../../reference/dataframe/generated/maxframe.dataframe.Series.iloc.md#maxframe.dataframe.Series.iloc)                                                                                                                                                                                                                                                       | P            | Y     | 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.             |
| `is_monotonic()`, [`is_monotonic_decreasing()`](../../reference/dataframe/generated/maxframe.dataframe.Series.is_monotonic_decreasing.md#maxframe.dataframe.Series.is_monotonic_decreasing), [`is_monotonic_increasing()`](../../reference/dataframe/generated/maxframe.dataframe.Series.is_monotonic_increasing.md#maxframe.dataframe.Series.is_monotonic_increasing) | N            | Y     | Y     |                                                                                                                                                          |
| [`is_unique()`](../../reference/dataframe/generated/maxframe.dataframe.Series.is_unique.md#maxframe.dataframe.Series.is_unique)                                                                                                                                                                                                                                        | N            | Y     | Y     |                                                                                                                                                          |
| [`isin()`](../../reference/dataframe/generated/maxframe.dataframe.Series.isin.md#maxframe.dataframe.Series.isin)                                                                                                                                                                                                                                                       | P            | Y     | Y     | SQL engine: index input not supported.                                                                                                                   |
| [`isna()`](../../reference/dataframe/generated/maxframe.dataframe.Series.isna.md#maxframe.dataframe.Series.isna), [`notna()`](../../reference/dataframe/generated/maxframe.dataframe.Series.notna.md#maxframe.dataframe.Series.notna)                                                                                                                                  | Y            | Y     | Y     |                                                                                                                                                          |
| `isnull()`, `notnull()`                                                                                                                                                                                                                                                                                                                                                | Y            | Y     | Y     |                                                                                                                                                          |
| `items()`                                                                                                                                                                                                                                                                                                                                                              | Y            | Y     | Y     |                                                                                                                                                          |
| `kurtosis()`                                                                                                                                                                                                                                                                                                                                                           | N            | Y     | Y     |                                                                                                                                                          |
| [`last_valid_index()`](../../reference/dataframe/generated/maxframe.dataframe.Series.last_valid_index.md#maxframe.dataframe.Series.last_valid_index)                                                                                                                                                                                                                   | N            | Y     | Y     |                                                                                                                                                          |
| [`le()`](../../reference/dataframe/generated/maxframe.dataframe.Series.le.md#maxframe.dataframe.Series.le), [`lt()`](../../reference/dataframe/generated/maxframe.dataframe.Series.lt.md#maxframe.dataframe.Series.lt)                                                                                                                                                 | P            | Y     | Y     | SQL engine: argument `level` and `fill_value` not supported.                                                                                             |
| [`loc()`](../../reference/dataframe/generated/maxframe.dataframe.Series.loc.md#maxframe.dataframe.Series.loc)                                                                                                                                                                                                                                                          | N            | Y     | Y     |                                                                                                                                                          |
| [`map()`](../../reference/dataframe/generated/maxframe.dataframe.Series.map.md#maxframe.dataframe.Series.map)                                                                                                                                                                                                                                                          | P            | Y     | Y     | SQL engine: argument `arg` only supports functions and non-derivative dicts with simple scalars.                                                         |
| [`mask()`](../../reference/dataframe/generated/maxframe.dataframe.Series.mask.md#maxframe.dataframe.Series.mask)                                                                                                                                                                                                                                                       | N            | Y     | Y     |                                                                                                                                                          |
| [`max()`](../../reference/dataframe/generated/maxframe.dataframe.Series.max.md#maxframe.dataframe.Series.max)                                                                                                                                                                                                                                                          | P            | Y     | Y     | SQL engine: argument `skipna`, `level` and `min_count` not supported.                                                                                    |
| [`mean()`](../../reference/dataframe/generated/maxframe.dataframe.Series.mean.md#maxframe.dataframe.Series.mean)                                                                                                                                                                                                                                                       | P            | Y     | Y     | SQL engine: argument `skipna`, `level` and `min_count` not supported.                                                                                    |
| [`memory_usage()`](../../reference/dataframe/generated/maxframe.dataframe.Series.memory_usage.md#maxframe.dataframe.Series.memory_usage)                                                                                                                                                                                                                               | N            | Y     | Y     |                                                                                                                                                          |
| [`min()`](../../reference/dataframe/generated/maxframe.dataframe.Series.min.md#maxframe.dataframe.Series.min)                                                                                                                                                                                                                                                          | P            | Y     | Y     | SQL engine: argument `skipna`, `level` and `min_count` not supported.                                                                                    |
| [`mod()`](../../reference/dataframe/generated/maxframe.dataframe.Series.mod.md#maxframe.dataframe.Series.mod), [`rmod()`](../../reference/dataframe/generated/maxframe.dataframe.Series.rmod.md#maxframe.dataframe.Series.rmod)                                                                                                                                        | P            | Y     | Y     | SQL engine: argument `level` and `fill_value` not supported.                                                                                             |
| [`mul()`](../../reference/dataframe/generated/maxframe.dataframe.Series.mul.md#maxframe.dataframe.Series.mul), [`rmul()`](../../reference/dataframe/generated/maxframe.dataframe.Series.rmul.md#maxframe.dataframe.Series.rmul)                                                                                                                                        | P            | Y     | Y     | SQL engine: argument `level` and `fill_value` not supported.                                                                                             |
| [`nunique()`](../../reference/dataframe/generated/maxframe.dataframe.Series.nunique.md#maxframe.dataframe.Series.nunique)                                                                                                                                                                                                                                              | P            | Y     | Y     | SQL engine: argument `skipna`, `level` and `min_count` not supported. `dropna==False` not supported.                                                     |
| `pct_change()`                                                                                                                                                                                                                                                                                                                                                         | N            | Y     | Y     |                                                                                                                                                          |
| [`plot()`](../../reference/dataframe/generated/maxframe.dataframe.Series.plot.md#maxframe.dataframe.Series.plot)                                                                                                                                                                                                                                                       | Y            | Y     | Y     |                                                                                                                                                          |
| [`pow()`](../../reference/dataframe/generated/maxframe.dataframe.Series.pow.md#maxframe.dataframe.Series.pow), [`rpow()`](../../reference/dataframe/generated/maxframe.dataframe.Series.rpow.md#maxframe.dataframe.Series.rpow)                                                                                                                                        | P            | Y     | Y     | SQL engine: argument `level` and `fill_value` not supported.                                                                                             |
| [`prod()`](../../reference/dataframe/generated/maxframe.dataframe.Series.prod.md#maxframe.dataframe.Series.prod)                                                                                                                                                                                                                                                       | P            | Y     | Y     | SQL engine: argument `skipna`, `level` and `min_count` not supported.                                                                                    |
| [`quantile()`](../../reference/dataframe/generated/maxframe.dataframe.Series.quantile.md#maxframe.dataframe.Series.quantile)                                                                                                                                                                                                                                           | Y            | Y     | Y     |                                                                                                                                                          |
| [`reindex()`](../../reference/dataframe/generated/maxframe.dataframe.Series.reindex.md#maxframe.dataframe.Series.reindex)                                                                                                                                                                                                                                              | P            | Y     | Y     |                                                                                                                                                          |
| [`reindex_like()`](../../reference/dataframe/generated/maxframe.dataframe.Series.reindex_like.md#maxframe.dataframe.Series.reindex_like)                                                                                                                                                                                                                               | P            | Y     | Y     |                                                                                                                                                          |
| [`rename()`](../../reference/dataframe/generated/maxframe.dataframe.Series.rename.md#maxframe.dataframe.Series.rename)                                                                                                                                                                                                                                                 | P            | Y     | Y     | MCSQL engine: renaming indexes not supported.                                                                                                            |
| `rename_axis()`                                                                                                                                                                                                                                                                                                                                                        | Y            | Y     | Y     |                                                                                                                                                          |
| [`reorder_levels()`](../../reference/dataframe/generated/maxframe.dataframe.Series.reorder_levels.md#maxframe.dataframe.Series.reorder_levels)                                                                                                                                                                                                                         | N            | Y     | Y     |                                                                                                                                                          |
| `replace()`                                                                                                                                                                                                                                                                                                                                                            | P            | Y     | 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. |
| [`reset_index()`](../../reference/dataframe/generated/maxframe.dataframe.Series.reset_index.md#maxframe.dataframe.Series.reset_index)                                                                                                                                                                                                                                  | P            | Y     | Y     |                                                                                                                                                          |
| [`round()`](../../reference/dataframe/generated/maxframe.dataframe.Series.round.md#maxframe.dataframe.Series.round)                                                                                                                                                                                                                                                    | Y            | Y     | Y     |                                                                                                                                                          |
| [`sample()`](../../reference/dataframe/generated/maxframe.dataframe.Series.sample.md#maxframe.dataframe.Series.sample)                                                                                                                                                                                                                                                 | P            | Y     | Y     | SQL engine: argument `replace` and `weights` not supported. `frac>1` not supported.                                                                      |
| [`sem()`](../../reference/dataframe/generated/maxframe.dataframe.Series.sem.md#maxframe.dataframe.Series.sem)                                                                                                                                                                                                                                                          | P            | Y     | Y     | SQL engine: argument `skipna`, `level` and `min_count` not supported.                                                                                    |
| [`set_axis()`](../../reference/dataframe/generated/maxframe.dataframe.Series.set_axis.md#maxframe.dataframe.Series.set_axis)                                                                                                                                                                                                                                           | N            | Y     | Y     |                                                                                                                                                          |
| `series[item] = value` (or ``__setitem__`)                                                                                                                                                                                                                                                                                                                             | P            | Y     | Y     | SQL engine: not supported when `item` is callable or DataFrame / Series or index of `series` and `item` are different.                                   |
| [`shift()`](../../reference/dataframe/generated/maxframe.dataframe.Series.shift.md#maxframe.dataframe.Series.shift)                                                                                                                                                                                                                                                    | N            | Y     | Y     |                                                                                                                                                          |
| `size()`                                                                                                                                                                                                                                                                                                                                                               | P            | Y     | Y     |                                                                                                                                                          |
| `skew()`                                                                                                                                                                                                                                                                                                                                                               | N            | Y     | Y     |                                                                                                                                                          |
| [`sort_index()`](../../reference/dataframe/generated/maxframe.dataframe.Series.sort_index.md#maxframe.dataframe.Series.sort_index)                                                                                                                                                                                                                                     | P            | Y     | Y     | SQL engine: `na_position=='last'` not supported.                                                                                                         |
| [`sort_values()`](../../reference/dataframe/generated/maxframe.dataframe.Series.sort_values.md#maxframe.dataframe.Series.sort_values)                                                                                                                                                                                                                                  | P            | Y     | Y     | SQL engine: `na_position=='last'` not supported.                                                                                                         |
| [`std()`](../../reference/dataframe/generated/maxframe.dataframe.Series.std.md#maxframe.dataframe.Series.std)                                                                                                                                                                                                                                                          | P            | Y     | Y     | SQL engine: argument `level` and `fill_value` not supported.                                                                                             |
| [`sub()`](../../reference/dataframe/generated/maxframe.dataframe.Series.sub.md#maxframe.dataframe.Series.sub), [`rsub()`](../../reference/dataframe/generated/maxframe.dataframe.Series.rsub.md#maxframe.dataframe.Series.rsub)                                                                                                                                        | P            | Y     | Y     | SQL engine: argument `level` and `fill_value` not supported.                                                                                             |
| [`sum()`](../../reference/dataframe/generated/maxframe.dataframe.Series.sum.md#maxframe.dataframe.Series.sum)                                                                                                                                                                                                                                                          | P            | Y     | Y     | SQL engine: argument `skipna`, `level` and `min_count` not supported.                                                                                    |
| [`swaplevel()`](../../reference/dataframe/generated/maxframe.dataframe.Series.swaplevel.md#maxframe.dataframe.Series.swaplevel)                                                                                                                                                                                                                                        | N            | Y     | Y     |                                                                                                                                                          |
| `tail()`                                                                                                                                                                                                                                                                                                                                                               | N            | Y     | Y     |                                                                                                                                                          |
| [`take()`](../../reference/dataframe/generated/maxframe.dataframe.Series.take.md#maxframe.dataframe.Series.take)                                                                                                                                                                                                                                                       | N            | Y     | Y     |                                                                                                                                                          |
| [`to_frame()`](../../reference/dataframe/generated/maxframe.dataframe.Series.to_frame.md#maxframe.dataframe.Series.to_frame)                                                                                                                                                                                                                                           | Y            | Y     | Y     |                                                                                                                                                          |
| [`transform()`](../../reference/dataframe/generated/maxframe.dataframe.Series.transform.md#maxframe.dataframe.Series.transform)                                                                                                                                                                                                                                        | P            | Y     | Y     | SQL engine: not supported when `func` is dict-like or list-like.                                                                                         |
| [`truediv()`](../../reference/dataframe/generated/maxframe.dataframe.Series.truediv.md#maxframe.dataframe.Series.truediv), [`rtruediv()`](../../reference/dataframe/generated/maxframe.dataframe.Series.rtruediv.md#maxframe.dataframe.Series.rtruediv)                                                                                                                | P            | Y     | Y     | SQL engine: argument `level` and `fill_value` not supported.                                                                                             |
| [`tshift()`](../../reference/dataframe/generated/maxframe.dataframe.Series.tshift.md#maxframe.dataframe.Series.tshift)                                                                                                                                                                                                                                                 | N            | Y     | Y     |                                                                                                                                                          |
| [`unique()`](../../reference/dataframe/generated/maxframe.dataframe.Series.unique.md#maxframe.dataframe.Series.unique)                                                                                                                                                                                                                                                 | P            | Y     | Y     |                                                                                                                                                          |
| [`unstack()`](../../reference/dataframe/generated/maxframe.dataframe.Series.unstack.md#maxframe.dataframe.Series.unstack)                                                                                                                                                                                                                                              | N            | Y     | Y     |                                                                                                                                                          |
| [`value_counts()`](../../reference/dataframe/generated/maxframe.dataframe.Series.value_counts.md#maxframe.dataframe.Series.value_counts)                                                                                                                                                                                                                               | Y            | Y     | Y     |                                                                                                                                                          |
| [`var()`](../../reference/dataframe/generated/maxframe.dataframe.Series.var.md#maxframe.dataframe.Series.var)                                                                                                                                                                                                                                                          | P            | Y     | Y     | SQL engine: argument `skipna`, `level` and `min_count` not supported.                                                                                    |
| [`where()`](../../reference/dataframe/generated/maxframe.dataframe.Series.where.md#maxframe.dataframe.Series.where)                                                                                                                                                                                                                                                    | N            | Y     | Y     |                                                                                                                                                          |
| [`xs()`](../../reference/dataframe/generated/maxframe.dataframe.Series.xs.md#maxframe.dataframe.Series.xs)                                                                                                                                                                                                                                                             | N            | Y     | Y     |                                                                                                                                                          |

## DataFrame API

## Index API

| API                                                                                                                                                                                                                               | SQL Engine   | DPE   | SPE   | Details                                                                                                                                      |
|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------|-------|-------|----------------------------------------------------------------------------------------------------------------------------------------------|
| [`all()`](../../reference/dataframe/generated/maxframe.dataframe.Index.all.md#maxframe.dataframe.Index.all)                                                                                                                       | N            | Y     | Y     |                                                                                                                                              |
| [`any()`](../../reference/dataframe/generated/maxframe.dataframe.Index.any.md#maxframe.dataframe.Index.any)                                                                                                                       | N            | Y     | Y     |                                                                                                                                              |
| `append()`                                                                                                                                                                                                                        | Y            | Y     | Y     |                                                                                                                                              |
| [`astype()`](../../reference/dataframe/generated/maxframe.dataframe.Index.astype.md#maxframe.dataframe.Index.astype)                                                                                                              | P            | Y     | Y     | SQL engine: converting to categorical types not supported.                                                                                   |
| `count()`                                                                                                                                                                                                                         | N            | Y     | Y     |                                                                                                                                              |
| [`drop()`](../../reference/dataframe/generated/maxframe.dataframe.Index.drop.md#maxframe.dataframe.Index.drop)                                                                                                                    | Y            | Y     | Y     |                                                                                                                                              |
| [`drop_duplicates()`](../../reference/dataframe/generated/maxframe.dataframe.Index.drop_duplicates.md#maxframe.dataframe.Index.drop_duplicates)                                                                                   | P            | Y     | Y     | SQL engine: maintaining original order of data not supported.                                                                                |
| [`droplevel()`](../../reference/dataframe/generated/maxframe.dataframe.Index.droplevel.md#maxframe.dataframe.Index.droplevel)                                                                                                     | N            | Y     | Y     |                                                                                                                                              |
| [`dropna()`](../../reference/dataframe/generated/maxframe.dataframe.Index.dropna.md#maxframe.dataframe.Index.dropna)                                                                                                              | Y            | Y     | Y     |                                                                                                                                              |
| `duplicated()`                                                                                                                                                                                                                    | N            | Y     | Y     |                                                                                                                                              |
| `empty()`                                                                                                                                                                                                                         | Y            | Y     | Y     |                                                                                                                                              |
| [`fillna()`](../../reference/dataframe/generated/maxframe.dataframe.Index.fillna.md#maxframe.dataframe.Index.fillna)                                                                                                              | P            | Y     | Y     | SQL engine: argument `downcast`, `limit` and `method` not supported.                                                                         |
| `series[item]` (or ``__getitem__`)                                                                                                                                                                                                | N            | Y     | Y     |                                                                                                                                              |
| [`get_level_values()`](../../reference/dataframe/generated/maxframe.dataframe.Index.get_level_values.md#maxframe.dataframe.Index.get_level_values)                                                                                | N            | Y     | Y     |                                                                                                                                              |
| `iloc()`                                                                                                                                                                                                                          | P            | Y     | 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()`                                                                                                                                                                                                                          | N            | Y     | Y     |                                                                                                                                              |
| [`isna()`](../../reference/dataframe/generated/maxframe.dataframe.Index.isna.md#maxframe.dataframe.Index.isna), [`notna()`](../../reference/dataframe/generated/maxframe.dataframe.Index.notna.md#maxframe.dataframe.Index.notna) | Y            | Y     | Y     |                                                                                                                                              |
| `isnull()`, `notnull()`                                                                                                                                                                                                           | Y            | Y     | Y     |                                                                                                                                              |
| [`map()`](https://docs.python.org/3/library/functions.html#map)                                                                                                                                                                   | P            | Y     | Y     | SQL engine: argument `arg` only supports functions and non-derivative dicts with simple scalars.                                             |
| [`max()`](../../reference/dataframe/generated/maxframe.dataframe.Index.max.md#maxframe.dataframe.Index.max)                                                                                                                       | N            | Y     | Y     |                                                                                                                                              |
| `memory_usage()`                                                                                                                                                                                                                  | N            | Y     | Y     |                                                                                                                                              |
| `mean()`                                                                                                                                                                                                                          | N            | Y     | Y     |                                                                                                                                              |
| [`min()`](../../reference/dataframe/generated/maxframe.dataframe.Index.min.md#maxframe.dataframe.Index.min)                                                                                                                       | N            | Y     | Y     |                                                                                                                                              |
| `nunique()`                                                                                                                                                                                                                       | N            | Y     | Y     |                                                                                                                                              |
| `reindex()`                                                                                                                                                                                                                       | N            | Y     | Y     |                                                                                                                                              |
| [`rename()`](../../reference/dataframe/generated/maxframe.dataframe.Index.rename.md#maxframe.dataframe.Index.rename)                                                                                                              | Y            | Y     | Y     |                                                                                                                                              |
| [`set_names()`](../../reference/dataframe/generated/maxframe.dataframe.Index.set_names.md#maxframe.dataframe.Index.set_names)                                                                                                     | Y            | Y     | Y     |                                                                                                                                              |
| `shift()`                                                                                                                                                                                                                         | N            | Y     | Y     |                                                                                                                                              |
| `sort_values()`                                                                                                                                                                                                                   | N            | Y     | Y     |                                                                                                                                              |
| [`to_frame()`](../../reference/dataframe/generated/maxframe.dataframe.Index.to_frame.md#maxframe.dataframe.Index.to_frame)                                                                                                        | Y            | Y     | Y     |                                                                                                                                              |
| [`to_series()`](../../reference/dataframe/generated/maxframe.dataframe.Index.to_series.md#maxframe.dataframe.Index.to_series)                                                                                                     | Y            | Y     | Y     |                                                                                                                                              |
| `unique()`                                                                                                                                                                                                                        | N            | Y     | Y     |                                                                                                                                              |
| `value_counts()`                                                                                                                                                                                                                  | N            | Y     | Y     |                                                                                                                                              |
| `where()`                                                                                                                                                                                                                         | N            | Y     | Y     |                                                                                                                                              |
