access index of last element in data frame,df['date'][df.index[-1]]