PNDSPY1143¶

Message Pandas < pandas.core.indexes.datetimes.DatetimeIndex.ceil > has a partial mapping with a few scenarios not supported in Snowpark.

Category Warning

Description¶

This issue appears when the SMA detects the use of a pandas element that has a direct equivalent in Snowpark pandas, but some scenarios might behave differently than pandas.

Missing or Unsupported Parameters: ambiguous, nonexistent

Scenario¶

A method with a few scenarios that aren’t supported in Snowpark.

Input¶

The following example shows a method with a few unsupported scenarios in Snowpark.

import pandas as pd

idx = pd.DatetimeIndex(['2023-01-01', '2023-02-01', '2023-03-01'])
result = idx.ceil()

Copy

Output¶

The SMA adds the EWI PNDSPY1143 to the output code to let you know that this element has a few scenarios that aren’t supported in Snowpark.

import snowflake.snowpark.modin.pandas as pd

#EWI: PNDSPY1143 => pandas.core.indexes.datetimes.DatetimeIndex.ceil has a partial mapping, with few scenarios not supported. Check Snowpark pandas documentation for more detail.
idx = pd.DatetimeIndex(['2023-01-01', '2023-02-01', '2023-03-01'])
result = idx.ceil()

Copy

Recommended fix¶

The following parameters are not supported in Snowpark pandas: ambiguous, nonexistent.

Recommended approaches:

Avoid unsupported parameters: Modify your code to not use these parameters if they are not essential.

Use .to_pandas() for full compatibility: If you need these parameters, convert to native pandas first:

# Convert to native pandas when unsupported parameters are needed
native_df = df.to_pandas()
result = native_df.ceil(...)  # Use all parameters

Copy

Split the operation: Perform supported operations in Snowpark pandas, then use native pandas only for the unsupported functionality.

Additional recommendations¶

Check the Snowpark pandas documentation to verify which scenarios aren’t supported for that specific element.