PNDSPY1019¶

Message Pandas < pandas.core.arrays.datetimelike.DatelikeOps.strftime > 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.

Reason: N if date_format contains directives other than (%d, %m, %Y, %H, %M, %S, %f, %j, %X, %%).

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

s = pd.Series(pd.date_range('2023-01-01', periods=3))
result = s.dt.strftime

Copy

Output¶

The SMA adds the EWI PNDSPY1019 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: PNDSPY1019 => pandas.core.arrays.datetimelike.DatelikeOps.strftime has a partial mapping, with few scenarios not supported. Check Snowpark pandas documentation for more detail.
s = pd.Series(pd.date_range('2023-01-01', periods=3))
result = s.dt.strftime

Copy

Recommended fix¶

Behavioral note: N if date_format contains directives other than (%d, %m, %Y, %H, %M, %S, %f, %j, %X, %%).

This behavior may differ from native pandas. Recommended actions:

Test with a representative sample of your data
Compare results with native pandas if precision is critical
Use .to_pandas() if exact pandas behavior is required

Additional recommendations¶

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