title: Zip two lists into text file
body: <p>I'm trying to create a program to replace Excel in creating CSV's (for personal use). The below code, however, duplicates the values from whatever is in the first text file. For example, the first text file I have is "SourceCAS Numbers". </p>
  
  <p>When it zips it produces the following
  <code>109922, 109922</code></p>
  
  <p>When it should be doing the following:
  <code>71751412, Abamectin</code></p>
  
  <p>Here's my code:</p>
  
  <pre><code>import os import csv import time
  
  #----Federal/State----#
  #Ask the user to fill out a text file with Source CAS numbers
  print("Input the source CAS numbers with which you're comparing against")
  os.system("notepad.exe C:\sourcecas.txt")
  time.sleep(15)
  
  #Take the text file with Source CAS Numbers and make it into a list
  sourcecas = []
  file = open(r'C:\sourcecas.txt', 'r')
  sourcecas = file.readlines()
  sourcecas[:] = [line.rstrip('\n') for line in sourcecas]
  
  #Ask the user to fill out a text file with Source CAS names
  print("Input the source CAS names in alphabetical order")
  os.system("notepad.exe C:\sourcecasnames.txt")
  time.sleep(15)
  
  #Take the text file with Source CAS Names and make it into a list
  sourcecasnames = []
  file = open(r'C:\sourcecas.txt', 'r')
  sourcecasnames = file.readlines()
  sourcecasnames[:] = [line.rstrip('\n') for line in sourcecasnames]
  
  #Zip the source cas numbers and names into a CSV file
  zip(sourcecas, sourcecasnames)
  with open(r'C:\CAS-S.csv', 'w') as f:
  writer = csv.writer(f, delimiter=',')
  writer.writerows(zip(sourcecas, sourcecasnames))
  </code></pre>