如何检查存储在CSV文件中的多个URL的URL状态并将结果保存到新的CSV文件

import csv
import requests

# 读取CSV文件
def read_csv(file_path):
    urls = []
    with open(file_path, 'r') as csv_file:
        reader = csv.reader(csv_file)
        for row in reader:
            urls.append(row[0])
    return urls

# 检查URL状态
def check_url_status(url):
    try:
        response = requests.get(url)
        return response.status_code
    except requests.exceptions.RequestException:
        return "Error"

# 保存结果到新的CSV文件
def save_to_csv(data, file_path):
    with open(file_path, 'w', newline='') as csv_file:
        writer = csv.writer(csv_file)
        for row in data:
            writer.writerow(row)

# 主函数
def main(input_file, output_file):
    # 读取CSV文件
    urls = read_csv(input_file)

    # 检查URL状态并保存结果
    result = []
    for url in urls:
        status = check_url_status(url)
        result.append([url, status])
    
    # 保存结果到新的CSV文件
    save_to_csv(result, output_file)

# 运行主函数
if __name__ == "__main__":
    input_file = "input.csv"  # 输入CSV文件路径
    output_file = "output.csv"  # 输出CSV文件路径
    main(input_file, output_file)