Write 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,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.

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
icon
Related questions
Question
100%

Write 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,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)
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)
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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Constants and Variables
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
Recommended textbooks for you
Database System Concepts
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education