title: python search in csv using headers with spaces
body: <p>When I use a column name with space in row, the script does not print anything however if I use a column name without space, the script prints the result. How can I use headers with space?</p>
  
  <pre><code>#!/usr/bin/python
  import csv
  import os
  import fnmatch
  
  rootdir = '/var/www/html/storage/DATA/'
  pattern = 'file**.csv'
  
  for root, dirs, files in os.walk(rootdir):
          for filename in fnmatch.filter(files,pattern):
                  path = os.path.join(root, filename)
                  with open(path) as f:
                          reader = csv.DictReader(f)
                          for row in reader:
                  #if row['newColor'] == 'blue': #This works.
                  if row['cid number'] == '998': #This does not work.
                          print(row['oldColor'])
  
  
  Sample Data
  market    brand    type    newColor    oldColor    cid number    length
  SFO    6754    x    blue    orange    998    6
  CHI    6754    x    green    black    932    6
  ATL    6766    x    blue    yellow    822    6
  </code></pre>