如何从该网站自动抓取csv文件？

import requests
from bs4 import BeautifulSoup

# 发送网络请求
url = "目标网站的URL"
response = requests.get(url)

# 解析HTML
soup = BeautifulSoup(response.text, "html.parser")

# 定位CSV链接
csv_link = soup.find("a", href=lambda href: href.endswith(".csv"))

# 下载CSV文件
if csv_link:
    csv_url = csv_link["href"]
    csv_response = requests.get(csv_url)
    with open("保存CSV文件的路径", "wb") as file:
        file.write(csv_response.content)
        print("CSV文件下载完成")
else:
    print("未找到CSV文件链接")