title: Python dataframe - proper date indexing
body: <p>I can't get my head around this. After importing a csv time series with dates and prices as a dataframe, I want to index the date column.</p>
  
  <pre><code>df = pd.read_csv("pricespanda.txt")
  
          Date  Price1  Price2
  0   1-1-2017     100     101
  1   2-1-2017     103     102
  2   3-1-2017     109     116
  </code></pre>
  
  <p>I have tried:</p>
  
  <pre><code>df = df.set_index(pd.DatetimeIndex(df['Date']))
  
  df = df.loc[:,['Price1','Price2']]
  </code></pre>
  
  <p>but what I get is:</p>
  
  <pre><code>            Price1  Price2
  Date                      
  2017-01-01     100     101
  2017-02-01     103     102
  2017-03-01     109     116
  </code></pre>
  
  <p>Whilst what I want is:</p>
  
  <pre><code>            Price1  Price2               
  2017-01-01     100     101
  2017-02-01     103     102
  2017-03-01     109     116
  </code></pre>
  
  <p>How can I achieve this please; after indexing the date column keeps the name "Date"...I can't seem to be able to get rid of it...</p>