title: Pandas transform csv into dict
body: <p>I have a csv like this:</p>
  <pre><code>key,value
  basico_uf_situacao_1,urb_cid_vila
  basico_uf_situacao_2,nao_urb_cid_vila
  basico_uf_situacao_3,urb_isolada
  basico_uf_situacao_4,rur_ext_urb
  basico_uf_situacao_5,rur_isol_povoado
  basico_uf_situacao_6,rur_isol_nucleo
  basico_uf_situacao_7,rur_isol_outros_aglo
  basico_uf_situacao_8,rur_excl_rur
  </code></pre>
  <p>And I'm reading it like this:</p>
  <pre><code>index = pd.read_csv(&quot;./pdfs/indice.csv&quot;, delimiter=&quot;,&quot;)
  </code></pre>
  <p>How can I transform it into a dict which I can access like this:</p>
  <p>In:</p>
  <pre><code>dict[&quot;basico_uf_situacao_1&quot;] 
  </code></pre>
  <p>Out:</p>
  <pre><code>urb_cid_vila
  </code></pre>