5 Comments

1. 

   Hassan on November 24, 2019 at 10:30 pm

   Tnx a lot for the proposed method for Importing Google Sheets to Pandas DataFrame.

   Is there also any method for updating the google sheets without using Google Sheets API?

   Reply
2. 

   Stéphane GRAND on July 2, 2020 at 11:29 pm

   Hello,

   Thank you for your tutotial.

   When I execute your code I’ve got the following error message:

   URLError:

   I’ve check the URL manually. I’ve got the file. Everything is OK.
   I’ve check my python version installed : Python 3.7.6

   Do you have any ideas what does it come from ?

   Thank you

   Reply
   • 

     Aramis Farias on December 11, 2020 at 9:46 am

     possibly the sheet has a space in it’s name. try using the following after the definition of URL (line 9):

     URL = URL.replace(” “, “%20”)

     hope it helps =)

     Reply
3. 

   Wps on July 3, 2021 at 8:06 am

   How to fix?

   1204 def _encode_request(self, request):
   1205 # ASCII also helps prevent CVE-2019-9740.
   -> 1206 return request.encode(‘ascii’)
   1207
   1208 def _validate_method(self, method):

   UnicodeEncodeError: ‘ascii’ codec can’t encode characters in position 85-86: ordinal not in range(128)

   Reply
4. 

   Davis Rogers on November 14, 2021 at 9:49 pm

   Is this solution still working on Windows?

   Reply