title: Get Date of last record in Date indexed pandas dataframe
body: <p>I am reading an End of Day price csv file and use the date column to index the dataframe.  I want to check the date of the last record.  I get the index value location, but have not figured out how to get the actual date.</p>
  
  <p>CSV file has format of Date, Open, High, Low, ....</p>
  
  <p>Here Date is in the form 2014-07-28.</p>
  
  <pre><code>import pandas as pd
  df = pd.read_csv('c:/datafile.csv', index_col='Date')
  lastrec = len(df.index) -1
  
  # how to get 'Date' Value for this last record?
  df.iloc[lastrec]
  # gives me the Open, High, .... columns and values
  
  df.iloc[lastrec].index 
  # gives me the list of columns
  </code></pre>
  
  <p>All my other ideas have just given me errors.</p>
  
  <p>Still learning Python and Pandas by doing this project.</p>
  
  <p>How can I get the index value (DATE) from the last record?</p>