Python 3.9.1 (default, Dec 10 2020, 10:36:35)
[Clang 12.0.0 (clang-1200.0.32.27)] on darwin
import pandas as pd
df = pd.DataFrame({"a":[1,2,3]})
set_with_dataframe(...,df)
---> 59 set_with_dataframe(ws, df, include_index=True, resize=True)
~/.virtualenvs/brazeds/lib/python3.6/site-packages/gspread_dataframe.py in set_with_dataframe(worksheet, dataframe, row, col, include_index, include_column_header, resize, allow_formulas, string_escaping)
324
325 resp = worksheet.update_cells(
--> 326 cells_to_update, value_input_option="USER_ENTERED"
327 )
328 logger.debug("Cell update response: %s", resp)
~/.virtualenvs/brazeds/lib/python3.6/site-packages/gspread/models.py in update_cells(self, cell_list, value_input_option)
907 range_name,
908 params={'valueInputOption': value_input_option},
--> 909 body={'values': values_rect},
910 )
911
~/.virtualenvs/brazeds/lib/python3.6/site-packages/gspread/models.py in values_update(self, range, params, body)
233 """
234 url = SPREADSHEET_VALUES_URL % (self.id, quote(range))
--> 235 r = self.client.request('put', url, params=params, json=body)
236 return r.json()
237
~/.virtualenvs/brazeds/lib/python3.6/site-packages/gspread/client.py in request(self, method, endpoint, params, data, json, files, headers)
65 data=data,
66 files=files,
---> 67 headers=headers,
68 )
69
~/.virtualenvs/brazeds/lib/python3.6/site-packages/requests/sessions.py in put(self, url, data, **kwargs)
600 """
601
--> 602 return self.request('PUT', url, data=data, **kwargs)
603
604 def patch(self, url, data=None, **kwargs):
~/.virtualenvs/brazeds/lib/python3.6/site-packages/google/auth/transport/requests.py in request(self, method, url, data, headers, max_allowed_time, timeout, **kwargs)
468 headers=request_headers,
469 timeout=timeout,
--> 470 **kwargs
471 )
472 remaining_time = guard.remaining_timeout
~/.virtualenvs/brazeds/lib/python3.6/site-packages/requests/sessions.py in request(self, method, url, params, data, headers, cookies, files, auth, timeout, allow_redirects, proxies, hooks, stream, verify, cert, json)
526 hooks=hooks,
527 )
--> 528 prep = self.prepare_request(req)
529
530 proxies = proxies or {}
~/.virtualenvs/brazeds/lib/python3.6/site-packages/requests/sessions.py in prepare_request(self, request)
464 auth=merge_setting(auth, self.auth),
465 cookies=merged_cookies,
--> 466 hooks=merge_hooks(request.hooks, self.hooks),
467 )
468 return p
~/.virtualenvs/brazeds/lib/python3.6/site-packages/requests/models.py in prepare(self, method, url, headers, files, data, params, auth, cookies, hooks, json)
317 self.prepare_headers(headers)
318 self.prepare_cookies(cookies)
--> 319 self.prepare_body(data, files, json)
320 self.prepare_auth(auth, url)
321
~/.virtualenvs/brazeds/lib/python3.6/site-packages/requests/models.py in prepare_body(self, data, files, json)
467 # provides this natively, but Python 3 gives a Unicode string.
468 content_type = 'application/json'
--> 469 body = complexjson.dumps(json)
470 if not isinstance(body, bytes):
471 body = body.encode('utf-8')
/usr/lib/python3.6/json/__init__.py in dumps(obj, skipkeys, ensure_ascii, check_circular, allow_nan, cls, indent, separators, default, sort_keys, **kw)
229 cls is None and indent is None and separators is None and
230 default is None and not sort_keys and not kw):
--> 231 return _default_encoder.encode(obj)
232 if cls is None:
233 cls = JSONEncoder
/usr/lib/python3.6/json/encoder.py in encode(self, o)
197 # exceptions aren't as detailed. The list call should be roughly
198 # equivalent to the PySequence_Fast that ''.join() would do.
--> 199 chunks = self.iterencode(o, _one_shot=True)
200 if not isinstance(chunks, (list, tuple)):
201 chunks = list(chunks)
/usr/lib/python3.6/json/encoder.py in iterencode(self, o, _one_shot)
255 self.key_separator, self.item_separator, self.sort_keys,
256 self.skipkeys, _one_shot)
--> 257 return _iterencode(o, 0)
258
259 def _make_iterencode(markers, _default, _encoder, _indent, _floatstr,
/usr/lib/python3.6/json/encoder.py in default(self, o)
178 """
179 raise TypeError("Object of type '%s' is not JSON serializable" %
--> 180 o.__class__.__name__)
181
182 def encode(self, o):
TypeError: Object of type 'int64' is not JSON serializable