Mar 18: 13 Jan 2:27 Sep 09 : 6 Aug 16: 192 Apr 5 : 44 Each line of the file lists the date of the reading and the number of broken-down busses that day. The dates are not in any particular order. The date is listed with the standard 3-letter month name abbreviation with the first letter capitalized, followed by a single space, then date in 1 or 2 digits (with a possible leading zero if date is less than 10). The date field is separated from the bus count with a colon, with any number of optional whitespaces before and after the colon. Write a function named filterDays that takes as parameters an input file name, an integer lower bound, and an integer upper bound. It should return a list of all days for which the broken bus count was between the lower and upper bounds (both inclusive). The items of the list should be tuples of the form (mm/dd', count), where mm and dd are 2-digit numeric values. For instance, with the sample input file above, a lower bound of 10, and an upper bound of 50, the resulting list should look like this: [('03/15, 13), ('01/02, 27), ('04/05', 44)]

Mar 18: 13 Jan 2:27 Sep 09 : 6 Aug 16: 192 Apr 5 : 44 Each line of the file lists the date of the reading and the number of broken-down busses that day. The dates are not in any particular order. The date is listed with the standard 3-letter month name abbreviation with the first letter capitalized, followed by a single space, then date in 1 or 2 digits (with a possible leading zero if date is less than 10). The date field is separated from the bus count with a colon, with any number of optional whitespaces before and after the colon. Write a function named filterDays that takes as parameters an input file name, an integer lower bound, and an integer upper bound. It should return a list of all days for which the broken bus count was between the lower and upper bounds (both inclusive). The items of the list should be tuples of the form (mm/dd', count), where mm and dd are 2-digit numeric values. For instance, with the sample input file above, a lower bound of 10, and an upper bound of 50, the resulting list should look like this: [('03/15, 13), ('01/02, 27), ('04/05', 44)]

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

Similar questions

The following is a sample of the order data (Customer#, Order#, OrderQty, UnitPrice) to be processed. Store the data in a text file named Order.txt. You may use Notepad to enter the data. 0155, 76533, 3, 10.950140, 75446, 12, 8.500150, 75550, 1, 89.950145, 75648, 25, 2.500130, 76360, 5, 17.90Create a form, ProcessOrder, that reads each order record, computes the extended cost, and displays Cust#, Order#, OrderQty, UnitPrice and ExtendedCost in a ListBox, with the columns aligned.
Using the MATLAB editor, create a script m-file which includes a header block and comments: Create a matrix which holds values of: y=a^x where a is a column array A have values in the range 1-5 with 0.5 increments x is a row array X having integer values 1-5 Display the matrix results Save the script and publish function to create a pdf file from the script in a file named "ECE105_Wk2_L1_Prep_2"
In python
Add comments for Program 04
I need the answer as soon as possible
Exercise 2: A vehicle inspection station keeps records of its checking services in a text file (called "inspection.txt"). Each line corresponds to a checking visit and contains the following information separated by slashes (*/"). The vehicle's registration number (serial number and series), the inspection performed (Assuming that there are four kind of services: Periodic, Pre- Sale, Emission, Other), and the service duration in minutes. The figure below shows a few lines of input file. Write a python program that asks the user to enter a vehicle registration number, then reads the input file and displays for each provided service on that vehicle, the total duration and the number of visits. Display an error using the proper exception if the file does not open/exist. Use exception to count and display the number of records having incorrect format of the data in the file (such as, serial number is not digit, unknown service category). Enter vehicle's registration number: 7203 RS…
please code in python The data for this product is stored in the text file named GasPrice.txt [The image]. The file contains the weekly average prices for a gallon of gas in the United States, beginning on April 5th, 1993, and ending on August 26th, 3013. The following is a sample of the first few lines of the data file. Each line in the file contains the average price for a gallon of gas on a specific date. Each line is formatted in this way: MM-DD-YYYY:Price Where MM is the two-digit moth, DD is two-digit day, and YYYY is the four-digit year. Price is the average price per gallon of gas on the specific day. For this project, you are to develop one or more programs that read the data from the data file, and perform these tasks: Average Price Per Year: Calculate the average price of gas per year, for each year in the file. Average Price Per Month: Calculate the average price for each month in the file. Highest and Lowest Prices Per Year: For each year in the data file,…
DescriptionWrite a program to compute average grades for a course. The course records are in a single file and are organized according to the following format: each line contains a student's first name, then one space, then the student's last name, then one space, then some number of quiz scores that, if they exist, are separated by one space. Each student will have zero to ten scores, and each score is an integer not greater than 100. Your program will read data from this file and write its output to a second file. The date in the output file will be nearly the same as the data in the input file except that you will print the names as last-name, first-name; each quiz score, and there will be one additional number at the end of each line:the average of the student's ten quiz scores.Both files are parameters. You can access the name of the input file with argv[1]. and the name of the output file with argv[2].The output file must be formatted as described below: 1. First and last names…
CODE SHOULD BE PYTHON:
The file london_weather.csv contains weather data for the years 1979 to 2020. The first five lines of this file are: date,cloud_cover,sunshine,global_radiation,max_temp,mean_temp,min_temp,precipitation,pressure,snow_depth19790101,2,7,52,2.3,-4.1,-7.5,0.4,101900,919790102,6,1.7,27,1.6,-2.6,-7.5,0,102530,819790103,5,0,13,1.3,-2.8,-7.2,0,102050,419790104,8,0,13,-0.3,-2.6,-6.5,0,100840,2 Note, in particular, that the dates are given as eight-digit integers in the format YYYYMMDD. There appears to be some inconsistencies in this data, as there are rows for which the column max_temp contains an entry that is smaller than the corresponding entry in min_temp. Write a Python function wrong_temperature(year) that returns the number of days in a given year for which the column max_temp contains an entry that is smaller than the corresponding entry in the column min_temp.
Write a complete program in C to solve this problem.
Code