尝试使用Pandas库，它会自动从URL下载csv，现在Pandas Read CSV Documentation。

import pandas as pd
csv_url = 'csv_url'
df=pd.read_csv(csv_url)

或者，您可以使用lxml并请求库来抓取csv链接。从网页中获取link元素的XPath，并将链接URL字符串保存为var。
注意lxml作为列表返回。

from lxml import html
from lxml import etree
import requests

            
url = 'website'
#Open webpage
session_requests = requests.session()
result = session_requests.get(url)
tree = html.fromstring(result.text)

#xpath to csv URL (inspect element and right click to get xpath)

url_list = tree.xpath('xpath') #to get the link add /@href to the end of your xpath

#xpath returns link as a list, this just pulls link text out of the list
csv_url = url_list[0]