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
Related questions
Concept explainers
Question
Write a
Sort the dictionary by key (least to greatest) and output the results to a file named output_keys.txt. Separate multiple TV shows associated with the same key with a semicolon (;), ordering by appearance in the input file. Next, sort the dictionary by values (alphabetical order), and output the results to a file named output_titles.txt.
Ex: If the input is:
file1.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 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. My code is below, I am getting no output and can't see the error.
![file = input()
{}
dict
try:
fin = open(file, 'r')
L = fin.readlines()
index = 0
while index + 1 < len(L):
key = L[index].strip('\n')
value = L[index +1].strip('\n')
if key not in dict:
%3D
dict[key] = [value]
else:
dict[key].append(value)
index += 2
fout = open('output_keys.txt', 'w')
titles = []
for key in sorted (dict.keys()):
if len(dict[key]) > 1:
fout.write(str(key) + ':')
for values in range (len(dict[key])-1):
fout.write(dict[key][values] + ';')
titles.append (dict[key][len(dict[key])-1])
else:
fout.write(str(key)+': '+dict[key][0]+'\n')
titles.append(dict[key][0])
titles.sort()
fout = open('output_titles.txt','w')
for i in titles:
fout.write(i+'\n')
fout.close()
except IOError:
print('File not found')](https://content.bartleby.com/qna-images/question/2bc2a3ad-b0fb-46d0-8be8-5188cce94b42/ddb8830d-39b2-4415-b2b6-9167ed339588/9npsek_processed.jpeg)
Transcribed Image Text:file = input()
{}
dict
try:
fin = open(file, 'r')
L = fin.readlines()
index = 0
while index + 1 < len(L):
key = L[index].strip('\n')
value = L[index +1].strip('\n')
if key not in dict:
%3D
dict[key] = [value]
else:
dict[key].append(value)
index += 2
fout = open('output_keys.txt', 'w')
titles = []
for key in sorted (dict.keys()):
if len(dict[key]) > 1:
fout.write(str(key) + ':')
for values in range (len(dict[key])-1):
fout.write(dict[key][values] + ';')
titles.append (dict[key][len(dict[key])-1])
else:
fout.write(str(key)+': '+dict[key][0]+'\n')
titles.append(dict[key][0])
titles.sort()
fout = open('output_titles.txt','w')
for i in titles:
fout.write(i+'\n')
fout.close()
except IOError:
print('File not found')
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 4 steps with 5 images
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
There is no output. What do I do?
Solution
by Bartleby Expert
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
There is no output. What do I do?
Solution
by Bartleby Expert
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
- Make new code pleasearrow_forwardPlease answer the ques in python with showing the codesarrow_forwardUsing the Dictionary below, create a game that picks a random number based on the length of the dictonary. Using that random number, prompts the user for the capital of that state (the key for your dictionary) - Use the code snipet below Your program must prompt the user by asking "What is the capital of XXX:" and XXX is the state name. Your program should compare the guess to the actual capital for that state. If the guess is correct, increment the number of correct guesses. If the guess is wrong, increment the numner of incorrect guesses. When the user types in quit in eithe uppercase or lowercase, the program should print out the results of the game by telling the payer you had XX correct responses and YY incorrect responses. Then the program should end. Make sure to do the Outline and Logic parts for your program. You can include your Python code in yout Word document, or submit it as a Python (;py) file Upload your work to this assignment when completed. # Pick…arrow_forward
- Please complete on Python Write a program that keeps a dictionary in which both keys and values are strings, names of students and their courses grades. Prompt the user of the program to add or remove students, to modify grades, or to print all grades. The printout should be sorted by name and formatted like this: <br>Carl: B+ <br>Joe: C <br>Sarah: A <br>Francine: Aarrow_forwardWrite a python program that creates a dictionary containing the U.S. states as keys, and their capitals as values. The program should then randomly quiz the user by displaying the name of a state and asking the user to enter that state's capital. The program should keep a count of the number of correct and incorrect responses. This program has really been giving me trouble. Any help is greatly appreciated. Thanks so much!arrow_forwardWrite a python program that reads the contents of a text file. The program should create a dictionary in which the keys are the individual words found in the file and the values are the number of times each word appears. For example, if the word "the" appears 128 times, the dictionary would contain an element with 'the' as the key and 128 as the value. The program should either display the frequency of each word or create a second file containing a list of each word and it's frequency. This program has really been giving me trouble. Any help is great appreciated. Thanks so much!arrow_forward
- In Python languagearrow_forwardAs part of this assignment, the program that you will be writing will store current grades in a dictionary using course codes as keys and with values consisting of percent grades in lists. The main functions of this program are to print a student's gradebook, to drop the lowest grade in each course, print the student's gradebook again, drop the course with lowest average, and finally printing the student's gradebook again. This program requires a main function and a custom value-returning function. In the main function, code these basic steps in this sequence (intermediate steps may be missing): start with an empty dictionary that represents a gradebook and then use a while loop to allow the input of course codes from the keyboard. End the while loop when the user presses enter without entering data.within the while loop:for each course entered, use a list comprehension to generate five random integers in the range of 70 through 100. These random integers in a list represent the…arrow_forwardI am struggling with this program question for the last few hours. Could you please assist? Write a program that prompts user to enter make, model, color and year of their car. Store the input data in a dictionary and a list. The dictionary has "make", "model", "color", and "year" as keys. The dictionary values are user inputted data. In addition, store the input data in a list also. Store the make, model, color and year of the car in a list. Display the dictionary and list. Here are sample program run. Your program output message should be similar to below. Make sure use other inputs to verify the correctness of the program. What is the make of your car? Ford What is the model of your car? Taurus What is color of your car? white What is the year of your car? 1997 Car info dictionary: {'make': 'Ford', 'model': 'Taurus', 'color': 'white', 'year': 1997} Car info list: ['Ford', 'Taurus', 'white', 1997] (I am getting syntax errors all over the place) I do have tutoring sessions but I'm in…arrow_forward
- This code is full of errors, what are 4 of them and how I would fix them?arrow_forwardIn python: student_dict is a dictionary with students' name and pedometer reading pairs. A new student is read from input and added into student_dict. For each student in student_dict, output the student's name, followed by "'s pedometer reading: ", and the student's pedometer reading. Then, assign average_value with the average of all the pedometer readings in student_dict..arrow_forwardIn Python, create a telephone dictionary where the user is asked whether they wish to add, remove,modify, search for a telephone number (given the name), or exit. Use functions for each one ofthe four different operations. Use an infinite looparrow_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 Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON 
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable 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