title: Scrape information from multiple URLs listed in a CSV using BeautifulSoup and then export these results to a new CSV file
body: <p>I have a 45k+ rows CSV file, each one containing a different path of the same domain - which are structurally identical to each other - and every single one is clickable. I managed to use BeautifulSoup to scrape the title and content of each one and through the <code>print</code> function, I was able to validate the scraper. However, when I try to export the information gathered to a new CSV file, I only get the last URL's street name and description, and not all of them as I expected.</p>
  
  <pre><code>from bs4 import BeautifulSoup
  import requests
  import csv
  
  with open('URLs.csv') as csvfile:
      reader = csv.DictReader(csvfile)
      for row in reader:
          site = requests.get(row['addresses']).text
          soup = BeautifulSoup(site, 'lxml')
          StreetName = soup.find('div', class_='hist-title').text
          Description = soup.find('div', class_='hist-content').text
  with open('OutputList.csv','w', newline='') as output:
      Header = ['StreetName', 'Description']
      writer = csv.DictWriter(output, fieldnames=Header)
  
      writer.writeheader()
      writer.writerow({'StreetName' : StreetName, 'Description' : Description})
  </code></pre>
  
  <p>How can the output CSV have on each row the street name and description for the respective URL row in the input CSV file?</p>