I have a csv file, which has couple of columns. The one I’m interested is ‘Date’ column and more specifically I’m interested by the first row of that column, the first date that appears.

So i have a file that i read as a csv using pandas:

FILE = pd.read_csv(FILENAME)

# doesnt work
last_scraped_date = FILE['Date'][0]

test_last_date = FILE.iloc[1]['Date']

the code above just prints nan. However if i directly print FILE['Date'] it starts printing me the whole column.

All i want is to print the first row of that ‘Date’ column.