Read data from Google Sheet into a Python Pandas DataFrame

Recently I have done lot of data analysis in Python (more details about this in another post) and have started to like Pandas a lot. The other day I had to process some data from a Google Sheet and was wondering whether I could read the data as a Pandas DataFrame and after a quick search found the gspread package and within a few lines of code I was able to read data from Google Sheet into a Pandas DataFrame.

I thought of sharing the code here so that it would be helpful for others and I would also know whether to search for it when I need it the next time ­čÖé

So here we go, this is all we need. Of course you need to install the gspread and pandas packages.

Related posts

Tags: , ,

4 Comments so far

Follow up comments through RSS Feed | Post a comment

Leave a Reply

Your email address will not be published. Required fields are marked *