title: Set the headers using pandas.read_csv
body: <p>I have a csv file that I read into a dataframe using the pandas API. 
  I intend to set my own header instead of the default first row. (I also get rid of some of the rows.) How do I best achieve this?</p>
  
  <p>I tried the following but this didn't work as expected:</p>
  
  <pre><code>header_row=['col1','col2','col3','col4', 'col1', 'col2'] # note the header has duplicate column values
  df = pandas.read_csv(csv_file, skiprows=[0,1,2,3,4,5], names=header_row)
  </code></pre>
  
  <p>This gives following error -</p>
  
  <pre><code>File "third_party/py/pandas/io/parsers.py", line 187, in read_csv
  File "third_party/py/pandas/io/parsers.py", line 160, in _read
  File "third_party/py/pandas/io/parsers.py", line 628, in get_chunk
  File "third_party/py/pandas/core/frame.py", line 302, in __init__
  File "third_party/py/pandas/core/frame.py", line 388, in _init_dict
  File "third_party/py/pandas/core/internals.py", line 1008, in form_blocks
  File "third_party/py/pandas/core/internals.py", line 1036, in _simple_blockify
  File "third_party/py/pandas/core/internals.py", line 1068, in _stack_dict
  IndexError: index out of bounds
  </code></pre>
  
  <p>I then tried settings the columns via </p>
  
  <pre><code>df.columns = header_row
  </code></pre>
  
  <p>But this error-ed out probably because of duplicate column values.</p>
  
  <pre><code>File "engines.pyx", line 101, in pandas._engines.DictIndexEngine.get_loc    
  (third_party/py/pandas/src/engines.c:2498)
  File "engines.pyx", line 107, in pandas._engines.DictIndexEngine.get_loc 
  (third_party/py/pandas/src/engines.c:2447)
  Exception: ('Index values are not unique', 'occurred at index entity')
  </code></pre>
  
  <p>I am using pandas 0.7.3 version.
  From the documentation - </p>
  
  <p><strong>names : array-like
      List of column names</strong></p>
  
  <p>I am sure I am missing something simple here. Thanks for any help here.</p>