title: Loop through multiple csv files, copying only certain columns to new files
body: <p>I have a number of .csv files in a folder (1.csv, 2.csv, 3.csv, etc.) and I need to loop over them all. The output should be a corresponding NEW file for each existing one, but each should only contain 2 columns. </p>
  
  <p>Here is a sample of the csv files:</p>
  
  <pre><code>004,444.444.444.444,448,11:16 PDT,11-24-15
  004,444.444.444.444,107,09:55 PDT,11-25-15
  004,444.444.444.444,235,09:45 PDT,11-26-15
  004,444.444.444.444,241,11:00 PDT,11-27-15
  </code></pre>
  
  <p>And here is how I would like the output to look:</p>
  
  <pre><code>448,11-24-15
  107,11-25-15
  235,11-26-15
  241,11-27-15
  </code></pre>
  
  <p>Here is my working attempt at achieving this with Python:</p>
  
  <pre><code>import csv
  import os
  import glob
  
  path = '/csvs/'
  for infile in glob.glob( os.path.join(path, '*csv') ):
  
  
      inputfile = open(infile, 'r') 
      output = os.rename(inputfile + ".out", 'w')
  
  #Extracts the important columns from the .csv into a new file
  with open(infile, 'r') as source:
      readr = csv.reader(source)
      with open(output,"w") as result:
          writr = csv.writer(result)
          for r in readr:
              writr.writerow((r[4], r[2]))
  </code></pre>
  
  <p>Using only the second half of this code, I am able to get the desired output by specifying the input files in the code. However, this Python script will be a small part of a much larger bash script that will be (hopefully) fully automated. </p>
  
  <p><strong>How can I adjust the input of this script to loop over each file and create a new one with just the 2 specified columns?</strong></p>
  
  <p>Please let me know if there is anything I need to clarify.</p>