PNDSPY1182¶

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: level

Reason: Raises division by zero exception when the right hand side contains at least one zero. pandas allows division by zero for non-object type Series and returns +/-inf.

Scenario¶

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

import pandas as pd

s = pd.Series([1, 2, 3, 4, 5])
result = s.floordiv()

import snowflake.snowpark.modin.pandas as pd

#EWI: PNDSPY1182 => pandas.core.series.Series.floordiv has a partial mapping, with few scenarios not supported. Check Snowpark pandas documentation for more detail.
s = pd.Series([1, 2, 3, 4, 5])
result = s.floordiv()

Recommended fix¶

The parameter level is not supported in Snowpark pandas. If your code uses this parameter, consider one of these approaches:

1. Remove the parameter: If the parameter is not essential for your use case, simply remove it from the function call.

2. Use default behavior: The function will work with default values for the unsupported parameter.

3. Post-process with native pandas: If the parameter is critical, collect the result using .to_pandas() and apply the operation with native pandas:

   # Convert to native pandas for unsupported parameter
   result = df.to_pandas().floordiv(level=value)
   

   Copy

Data type consideration: Raises division by zero exception when the right hand side contains at least one zero. pandas allows division by zero for non-object type Series and returns +/-inf.

Ensure data types are compatible:

• Check column dtypes with df.dtypes before the operation

• Use .astype() to convert columns to expected types

• Numeric 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.