title: reading/writing data frame to google sheets using pygsheets
body: <p>What is the correct program flow to write different sized data frame to the same worksheet but ensure only the most recent data values written are visible?</p>
  
  <p>Here was my original sequence:</p>
  
  <pre><code>gc = pygsheets.authorize(outh_file=oauth_file)
  sh = gc.open(sheet_name)
  wks = sh.worksheet_by_title(wks_name)
  wks.set_dataframe(df, (1, 1))
  </code></pre>
  
  <p>Problem with above sequence is if 1st write was 3800 rows x 12 cols and 2nd write was 2400 rows x 12 cols the wks would still show data from the prior write for rows above 2400.</p>
  
  <p>My 2nd solution (basically a hack just to get it to work for me):</p>
  
  <pre><code>gc = pygsheets.authorize(outh_file=oauth_file)
  sh = gc.open(spreadsheet_name)
  wks = sh.worksheet_by_title(sheet_name)
  sh.del_worksheet(wks)
  sh.add_worksheet(sheet_name, rows=len(df) + 1, cols=len(df.columns))
  wks = sh.worksheet_by_title(sheet_name)
  wks.set_dataframe(df, (1, 1))
  </code></pre>
  
  <p>The above sequence basically does what I want but I do not like having to delete the wks (I lose all my manual formatting). I know there must be a correct way to accomplish but I do not know the pygsheets API very well.</p>
  
  <p>Will a more advanced pygsheet users please advise proper program flow and methods to use?</p>
  
  <p>TIA,
  --Rj</p>