VSCode中Python请求URL报URLError：无法解析主机名求助

我在VSCode中学习Python时，调用已确认可用的df["URL"][0]发起请求时，遇到以下错误：

URLError: <urlopen error [Errno 8] nodename nor servname provided, or not known>

原错误代码 #

# requirements
import pandas as pd
from urllib.request import Request, urlopen
from fake_useragent import UserAgent
from bs4 import BeautifulSoup

ua = UserAgent()
ua.ie

req = Request(df["URL"][0], headers={"User-Agent" : ua.ie})
html = urlopen(req).read()
soup_tmp = BeautifulSoup(html, "html.parser")
soup_tmp.find("p", "addy")  #soup_find.select_one(".addy")

可行解决方案代码 #

import requests 
req = requests.get(df["URL"][49], headers={'user-agent': ua.ie}) 
soup_tmp = BeautifulSoup(req.content, 'html.parser') 
soup_tmp.select_one('.addy') 

内容的提问来源于stack exchange，提问作者ram