Сохранить в CSV File

[BillyRubyn]

• Windows 10
• Python 3.8

Вот мой код:

• from urllib.request import urlopen
  from bs4 import BeautifulSoup
  import csv
  
  FILE = 'apple.csv'
  HOST = 'https://megashop.md'
  html = urlopen("https://megashop.md/ro/telefoane-accesorii/Telefoane/Telefoane-Apple")
  
  bsObj = BeautifulSoup(html, 'html.parser')
  
  names = bsObj.findAll('div', class_='product_card_title')
  for name in names:
      print(name.get_text())
  
  prices = bsObj.findAll('div', class_='product_card_price')
  for price in prices:
      print(price.get_text())
  
  image = bsObj.findAll('img')
  for image in bsObj.findAll('img'):
      if "src" in image.attrs:
          print(image.attrs['src'])
  
  link = bsObj.findAll('a', class_='product_card_image')
  for link in bsObj.findAll('a', class_='product_card_image'):
      if "href" in link.attrs:
          print(HOST + link.attrs['href'])

Не знаю как вывести все это в CSV file, чтобы я мог дальше работать с таблицей в Excel