title: Return row from CSV, if matches two criteria
body: <p>The following script works where REPORT_TYPE is SOD, but what if I want it also to have the criteria of a field called DATE in my CSV to be equal to 10-24-2017? The format of the DATE field also includes hours, minutes, seconds, but I want to ignore them (e.g. 10-24-2017T23:59:00).</p>
  
  <pre><code>path = "C:/python-testing/*.csv"
  
  for fname in glob.glob(path):
  print(fname)
  
  with open(fname, 'rb') as f:
      reader = csv.DictReader(f)
      rows = [row for row in reader if row['REPORT_TYPE'] == 'SOD  ']
  
  for row in rows:
      print row
  </code></pre>
  
  <p>I tried the following but it does not like the AND in there and gives me an invalid syntax error.</p>
  
  <pre><code>rows = [row for row in reader if row['REPORT_TYPE'] == 'SOD  ' AND ['DATE'] like '10-24-2017%']
  </code></pre>