gspread-pandas
gspread-pandas copied to clipboard
aiguofer
A package to easily open an instance of a Google spreadsheet and interact with worksheets through Pandas DataFrames.
Is it possible to run the `gspread-pandas` on a remote-server (like aws ec2) and allow the user to authenticate using their local browser (google chrome on their machines)? I have...
At this line: https://github.com/aiguofer/gspread-pandas/blob/master/README.rst?plain=1#L107 If we try to create an OAuth key right now at GCP, there is no option "Other" for application type. Although It may be Web App...
Hi Diego! Currently in `gspread_pandas.spread.Spread().df_to_sheet()` you are limited to either wiping the sheet or overwriting existing rows using the `replace` parameter. How feasible would it be to add an option...
Modified sheet_to_df function to allow the the import of all columns as either "unformated" or "formula". This is done by passing in -1 as first element in the unformated_columns /...
Simple change which fixed an issue I was having (and which is currently mentioned in issue #46 ) where a folder cannot be found by name when using the move...
I've gotten a lot of utility from this package, but I couldn't find that there was a method for reordering or reindexing spreadsheets within a Spread object. I have tried...
Steps to reproduce: 1. I have file, which belongs to google service account and the folder from my account the service account has access to. 2. I call `client.move_file` and...
Currently, when we pull data with `df_to_sheet`, every column gets set with dtype 'object'. It'd be nice to have a way to provide column dtypes or converters for each column...
Hello! I've been using this library in an automated workflow for the last few months and started getting authentication errors on 1/28/24, which I noticed coincided with the release of...
gspread-pandas' `Sheet` class has implemented some logic to know when sheet metadata needs to be refetched - cf `refresh_spread_metadata`. However, the current implementation fails to make use of its potential....
