[SNOW-1320248]: Fix inplace=True on Series objects derived from Series.

[sfc-gh-rdurrani]

1. Which Jira issue is this PR addressing? Make sure that there is an accompanying issue to your PR.

   Fixes SNOW-1320248

2. Fill out the following pre-review checklist:

   • I am adding a new automated test(s) to verify correctness of my new code
     • If this test skips Local Testing mode, I'm requesting review from @snowflakedb/local-testing
   • I am adding new logging messages
   • I am adding a new telemetry message
   • I am adding new credentials
   • I am adding a new dependency
   • If this is a new feature/behavior, I'm adding the Local Testing parity changes.

3. Please describe how your code solves the related issue.

This PR fixes the inplace argument for Series functions where the Series is derived from another Series object (e.g. series = series.iloc[:4]; series.fillna(14, inplace=True))

[sfc-gh-helmeleegy]

LGTM, thanks Rehan!

[sfc-gh-nkrishna]

LGTM, please resolve other comments

[sfc-gh-joshi]

Can you check if this is a bug in OSS Modin, and file an issue there if so?

[sfc-gh-rdurrani]

Can you check if this is a bug in OSS Modin, and file an issue there if so?

I was able to confirm that the bug is not reproducible on OSS Modin on Ray in the latest version installable from pip, so I think this is a snowpark only issue!

In [1]: import modin.pandas as pd
d
In [2]: df = pd.read_csv("/Users/rdurrani/Downloads/test.csv")
2024-09-17 13:17:51,513	INFO worker.py:1749 -- Started a local Ray instance.

In [3]: s = df['Fare'].copy().iloc[:4]
   ...: s.fillna(14, inplace=True)

In [4]: s
Out[4]:
0    7.8292
1    7.0000
2    9.6875
3    8.6625
Name: Fare, dtype: float64