SNOW-1869802: Pivot converts 0 to None

[AdamosX]

1. What version of Python are you using?
   3.11.9

2. What are the Snowpark Python and pandas versions in the environment?
   pandas==2.2.3
   snowflake-snowpark-python==1.26.0

3. What did you do?

df = sess.create_dataframe([
    [1, "A", 10],
    [1, "B", 0],
    [2, "A", 11],
    [2, "B", 12]
])
pivoted = df.pivot(pivot_col="_2", values=["A", "B"]).function('min')("_3")
pivoted.collect()

4. What did you expect to see?
   In Snowflake this results in: [Row(_1=1, 'A'=10, 'B'=0), Row(_1=2, 'A'=11, 'B'=12)]
   But in local testing: [Row(_1=1, A=10, B=None), Row(_1=2, A=11, B=12)]
   0 gets converted to None

[sfc-gh-sghosh]

Hello @AdamosX ,

Thanks for raising the issue, we are able to reproduce it, we will work on eliminating it.

Regards,
Sujan

[AdamosX]

I did not mention that there are other differences:
In snowflake pivot adds '' to the column names in pivot and local testing does not.

The difference is evident when accessing the rows:

rows = pivoted.collect()
rows[0]["A"] # works with local testing session but not real session
rows[0]["'A'"] # works with real session but not local testing session