We are interested in finding outlier temperatures and comparing them to the longrun average.Start a new program temp_file_stats.py from your working version ofread_temp_file.py. Comment out the line that prints out the year and temperaturefor each year in the file.Add code to find the minimum and maximum temperature for all of the years inthe file and the years they occured in. You can base your solution on thestarbucks_menu.py program we went over in lecture. Here is a transcript of howthe program should work:Temperature anomaly filename:SacramentoTemps.csvMin temp: -2.32 in 1913Max temp: 2.99 in 1889 SacramentoYear Value1880-1.561881-0.081882-0.31883-1.441884-2.291885 -1.951886-0.6318870.631888-0.7218892.991890-0.51891-1.3618921.031893-0.161894-0.011895 -1.461896-1.231897-0.831898-0.9118991.5319001.0819010.241902 -1.081903-1.11904 -0.831905-0.31

Answered: We are interested in finding outlier…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

We are interested in finding outlier temperatures and comparing them to the long
run average.
Start a new program temp_file_stats.py from your working version of
read_temp_file.py. Comment out the line that prints out the year and temperature
for each year in the file.
Add code to find the minimum and maximum temperature for all of the years in
the file and the years they occured in. You can base your solution on the
starbucks_menu.py program we went over in lecture. Here is a transcript of how
the program should work:
Temperature anomaly filename:SacramentoTemps.csv
Min temp: -2.32 in 1913
Max temp: 2.99 in 1889

Sacramento
Year Value
1880
-1.56
1881
-0.08
1882
-0.3
1883
-1.44
1884
-2.29
1885 -1.95
1886
-0.63
1887
0.63
1888
-0.72
1889
2.99
1890
-0.5
1891
-1.36
1892
1.03
1893
-0.16
1894
-0.01
1895 -1.46
1896
-1.23
1897
-0.83
1898
-0.91
1899
1.53
1900
1.08
1901
0.24
1902 -1.08
1903
-1.1
1904 -0.83
1905
-0.31

Expert Solution

Step 1

SOURCE CODE

#!/usr/bin/python3
import csv

CSV_FILE = input("Temperature anomaly file name:")

with open(CSV_FILE) as csv_file:
csv_reader = csv.reader(csv_file, delimiter=',')
row_1=next(csv_reader)
max=float(row_1[1])
min=float(row_1[1])
max_Y=row_1[0]
min_y=row_1[0]

for row in csv_reader:
if float(row[1])<min:
min=float(row[1])
min_y=row[0]
if float(row[1])>max:
max=float(row[1])
max_y=row[0]
print("Min temp:", min," in ",min_y)
print("Max temp:", max," in ",max_y)

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions