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.
### Description When trying to clear a sheet that has frozen columns and rows, only cell A1 is cleared. I think it's caused by this line of code: https://github.com/aiguofer/gspread-pandas/blob/60e8d93cab67290ccdf341ada12800a36e40ca01/gspread_pandas/spread.py#L606 ###...
Hi! We have quite a few pandas dataframes with quite a high number of cells that we update daily. These are then uploaded to gsheets via df_to_sheet, but we almost...
My usecase is to write a dataframe to a Google Spreadsheet 'UseCase' inside a folder 'Testing'. I tried the following: `spread = Spread(spread='/Testing/Usecase', create_spread=True)` This creates a spreadsheet with the...
When using the latest gspread-pandas version 3.3.0 with latest pandas version 2.2.1, the following FutureWarning is raised: > .../site-packages/gspread_pandas/spread.py:401: FutureWarning: Downcasting behavior in `replace` is deprecated and will be removed...
The documentation for conf.py/get_config says: "The creds_dir value will be set to conf_dir/creds and the directory will be created if it doesn't exist; if you'd like to override that you...
The latest version of Pandas throws an annoying warning in many cases when df.replace() is called. Adding a context manager to silence this per the warning instructions.
