将数据列表从Craigslist导出到CSV

import requests
from bs4 import BeautifulSoup
import csv

# 发送HTTP请求获取网页内容
url = "https://www.craigslist.org/about/sites"
response = requests.get(url)
html = response.text

# 解析HTML页面
soup = BeautifulSoup(html, "html.parser")

# 提取数据
data = []
for row in soup.find_all("tr"):
    cells = row.find_all("td")
    if len(cells) == 3:
        city = cells[0].text.strip()
        state = cells[1].text.strip()
        url = cells[2].find("a")["href"]
        data.append([city, state, url])

# 保存为CSV文件
filename = "craigslist_data.csv"
with open(filename, "w", newline="") as csvfile:
    writer = csv.writer(csvfile)
    writer.writerow(["City", "State", "URL"])  # 写入表头
    writer.writerows(data)  # 写入数据

print("数据已成功导出到CSV文件:", filename)