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

Python Code please Popular Names The 2 data files: boynames.txt and girlnames.txt each contain a list of the 1000 most popular names for boys and girls in the U.S. for the year 2021 as compiled by the Social Security Administration. These are blank-delimited files where the names are listed in order of popularity (the most popular name is listed first and the 1000th most popular name listed last). Each line consists of the name followed by a blank space and then the number of registered births using that name in the year. Write a program that reads both the girl's and boy's files into memory using a dictionary. The key should be the name and value should be a user defined object which is the count and rank of the name. Allow the user to input a name, the program should find the name (regardless of user's input letter case - i.e. upper or lower case) in the dictionary and print out the rank and the number of names. If the name isn't a key in the dictionary, then the program should…
O kgeme: ot Co htioseeningodmataorkconlaundh Readng r Excel File I/O The attached Distances xlsx file contains a spreadsheet with the pairwise distances in mies of the top 100 US cities by population. A preview of the spreadsheet is shown below. The first row and first column contain the city names using the following format: city name comma space capitalized state abbreviation, e.g, Nashville, TN. Note that the very first cell of the spresheet, A1, is blank. Write a function called get_distance that accepts two character vector inputs representing the names of two cities. The functian returns the distance between them as an output argument called distance. For example, the cali get_distance('Seattle, WA', Miami, FL') should return 3723. If one ar both of the specified cities are not in the file, the function returns 1. Your function should load the data only once. File VO is a time consuming operation. Loading the date multiple times is will likely cause a time-out error when…
Question The Gregorian calendar is commonly used to mark the passing of time, however, it is not the only possibility. The World calendar is one alternative. Features of the World calendar are as follow: There are 12 months: January, February, March, April, May, June, July, August, September, October, November, December. January, April, July and October have 31 days, all the rest have 30 days. There are 7 days in every week: Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday. A date always occurs on the same day of the week regardless of year. The year starts on Sunday 1st January. The last day of the year is World day. It occurs between December of the current year and January of the following year. Every leap year, a Leapyear day occurs between June and July. (A leap year is a year that is divisible by 4 and not 100, unless it is divisible by 400.) Example World calendar dates: 1st January 2023, World day 2022, 23rd March 1919, Leapyear day 2024. A date can expressed as a…
PYTHONPLEASE ALSO SHARE CODE THROUGH LINK: online-python(dot)comAlso screenshot code with correct indentation Create a python program that reads the student information from a tab separated values (tsv) file. The python program then must creates a text file that will records the course grades of the students. Each row of the tsv file contains the Last Name, First Name, Midtrm1 score, Midtrm2 score, and the Final score of a student. A sample of the student information is provided in StudentInfoScore.tsv. Assume the number of students is at least 1 and at most 20. The program performs the following tasks: Read the file name of the tsv file from the user. Open the tsv file and read the student information. Compute the average exam score of each student. Assign a letter grade to each student based on the average exam score in the following scale: A: 90 =< x B: 80 =< x < 90 C: 70 =< x < 80 D: 60 =< x < 70 F: x < 60 Compute the average of each exam. Output the…
The file disney_characters.csv contains a list of some Disney characters with their names, birthdays (in the format day/month) and franchise/production. The first few lines of the file look like this: Forename(s), Surname, Day of Birth, Production Grant Douglas, Ward, 7/1, Agents of S.H.I.E.L.D. Minnie, Mouse, 18/11, Mickey Mouse Michelle, Jones-Watson, 10/6,Spider-Man Riley Elphaba, Andersen, 22/1, Inside Out Della, Duck, 9/6, Donald Duck 1. Load the data into a pandas DataFrame and assign it to the variable disney_characters. 2. Define a second Data Frame second_half_characters that contains the rows of all characters whose first name starts with a letter from the second half of the alphabet. (You can assume that all first names start with a capital letter A-Z.) 3. Create a list of the full names of all characters whose birthday is in February and assign it to the variable list_by_birthday. The names should be in the format "Forename(s) Surname", e.g., "Donald Duck" or "Peter…
Two data files are required to evaluate a multiple-choice examination. The first file (booklet.dat) (memo) contains the correct answers. The total number of questions is 50. A sample file is given below: ACBAADDBCBDDAACDBACCABDCABCCBDDABCACABABABCBDBAABD The second file (answer.dat) contains the students’ answers. Each line has one student record that contains the following information: The student’s answers (a total of 50 answers): each answer can be A, B, C, D or * (to represent no answer). There are no blanks between answers. Student ID Student name A sample file is given below: AACCBDBC*DBCBDAAABDBCBDBAA*BCBDD*BABDBCDAABDCBDBDA 6555 MAHMUT CBBDBC*BDBDBDBABABABBBBBABBABBBBD*BBBCBBDBABBBDC** 6448 SINAN ACB*ADDBCBDDAACDBACCABDCABCCBDDABCACABABABCBDBAABD 6559 CAGIL Write a C++ program that counts the total number of correct answers by each student and outputs this information to another file called report.dat. In this file, the student’s IDs, names and the scores must be given. Each…
The text file boynames.txt and girlnames.txt, which are included in the source code for this book, contain lists of the 1,000 most popular boy and girl names in the United States for the year 2005, as compiled by the SSN. These are blank-delimited where the most popular name is listed first, the second most popular name is listed second, and so on to the 1,000th most popular name, which is listed last. Each line consists of the first name followed by a blank space followed by the number of registered birth in the year using that name. For example, the girlnames.txt file begins with: Emily 25494 Emma 22532 This indicates the Emily is the most popular name with 25,494 registered namings, Emma is the second most popular with 22,532, and so on. Write a program that determines how many names are on both the boy’s and girls’ list. Use the following algorithm: Read each girl name as a String, ignoring the number of namings, and add it to a HashSet object. Read each boy names as a String,…
General Output Find Results 6. Filename: TriangleProblem_FamilyName If a, b and e represcent the three sides of a triangle, then the arca of the triangle is: A = /s + (s – a) + (s – b) * (s – c where: s = “tb+c Also the radius of the largest inscribed circle is given by: r_insc = 4 and the radius of the smallest circumscribed circle is: r_circ =- 2.0 a•b•c 4*A circ _inse Inscribed Circle Circumscribed Circle
AHPA #12: Movie Titles & Star Wars * * From a data file ("Lesson 14 - Movie Data"), read in data for Year, Total Gross, %± LY, Releases, Average, #1 Release for the years 1977 to 2019. * * I have decided that longer movie titles make more money. Add up the average income for each movie length and then print it out. * * * Tell me which movie length made the most money. * * Create an array that uses pointers to store each of the Star Wars movie titles. Once created, print out a of the movie titles in the array. *(use c) * #include <stdio.h> int main(void) { while (fgets (str, MAX_LEN, movieReleases ) != NULL ) { sscanf(str,"%d %f %d %d %[^\n]s",&year,&total,&releases,&average,&title); return 0;}
Create a data file with 1000 lines. Each line in the file consists of a faculty first name, last name, rank, and salary. Faculty’s first name and last name for the ith line are FirstNamei and LastNamei. The rank is randomly generated as assistant, associate, and full. The salary is randomly generated as a number with two digits after the decimal point. The salary for assistant professor should be in the range from 50,000 to 80,000, for associate professor from 60,000 to 110,000, and for full professor from 75,000 to 130,000. Save the file in salary.txt. Here are some sample data:FirstName1 LastName1 assistant 60055.95FirstName2 LastName2 associate 81112.45……FirstName1000 LastName1000 full 92255.21 I'm using Python.
PYTHONPLEASE ALSO SHARE CODE THROUGH LINK: online-python(dot)com Create a python program that reads the student information from a tab separated values (tsv) file. The python program then must creates a text file that will records the course grades of the students. Each row of the tsv file contains the Last Name, First Name, Midtrm1 score, Midtrm2 score, and the Final score of a student. A sample of the student information is provided in StudentInfoScore.tsv. Assume the number of students is at least 1 and at most 20. The program performs the following tasks: Read the file name of the tsv file from the user. Open the tsv file and read the student information. Compute the average exam score of each student. Assign a letter grade to each student based on the average exam score in the following scale: A: 90 =< x B: 80 =< x < 90 C: 70 =< x < 80 D: 60 =< x < 70 F: x < 60 Compute the average of each exam. Output the last names, first names, exam scores, and letter…
a,b,c,d,e,f,g CRLF """x+1""",x+2,123,"",",> ,",x,y,z CRLF 1,2,3,4,5,"6 CRLF ",7 If this file contains no errors, create a table to show its contents. If this file contains errors, identify what those errors are. Please note that CRLF indicates a line break which is consistent with documentation from IETF RFC 4180.