gsheet.values_append() function: ValueError: Out of range float values are not JSON compliant?

[doll kwong]

I am writing dataframe to a google sheet. it shows up error message: `ValueError: Out of range float values are not JSON compliant`. Both of the below code I tried:

`ws.update([df.columns.values.tolist()] + df.values.tolist())`

`spreadsheet.values_append("sheet_name", {"valueInputOption": "RAW"}, {"values": df_values})`

is it because the dataframe is too large, or there are other reasons? Thanks!