Python Tutorial
Python Code Snippet
Aug 29, 2019 | Automation Scripts, Python | 5 comments
Subscribe My YouTube Channel
Cookie | Duration | Description |
---|---|---|
cookielawinfo-checkbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
cookielawinfo-checkbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
cookielawinfo-checkbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |
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?