Partial Code -
dfdata = pd.json_normalize(MEData)
Headers = dfdata.columns.tolist()
dfdata = dfdata.to_numpy().tolist()
dfdata = [Headers] + dfdata
gc = gspread.authorize(creds)
wb = gc.open_by_key('')
ws = wb.worksheet("Sheet4")
ws.update("A1",dfdata)
dfdata is fine - the data frame is created successfully and in the correct format but the error I get is -
APIError: {'code': 400, 'message': 'Invalid values[1][15]: list_value {\n values {\n number_value: 0.0\n }\n values {\n number_value: 0.0\n }\n values {\n number_value: 0.0\n }\n values {\n number_value: 0.0\n }\n values {\n number_value: 0.0\n }\n values {\n number_value: 0.0\n }\n values {\n number_value: 0.0\n }\n values {\n
