PNDSPY1029¶

Message Pandas < pandas.core.base.IndexOpsMixin.value_counts > has a partial mapping with a few scenarios not supported in Snowpark.

Category Warning

Applies to¶

This EWI applies to the following elements (same implementation):

pandas.core.base.IndexOpsMixin.value_counts
pandas.core.indexes.base.Index.value_counts
pandas.core.series.Series.value_counts

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

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.Index([1, 2, 3, 4, 5])
result = idx.value_counts()

Copy

Output¶

The SMA adds the EWI PNDSPY1029 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: PNDSPY1029 => pandas.core.base.IndexOpsMixin.value_counts has a partial mapping, with few scenarios not supported. Check Snowpark pandas documentation for more detail.
idx = pd.Index([1, 2, 3, 4, 5])
result = idx.value_counts()

Copy

Recommended fix¶

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

Remove the parameter: If the parameter is not essential for your use case, simply remove it from the function call.
Use default behavior: The function will work with default values for the unsupported parameter.
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().value_counts(bins=value)
```
Copy

Additional recommendations¶

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