Import Google Sheets to Pandas DataFrame without using Google Sheets API Aug 29, 2019 | Automation Scripts, Python | 5 comments Python Tutorial Python Code Snippet 5 Comments 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 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 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 Davis Rogers on November 14, 2021 at 9:49 pm Is this solution still working on Windows? Reply Submit a Comment Cancel replyYour email address will not be published. Required fields are marked *Comment Name * Email * Notify me of follow-up comments by email. Notify me of new posts by email.
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
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
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
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?
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
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 =)
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)
Is this solution still working on Windows?