title: Counting occurence of words in CSV column and writing to another CSV?
body: <p>I have been working on making a program to open a CSV file, count the number of times the words "Info", "Low", "Medium", "High", and "Critical" appear, and have the results write to a different CSV.  Down the road, I want it to be able to parse multiple CSVs that are formatted the same way for this information and write all of the results to one CSV.  This is what I have so far:</p>
  
  <pre><code>import sys
  import csv
  import collections
  
  severity = collections.Counter()
  with open(r'C:\Report.csv', 'r') as f:
      reader = csv.reader(f)
      for row in reader:
          severity[row[3]] +=1
  
  print(severity.most_common)
  with open(r'C:\test.csv', 'a', newline='') as write_file:
      sevwrite = csv.writer(write_file, delimiter= ',',
                        quotechar=' ', quoting=csv.QUOTE_MINIMAL)
      sevwrite.writerow([severity.most_common])
  </code></pre>
  
  <p>It writes the full </p>
  
  <pre><code>&lt;bound method Counter.most_common of Counter({'Info': 510, 'Medium': 30, 'Low': 24, 'High': 7, 'Severity': 1})&gt;
  </code></pre>
  
  <p>into the Test.CSV file.  Any help is appreciated.</p>