gspread-dataframe

gspread-dataframe copied to clipboard

This package is popular, but the gspread-formatting package is less so. I know from personal experience that writing tabular data to a gspread worksheet is pleasant only when proper formatting...

robin900

A writer object would mainly serve to automate the arguments passed to `get_as_dataframe` but also a little bit for `set_with_dataframe`: ``` from gspread_dataframe import make_reader_writer ws = some_worksheet df =...

robin900

Allow option in set_with_dataframe and get_as_dataframe to omit redundant higher-level labels in MultiIndex index columns

7

From an earlier issue #20 , @sam-s said: In this case, I would like to have a separate column (with a header!) for each level. I am torn between ```...

robin900

Most of the cases , Google spreadsheet has 1000 rows in one tab as default. I tried to read all the tabs inside the spreadsheet and it got gspread API...

GmGniap

Fixes #54. Worksheet names that are valid cell references no longer cause Sheets API errors. Accomplished by always quoting the worksheet title (name) in the argument to gspread's `values_get`. If...

robin900

Requests to sheets API cause 400 error is worksheet name is valid cell reference (was: Error using get_as_dataframe)

1

I am using get_as_dataframe to read a sheet. If the sheet name is "CRM26" the extraction fails with: `{'code': 400, 'message': 'Range (query!CRM26) exceeds grid limits. Max rows: 10002, max...

Rulowizard

Hi, I've got a worksheet with a True/False columns. I'd like to point out that when I try to 'get_as_dataframe' the True/False columns are sometimes parsed as 0's and 1's...

Spider-netizen