如何从python中将网站列表的状态作为'Yes‘或'No’导出到csv？

import csv
import requests

def check_website_status(url):
    try:
        response = requests.get(url)
        if response.status_code == 200:
            return 'Yes'
        else:
            return 'No'
    except requests.exceptions.RequestException:
        return 'No'

websites = ['https://www.example1.com', 'https://www.example2.com', 'https://www.example3.com']

with open('website_status.csv', 'w', newline='') as file:
    writer = csv.writer(file)
    writer.writerow(['Website', 'Status'])

with open('website_status.csv', 'a', newline='') as file:
    writer = csv.writer(file)
    for website in websites:
        status = check_website_status(website)
        writer.writerow([website, status])