
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
thumb_up100%
Write a
Ex: If the input is:
input1.csv
and the contents of input1.csv are:
hello,cat,man,hey,dog,boy,Hello,man,cat,woman,dog,Cat,hey,boy
the output is:
hello 1
cat 2
man 2
hey 2
dog 2
boy 2
Hello 1
woman 1
Cat 1
Note: There is a newline at the end of the output, and input1.csv is available to download.
![learn.zybooks.com
b Answered: th...
B 5-3 Project...
B 8-1 Discussi...
JB Download P...
B Project One...
* IT 140 : Arra...
Snhu School...
* Kayla_Reed_...
E Open orders...
zy Section 7.9 -...
= zyBookS My library > IT 140: Introduction to Scripting v3 home > 7.9: LAB: Sorting TV Shows (dictionaries and lists)
E zyBooks catalog
2Help/FAQ
Victoria Thibodeaux
10: Will & Grace
12: Murder, She Wrote
14: Dallas
20: Gunsmoke; Law & Order
30: The Simpsons
and the file output_titles.txt should contain:
Dallas
Gunsmoke
Law & Order
Murder, She Wrote
The Simpsons
Will & Grace
Note: There is a newline at the end of each output file, and file1.txt is available to download.
247772.1992070.qx3zqy7
LAB
7.9.1: LAB: Sorting TV Shows (dictionaries and lists)
0/10
АCTIVITY
Downloadable files
filel.txt
Download
main.py
Load default template.
1 # accepting user input for filename
2 file = input("Enter your filename :")
3 # empty dictionary
4 D = {}
5 try:
6 # opening user file
7
fin = open(file,"r")
8 # reading file using readlines
9 L =
fin.readlines()
10 # assigning index = 0
11 index = 0
12 # loop till index + 1 is less than len(L)
13 while index + 1 < len(L):
14 # get the key from the line
15 key = L[index].strip("\n")
16 # get the value from the nextline
17 value = L[index+1].strip("\n")
18 # check if key not in Dictioanry
Run your program as often as you'd like, before submitting for grading. Below, type any needed
input values in the first box, then click Run program and observe the program's output in the
Develop mode
Submit mode
second box.
Enter program input (optional)](https://content.bartleby.com/qna-images/question/0fb6fbe8-c93b-4e2e-8100-eedf21471e21/7ad1dc4f-33a9-46a3-b638-76e1cae283fd/0o4ehn4_thumbnail.png)
Transcribed Image Text:learn.zybooks.com
b Answered: th...
B 5-3 Project...
B 8-1 Discussi...
JB Download P...
B Project One...
* IT 140 : Arra...
Snhu School...
* Kayla_Reed_...
E Open orders...
zy Section 7.9 -...
= zyBookS My library > IT 140: Introduction to Scripting v3 home > 7.9: LAB: Sorting TV Shows (dictionaries and lists)
E zyBooks catalog
2Help/FAQ
Victoria Thibodeaux
10: Will & Grace
12: Murder, She Wrote
14: Dallas
20: Gunsmoke; Law & Order
30: The Simpsons
and the file output_titles.txt should contain:
Dallas
Gunsmoke
Law & Order
Murder, She Wrote
The Simpsons
Will & Grace
Note: There is a newline at the end of each output file, and file1.txt is available to download.
247772.1992070.qx3zqy7
LAB
7.9.1: LAB: Sorting TV Shows (dictionaries and lists)
0/10
АCTIVITY
Downloadable files
filel.txt
Download
main.py
Load default template.
1 # accepting user input for filename
2 file = input("Enter your filename :")
3 # empty dictionary
4 D = {}
5 try:
6 # opening user file
7
fin = open(file,"r")
8 # reading file using readlines
9 L =
fin.readlines()
10 # assigning index = 0
11 index = 0
12 # loop till index + 1 is less than len(L)
13 while index + 1 < len(L):
14 # get the key from the line
15 key = L[index].strip("\n")
16 # get the value from the nextline
17 value = L[index+1].strip("\n")
18 # check if key not in Dictioanry
Run your program as often as you'd like, before submitting for grading. Below, type any needed
input values in the first box, then click Run program and observe the program's output in the
Develop mode
Submit mode
second box.
Enter program input (optional)

Transcribed Image Text:learn.zybooks.com
b Answered: th...
B 5-3 Project...
B 8-1 Discussi...
JB Download P...
B Project One...
IT 140 : Arra.
Snhu School...
Kayla_Reed_...
E Open orders...
zy Section 7.9 -...
= zyBookS My library > IT 140: Introduction to Scripting v3 home > 7.9: LAB: Sorting TV Shows (dictionaries and lists)
E zyBooks catalog
? Help/FAQ 8 Victoria Thibodeaux
7.9 LAB: Sorting TV Shows (dictionaries and lists)
Write a program that first reads in the name of an input file and then reads the input file using the file.readlines() method. The input file
contains an unsorted list of number of seasons followed by the corresponding TV show. Your program should put the contents of the input
file into a dictionary where the number of seasons are the keys, and a list of TV shows are the values (since multiple shows could have the
same number of seasons).
Sort the dictionary by key (least to greatest) and output the results to a file named output_keys.txt, separating multiple TV shows
associated with the same key with a semicolon (;). Next, sort the dictionary by values (alphabetical order), and output the results to a file
named output_titles.txt.
Ex: If the input is:
filel.txt
and the contents of file1.txt are:
20
Gunsmoke
30
The Simpsons
10
Will
& Grace
14
Dallas
20
Law & Order
12
Murder, She Wrote
the file output_keys.txt should contain:
10: Will & Grace
12: Murder, She Wrote
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 2 images

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
- The next three questions concern a program that opens a scores file provided by the user, reads it one line at a time, adds the scores as floating point numbers to a list scores, and then computes the average score. The example file scores.csv looks like this: Student Name, Test Score Jinyue, 98.5 Adesh, 97.4 Pinn, 99.1 Arindaam, 97.2 The first part of the program opens the file and reads just the first line into the variable header. # Open the Filename and ignore the first line filename= input("Enter filename:") open (filename) fhand = header = Fill in the blank to complete the program fragment:arrow_forwardWrite a program that first reads in the name of an input file and then reads the file using the csv.reader() method. The file contains a list of words separated by commas. Your program should output the words and their frequencies (the number of times each word appears in the file) without any duplicates. Ex: If the input is: input1.csv and the contents of input1.csv are: hello,cat,man,hey,dog,boy,Hello,man,cat,woman,dog,Cat,hey,boyarrow_forwardcan you do it pythonarrow_forward
- Write a program to draw a quiz score histogram. Your program shouldread data from a file. Each line of the file contains a number in the range0-10. Your program must count the number of occurrences of each scoreand then draw a vertical bar chart with a bar for each possible score (0-10) with a height corresponding to the count of that score. For example,if 15 students got an 8, then the height of the bar for 8 should be 15.Hint: Use a list that stores the count for each possible score. An examplehistogram is shown below: o o D D0 1 2 3 4 5 6 7 8 9 10arrow_forwardpython Write a function that reads in a text file, and counts the number of times each word occursin the file. Then print the words alphabetically with its corresponding count. Each word willbe separated by a space or newline, but there is no guarantee that each word will be on aseparate line.arrow_forwardWrite a C++ program using classes that readslines from a file until the end of file. The program should prompt the user for the file name to read from. The program should open the file for reading, and if the filecannot be opened, print the message “File couldn’t be opened”, followed by a space and the filename, and exit. The program should keep track of the number of lines, the number of non-blank lines, the number of words, and the number of integers read from the file.arrow_forward
- Write a python program that prompts the user for their favorite basketball team. It should be able to read the list of teams provided below in a file called favorite_teams.txt and check if their team is in that file. Teams in the file:JazzBullsMavericksSpursIf the team is in the file let the user know that their team is in the list of favorites. If the team is not in the file, add the team to the end of the file. Also, let the user know that their team will be added to the file.Sample Run in File:What is your favorite NBA team? Jazz [Enter]Your team Jazz is in the listFile before and after run: JazzBullsMavericksSpurs Sample Run not in File:What is your favorite NBA team? Pelicans [Enter]Your team Pelicans is not in the list. It will be added.File before run: JazzBullsMavericksSpursFile after run:JazzBullsMavericksSpursPelicansarrow_forwardJava Your program must read a file called personin.txt. Each line of the file will be a person's name, the time they arrived at the professor's office, and the amount of time they want to meet with the professor. These entries will be sorted by the time the person arrived. Your program must then print out a schedule for the day, printing each person's arrival, and printing when each person goes in to meet with the professor. You need to print the events in order of the time they happen. In other words, your output will be sorted by the arrival times and the times the person goes into the professor's office. In your output you need to print out a schedule. In the schedule, new students go to the end of the line. Whenever the professor is free, the professor will either meet with the first person in line, or meet with the first person in line if nobody is waiting. Assume no two people arrive at the same time. You should solve this problem using a stack and a queue. You can only…arrow_forwardhere is a text file containing the details of several invoices details. Each invoice uses 3 lines of the file. The first of the three lines is a string giving the date of the invoice, for example “1/5/2021” or “2/6/2021”. The second of the three lines contains double giving the amount, the third line is boolean indicating whether it is paid or not. However, the very first line of the file is an integer number, which says how many invoices are given in the file in the lines which follow it (i.e. how many records will follow). Text file example for two vehicles “invoices.txt” 2 1/5/2021 50.0 true 2/6/2021 20.0 false Write code for a method named processTextFile() which will open the file named ‘invoices.txt’, from which it will read the data of invoices. It will create Invoice objects using this data by calling the constructor that takes the parameters (date, amount, paid) , placing them into an ArrayList invoiceList.arrow_forward
- Suppose you are given a text file that contains the names of people. Every name in the file consists of a first name and last name. Unfortunately, the programmer that created the file of names did not guarantee that each name was on a single line of the file. Read this file of names and write them to a new text file sorted according to first name, one name per line. For example, if the input file contains Ed Marston Bob Jones Jeff Williams Fred Charles The output file should be Bob Jones Ed Marston Fred Charles Jeff Williams Use arrays to solve the problem.arrow_forwardWrite a program that reads student's IDs and exam scores (type int) for a particular exam in a course from each line of an input file (the input file is included). You need to compute the average of these scores and assign grades to each student according to the following regulation: If a student's score is within 10 points (above or below) of the average, assign a grade of satisfactory. If a student's score is more than 10 points above average, the grade will be outstanding. If a student's score is more than 10 points below the average, the grade will be unsatisfactory. The output of your program should consist of a three-column table that shows each ID, score, and corresponding grade. A sample output is shown below. ID SOLS SENTO 0 1 2 3 4 8 9 Score 75 99 66 43 87 65 82 91 84 76 Grade Satisfactory Outstanding Unsatisfactory Unsatisfactory Outstanding Unsatisfactory Satisfactory Outstanding Satisfactory Satisfactory Write necessary functions and put them in a module to process this…arrow_forwardWrite a program that asks the user for a file name and a string to search for. The program should search the file for every occurrence of a specified string. When the string is found, the line that contains it should be displayed. After all the occurrences have been located, the program should report the number of times the string appeared in the file.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education

Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON

Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education