Save dataframe to Google Sheet from Colab

sheet_df.py

# authenticate
from google.colab import auth
auth.authenticate_user()
import gspread
from oauth2client.client import GoogleCredentials as GC
gc = gspread.authorize(GC.get_application_default())
# create, and save df
from gspread_dataframe import set_with_dataframe
title = 'New Sheet'
gc.create(title)  # if not exist
sheet = gc.open(title).sheet1
set_with_dataframe(sheet, df) 
# include_index=False, include_column_header=True, resize=False

sheet_read.py

from gspread_dataframe import get_as_dataframe
sheet = gc.open(title).sheet1
df = get_as_dataframe(sheet).dropna(0, 'all').dropna(1, 'all')
# remove empty (NA) columns and rows

shorthand.py

import gspread
from gspread_dataframe import *

def set_to(self, df):
  set_with_dataframe(self, df)
gspread.models.Worksheet.set_to = set_to

def get_df(self):
  return get_as_dataframe(self).dropna(0, 'all').dropna(1, 'all')
gspread.models.Worksheet.get_df = get_df