title: Reading csv file as dictionary using pandas
body: <p>I have the foll. csv with 1st row as header:</p>
  
  <pre><code>A      B
  test    23
  try     34
  </code></pre>
  
  <p>I want to read in this as a dictionary, so doing this:</p>
  
  <pre><code>dt = pandas.read_csv('file.csv').to_dict()
  </code></pre>
  
  <p>However, this reads in the header row as key. I want the values in column 'A' to be the keys. How do I do that i.e. get answer like this:</p>
  
  <pre><code>{'test':'23', 'try':'34'}
  </code></pre>