picture 1 shows the coding task to perform on a file named 'df_fuel_ckan.csv' while picture 2 shows my code the question asked for and the second block of code is me testing my function on the file. how do i get past the ' AttributeError: type object 'datetime.datetime' has no attribute 'datetime''. And also is my initial block of code correct Implement the following function according to this specification:Function name: readDataByDateFunction parameters:f: the file handle to read data fromstartDate: the date from which to start reading data• endDate: the date at which to stop reading data• col: the column number read data fromFunction return values: a tuple of 2 lists: the first containing the list of a datetime objects for each processed line, and the second containing the column value.Function description:The function should loop over the data and return values for the dates and values for the specified column for all lines after or equal to the startDate and before the endDate (not including the endDate)Additional information and hints:You can take advantage of the fact that the input file is ordered when looping over the contents of the file. The loop should continue until the end date (or the end of the file) is reached. There is more than one way to achieve this the particular solution is left up to you!Before the loop you will want to create two lists to store the outputs - one for the dates and one for the column values.Inside the loop you should read a line from the file - then extract the date from the first column. If it is before the start date - just use a continue statement to move to the next iteration. If the date is equal to or after the end date then you can use a break statement to exit the loop. If theline is in the valid date period then you should extract the requested column - as specified in the col parameter and then append the datetime object to your dates list, and the value your column list.Outside the loop after it has terminated you should return the dates and the column values in two lists.To get full marks on the question you must implement a function meeting the specification above. You are recommended to follow the hints well - but are free to implement the algorithm as you see fit. In [3]: # write your code here (creating the function)from datetime import datetimedef readDataByDate(f, startDate, endDate, col):#Initialize empty lists for the outputdates[]values [1#Loop through the filefor line in f:# Split the line into columnscolumnsline.strip().split(','))# Extract the date from the first columndatete datetime.strptime(columns [0], '%Y-%m-%d %H:M:S+00')# Check if the date is within the specified rangeif datestartDate:continueelif date endDate:break# Extract the value from the specified columnvalue float(columns [col])# Append the date and value to the output listsdates.append(date)values.append(value)# Return the output lists as a tuplereturn (dates, values)v BIM & Av Tiv HvText MarkdownWrite a test function in the cell below. This function should open the file, read the header lines, then call your function with some sample dates and retrieve thecolumn for gas electricity production (column 1), Label the return values appropriately (you'll probably want to use tuple unpacking) to get two lists: one ofdatetime objects and one of values from the column. Print them out one pair per line of date and value. Compare these with the values in your input data tomake sure it is working.You might want to use the following idiom to print out values from two lists of the same size on the same line to make the output easier to check against yourinput file.# create list aa = [1,2,3,4]#create list bb= ['a', 'b', 'c','d']#join the lists into a list of tuples using zip and then tuple unpacking#to grab the values from each list and label with c an difor c,d in zip(a,b):print(c,d)In [4]: # write your code here (testing the function)def test readDataByDate():#Opening the filewith open('df_fuel_ckan.csv') as f:a Reading the header linesIn [4]: write your code here (testing the function)deftest_readDataByDate():#Opening the filewith open('df_fuel_ckan.csv') as f:# Reading the header linesOut [4]:easier to check against your input file.#create list aa [1,2,3,4]=#create list bb = ['a', 'b', 'c','d']#join the lists into a list of tuples using zip and then tuple unpacking#to grab the values from each list and label with c an dfor c,d in zip(a,b):print(c,d)In [5]:header1 f.readline().strip()header2 f.readline().strip()#calling function with example datesstart_date datetime.datetime (2009, 1, 1)end date datetime.datetime (2010, 1, 1)dates, values readDataByDate(f, start_date, end_date, 1)#Printing the results one pair per line of date and value.for date, value in zip(dates, values):print (f"(date): {value)")test_readDataByDate()AttributeErrorCell In[4], line 17Traceback (most recent call last)for date, value in zip(dates, values):print (f"(date): (value)")1516--- 17 test_readDataByDate()Cell In[4], line 9, in test_readDataByDate()7 header2f.readline().strip()8# calling function with example dates---- 9 start date datetime.datetime (2009, 1, 1)10 end datedatetime.datetime (2010, 1, 1)11 dates, valuesreadDataByDate(f, start_date, end_date, 1)AttributeError: type object 'datetime.datetime' has no attribute 'datetime'nem mewwwwww.[1

Question

picture 1 shows the coding task to perform on a file named 'df_fuel_ckan.csv' while picture 2 shows my code the question asked for and the second block of code is me testing my function on the file. how do i get past the                 ' AttributeError: type object 'datetime.datetime' has no attribute 'datetime''. And also is my initial block of code correct Implement the following function according to this specification:Function name: readDataByDateFunction parameters:f: the file handle to read data fromstartDate: the date from which to start reading data• endDate: the date at which to stop reading data• col: the column number read data fromFunction return values: a tuple of 2 lists: the first containing the list of a datetime objects for each processed line, and the second containing the column value.Function description:The function should loop over the data and return values for the dates and values for the specified column for all lines after or equal to the startDate and before the endDate (not including the endDate)Additional information and hints:You can take advantage of the fact that the input file is ordered when looping over the contents of the file. The loop should continue until the end date (or the end of the file) is reached. There is more than one way to achieve this the particular solution is left up to you!Before the loop you will want to create two lists to store the outputs - one for the dates and one for the column values.Inside the loop you should read a line from the file - then extract the date from the first column. If it is before the start date - just use a continue statement to move to the next iteration. If the date is equal to or after the end date then you can use a break statement to exit the loop. If theline is in the valid date period then you should extract the requested column - as specified in the col parameter and then append the datetime object to your dates list, and the value your column list.Outside the loop after it has terminated you should return the dates and the column values in two lists.To get full marks on the question you must implement a function meeting the specification above. You are recommended to follow the hints well - but are free to implement the algorithm as you see fit. In [3]: # write your code here (creating the function)from datetime import datetimedef readDataByDate(f, startDate, endDate, col):#Initialize empty lists for the outputdates[]values [1#Loop through the filefor line in f:# Split the line into columnscolumnsline.strip().split(','))# Extract the date from the first columndatete datetime.strptime(columns [0], '%Y-%m-%d %H:M:S+00')# Check if the date is within the specified rangeif datestartDate:continueelif date > endDate:break# Extract the value from the specified columnvalue float(columns [col])# Append the date and value to the output listsdates.append(date)values.append(value)# Return the output lists as a tuplereturn (dates, values)v BIM & Av Tiv HvText MarkdownWrite a test function in the cell below. This function should open the file, read the header lines, then call your function with some sample dates and retrieve thecolumn for gas electricity production (column 1), Label the return values appropriately (you'll probably want to use tuple unpacking) to get two lists: one ofdatetime objects and one of values from the column. Print them out one pair per line of date and value. Compare these with the values in your input data tomake sure it is working.You might want to use the following idiom to print out values from two lists of the same size on the same line to make the output easier to check against yourinput file.# create list aa = [1,2,3,4]#create list bb= ['a', 'b', 'c','d']#join the lists into a list of tuples using zip and then tuple unpacking#to grab the values from each list and label with c an difor c,d in zip(a,b):print(c,d)In [4]: # write your code here (testing the function)def test readDataByDate():#Opening the filewith open('df_fuel_ckan.csv') as f:a Reading the header linesIn [4]: write your code here (testing the function)deftest_readDataByDate():#Opening the filewith open('df_fuel_ckan.csv') as f:# Reading the header linesOut [4]:easier to check against your input file.#create list aa [1,2,3,4]=#create list bb = ['a', 'b', 'c','d']#join the lists into a list of tuples using zip and then tuple unpacking#to grab the values from each list and label with c an dfor c,d in zip(a,b):print(c,d)In [5]:header1 f.readline().strip()header2 f.readline().strip()#calling function with example datesstart_date datetime.datetime (2009, 1, 1)end date datetime.datetime (2010, 1, 1)dates, values readDataByDate(f, start_date, end_date, 1)#Printing the results one pair per line of date and value.for date, value in zip(dates, values):print (f&#34;(date): {value)&#34;)test_readDataByDate()AttributeErrorCell In[4], line 17Traceback (most recent call last)for date, value in zip(dates, values):print (f&#34;(date): (value)&#34;)1516---> 17 test_readDataByDate()Cell In[4], line 9, in test_readDataByDate()7 header2f.readline().strip()8# calling function with example dates----> 9 start date datetime.datetime (2009, 1, 1)10 end datedatetime.datetime (2010, 1, 1)11 dates, valuesreadDataByDate(f, start_date, end_date, 1)AttributeError: type object 'datetime.datetime' has no attribute 'datetime'nem mewwwwww.[1

Accepted Answer

python is interpreted language which is used to develop applications and many more. It has easy…