PNDSPY1225¶
Message Pandas < pandas.core.strings.accessor.StringMethods.slice > 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: For the column data type, only string, list, and dict values are supported. All column values must be of the same type. N if column has list values and step != 1.
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(['abc', 'def', 'ghi'])
result = s.str.slice
Output¶
The SMA adds the EWI PNDSPY1225 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: PNDSPY1225 => pandas.core.strings.accessor.StringMethods.slice has a partial mapping, with few scenarios not supported. Check Snowpark pandas documentation for more detail.
s = pd.Series(['abc', 'def', 'ghi'])
result = s.str.slice
Recommended fix¶
Data type consideration: For the column data type, only string, list, and dict values are supported. All column values must be of the same type. N if column has list values and step != 1.
Ensure data types are compatible:
Check column dtypes with
df.dtypesbefore the operationUse
.astype()to convert columns to expected typesNumeric operations may require explicit casting:
df['col'].astype(float)
Additional recommendations¶
Check the Snowpark pandas documentation to verify which scenarios aren’t supported for that specific element.