You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When using the set_dataframe to copy in a Pandas dataframe into Googlesheets one gets the standard Python error:
worksheet.py:1366: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
df[col] = df[col].astype('unicode').replace('<NA>', nan)
It doesn't impact the end result - the values still get copied but it's not following Python best practice.
To reproduce I believe you can provide any Pandas dataframe to the set_dataframe function.
The text was updated successfully, but these errors were encountered:
When using the set_dataframe to copy in a Pandas dataframe into Googlesheets one gets the standard Python error:
It doesn't impact the end result - the values still get copied but it's not following Python best practice.
To reproduce I believe you can provide any Pandas dataframe to the set_dataframe function.
The text was updated successfully, but these errors were encountered: