import csv as c
import math as m

inDataFile = '2019_09_calgary_hourly.csv'
outFileName = 'results.txt'

FIELD_YEAR = 5
FIELD_MONTH = 6
FIELD_DAY = 7
FIELD_HOUR = 8
FIELD_TEMP = 9

userDataStr = input('Enter a YEAR, Month and day e.g. 2019-09-01: ').split('-')

userYear = (userDataStr[0])
userMonth = (userDataStr[1])
userDay = (userDataStr[2])

currentColdestTemp = float(9999999999.99)
currentColdestHour = ['Not set yet!']



with open(inDataFile, 'r') as datafile, open(outFileName, 'w') as resultsFile:
    csvFile = c.reader(datafile, dialect='excel')
    next(csvFile, None)
    for record in csvFile:
        fileYear = record[FIELD_YEAR]
        fileMonth = record[FIELD_MONTH]
        fileDay = record[FIELD_DAY]
        fileHour = record[FIELD_HOUR]
        fileTemp = float(record[FIELD_TEMP])
        if fileTemp < currentColdestTemp:
            list.clear(currentColdestHour)
            currentColdestHour.append(fileHour)
            currentColdestHour.append(fileTemp)
            currentColdestTemp = fileTemp
    resultsFile.write(f'The coldest hour is : {currentColdestHour}\n')
print('Done...')