Using Dataframe from HTML to automate input into Excel or a DB

So the code below is something I have been using for the Cryptocurrency project, the end result of this can be seen here.

The code below basically extracts data from the website, then puts it into SQL server for some processing. The data is then extracted from SQL server and published into a Google Spreadsheet, this has some graphs which are published on the page I have linked to above.

The code:

Pandas to Google Sheet

I have been working on my other side project blog on and off whilst also being sick so my level of productivity for this has dropped more than I would like. Finally feel like I have something else useful to contribute. I have posted previously about downloading from a Google Drive sheet and now I have found a handy tool that allows you to post pandas dataframes to Google Sheets. 

I started to look for this so that I could have some updating graphs sitting on my other blog. The code is below and the graphs that I am updating can be found on the following link: 

Sentiment Analysis of Twitter data on CryptoCurrencies 

The Code:

Pandas Example functions

Just a shorter post as I don't have so much time at the moment, who does in the first week back at work after Christmas? 

So below are some examples of removing duplicates and replacing values in a pandas dataframe, below the code is a screenshot of the output that the code produces.  

The code:

The Output: