Question: Please, write a Python program to create and interact with a database. You are given a file containing temperature readings for each day of the
Please, write a Python program to create and interact with a database. You are given a file containing temperature readings for each day of the week. Using the SQLite connector, your program should perform the following steps:
Create an SQLite database
Create a table with the following fields:
a ID primary key
b DayOfWeek String
c TemperatureValue float
Read the input file and insert each piece of data into your database table
Execute the SQL commands to compute the average temperature for Sunday and Thursday, and print the results to the console. Friday
Friday
Wednesday
Sunday
Tuesday
Monday
Wednesday
Monday
Sunday
Thursday
Thursday
Friday
Sunday
Sunday
Friday
Saturday
Monday
Monday
Monday
Sunday
Monday
Wednesday
Monday
Friday
Thursday
Tuesday
Monday
Tuesday
Thursday
Saturday
Wednesday
Wednesday
Sunday
Friday
Thursday
Friday
Saturday
Friday
Thursday
Tuesday
Friday
Monday
Monday
Thursday
Thursday
Sunday
Wednesday
Tuesday
Tuesday
Monday
Sunday
Wednesday
Wednesday
Saturday
Tuesday
Wednesday
Monday
Thursday
Saturday
Tuesday
Saturday
Friday
Saturday
Saturday
Sunday
Sunday
Sunday
Wednesday
Sunday
Wednesday
Saturday
Thursday
Tuesday
Monday
Thursday
Sunday
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
