5 Comments

1. 

   Hassan on 2019-11-24 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 2020-07-02 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 2020-12-11 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 2021-07-03 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 2021-11-14 at 9:49 PM

   Is this solution still working on Windows?

   Reply