import csv
import requests
from bs4 import BeautifulSoup
模拟请求网页
url = "https://example.com/products"
response = requests.get(url)
soup = BeautifulSoup(response.text, 'html.parser')
提取数据（示例）
products = []
for item in soup.findall('div', class='product'):
name = item.find('h2').text.strip()
price = item.find('span', class_='price').text.strip()
link = item.find('a')['href']
products.append([name, price, link])
写入CSV文件
with open('products.csv', 'w', newline='', encoding='utf-8') as f:
writer = csv.writer(f)
写入标题
writer.writerow(['Name', 'Price', 'Link'])
# 写入每条数据
writer.writerows(products)

import pandas as pd
假设数据是字典列表
data = [
{'Name': '手机', 'Price': '¥2999', 'Link': 'https://xxx.com/1'},
{'Name': '耳机', 'Price': '¥199', 'Link': 'https://xxx.com/2'}
]
转为DataFrame并保存
df = pd.DataFrame(data)
df.to_csv('products_pandas.csv', index=False, encoding='utf-8-sig')

try:
    with open('data.csv', 'w', newline='', encoding='utf-8') as f:
        writer = csv.writer(f)
        writer.writerow(['Title', 'URL'])
        for item in items:
            title = item.get('title', '未知')
            url = item.get('url', '')
            writer.writerow([title, url])
except Exception as e:
    print(f"保存文件出错: {e}")