Instrument = pd.read_json(‘https://assets.upstox.com/market-quote/instruments/exchange/NSE.json.gz’)
Instrument
Error show
URLError: <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1000)>
@ANAND_1674204 This issue seems to be specific to your local environment. This error occurs when the pandas library attempts to read data from “https://assets.upstox.com” but fails to verify the SSL certificate. The system is unable to retrieve the local issuer certificate, indicating that your machine is either missing the required root Certificate Authority (CA) or unable to verify it.
If your system is missing root certificates, try below and let me know if it works, Thanks
pip install --upgrade certifi
1 Like
pip install --upgrade certifi
Requirement already satisfied: certifi in [c:\users\anand\appdata\local\programs\python\python312\lib\site-packages](file:///C:/users/anand/appdata/local/programs/python/python312/lib/site-packages) (2024.7.4)Note: you may need to restart the kernel to use updated packages. Collecting certifi Downloading certifi-2025.1.31-py3-none-any.whl.metadata (2.5 kB) Downloading certifi-2025.1.31-py3-none-any.whl (166 kB) Installing collected packages: certifi Attempting uninstall: certifi Found existing installation: certifi 2024.7.4 Uninstalling certifi-2024.7.4: Successfully uninstalled certifi-2024.7.4 Successfully installed certifi-2025.1.31
[notice] A new release of pip is available: 24.2 → 25.0.1 [notice] To update, run: python.exe -m pip install --upgrade pip
import pandas as pd
stock = ‘IRFC’
Instrument = pd.read_json(‘https://assets.upstox.com/market-quote/instruments/exchange/NSE.json.gz’)
#InstrumentKey = Instrument[Instrument[‘tradingsymbol’] == stock]
#InstrumentKey
Instrument
URLError: <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1000)>