PNDSPY1184¶

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: observed is ignored since Categoricals are not implemented yet

Reason: Y, support axis == 0 and by is column label or Series from the current DataFrame, or a pd.Grouper object; otherwise N. If a pd.Grouper object is passed, then only the default values of the sort, closed, label, and convention arguments are supported. The origin argument currently supports “start_day” and “start”. Note that supported functions are agg, count, cumcount, cummax, cummin, cumsum, first, last, max, mean, median, min, quantile, shift, size, std, sum, and var. Otherwise N.

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.groupby()

import snowflake.snowpark.modin.pandas as pd

#EWI: PNDSPY1184 => pandas.core.series.Series.groupby 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.groupby()

Recommended fix¶

The parameter observed is ignored since Categoricals are not implemented yet 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().groupby(observed is ignored since Categoricals are not implemented yet=value)
   

   Copy

Behavioral note: Y, support axis == 0 and by is column label or Series from the current DataFrame, or a pd.Grouper object; otherwise N. If a pd.Grouper object is passed, then only the default values of the sort, closed, label, and convention arguments are supported. The origin argument currently supports “start_day” and “start”. Note that supported functions are agg, count, cumcount, cummax, cummin, cumsum, first, last, max, mean, median, min, quantile, shift, size, std, sum, and var. Otherwise N.

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.