I had a similar issue and fixed it using the python-certifi-win32 package (now out of maintenance):
As of 2022 (as mentioned by Briareos386 in the comments)
pip install pip-system-certs
Original answer (out of maintenance)
pip install python-certifi-win32
now you can just use:
requests.get(url, verify=True)
and the certificate is checked using the Windows Certificate Store.
Note:
This only works if the certificate is installed in the Windows Certificate Store…