
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
Question
7.8 LAB: Word frequencies (lists)
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.csvand the contents of input1.csv are:
hello,cat,man,hey,dog,boy,Hello,man,cat,woman,dog,Cat,hey,boythe output is:
hello 1cat 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.

Transcribed Image Text:= zyBooks
My library > IT 140: Introduction to Scripting v3 home >
7.8: LAB: Word frequencies (lists)
E zyBooks catalog
? Help/FAQ 8 Victo-
7.8 LAB: Word frequencies (lists)
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
Нello 1
woman 1
Cat 1
Note: There is a newline at the end of the output, and input1.csv is available to download.
247772.1992070.qx3zqy7
LAB

Transcribed Image Text:= zyBooks
My library > IT 140: Introduction to Scripting v3 home >
7.8: LAB: Word frequencies (lists)
E zyBooks catalog
2 Help/FAQ 8 Vic-
LAB
7.8.1: LAB: Word frequencies (lists)
1/10
ACTIVITY
Downloadable files
input1.csv
Download
main.py
Load default template...
1 import csv
2
3 ###Type you're code here###
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)
hello,cat,man,hey,dog,boy,Hello,man,cat,woman,dog,Cat,hey,boy
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 3 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
- 28. You are given a name arranged in bibliography (reverse) format. This line of names is then read and stored in a list so that the first element is the last name, the middle element is a comma and the last element is the first name (Assuming: the author's name only consists of 2 words). You are asked to rewrite the name in the standard format: First name + Last name. Which of the following program code fits the task? Sample Input: Putro , Hanson Sample Output : Hanson Putro A name - input ().split () print (name (1] +" +name (2) } name - input (). split () print (name (1] +" tname [0]) B C name - input ().split () print (name (2] +" "+name (0] ) name - input().split () print (name (0] +" "+name (1) ) Darrow_forwardInteger num_reading is read from input, representing the number of integers to be read next. Read the remaining integers from input and insert each integer at the front of reading_list at position 0.arrow_forwardPYTHON QUESTION 3 MULTIPLE CHOICE years = [] with open("years.txt") as file: for line in file: line = line.replace("\n", "") years.append(int(line)) # converts str to int print(years) A. Refer to the code above, what does the program do? a. Reading the items in a list from a file with \n c. Reading the lines in a file from a list b. How to read file into a list and print in lines d. Reading the items in a list from a filearrow_forward
- JAVA 8.13 LAB: Movie show time display Write a program that reads movie data from a csv (comma separated values) file and output the data in a formatted table. The program first reads the name of the CSV file from the user. The program then reads the csv file and outputs the contents according to the following requirements: Each row contains the title, rating, and all showtimes of a unique movie. A space is placed before and after each vertical separator (|) in each row. Column 1 displays the movie titles and is left justified with a minimum of 44 characters. If the movie title has more than 44 characters, output the first 44 characters only. Column 2 displays the movie ratings and is right justified with a minimum of 5 characters. Column 3 displays all the showtimes of the same movie, separated by a space. Each row of the csv file contains the showtime, title, and rating of a movie. Assume data of the same movie are grouped in consecutive rows. Ex: If the input of the program…arrow_forwardThe next part of the program reads the file one line at a time and adds the scores, as a floating point numbers, to the list scores. scores = [] # empty list of scores for line in infile: line = line.strip() print (scores) # get score #convert to float # add to list of scores In the space below, complete the program fragment so that it prints the list of floating point scores as follows: [98.5, 97.4, 99.1, 97.2]arrow_forward5 partition_list (head) This is a little like split_list() from the Short problem, except that, instead of splitting the list into two by cutting it into the middle, you will now build two lists to return, using alternate values. The first value in the input list should be returned at the head of the first new list; the second value should be the head of the second list. Keep on alternating from there, putting one new value on the first list, and one on the second. (But remember that the length of the input list might be odd.) Example Suppose you have the following input list: 10 - 13 -> -1 -> 1000 - 0 It should return the following two lists: 10 1 0 13 -> 1000arrow_forward
- 9b_act2. Please help me answer this in python programming.arrow_forwardTask 5: Unscramble You will write a program that takes in 2 files: a dictionary file and a file listing jumbled words. Your binary will be called unscramble and will be run using unscramble The file contains a bunch of scrambled words, one word per line. Your job is to print out these jumbles words, 1 word to a line. After each jumbled word, print a list of real dictionary words that could be formed by unscrambling the jumbled word. The dictionary words that you have to choose from are in the file. As an example, the starter package contains two sample input files and the result should look as follows. The order that you display the dictionary words on each line can be different; however, the order that you print out the jumbled words should be identical to the order in your input. The sample out below is skipping a few lines to save handout space (your output must not omit these lines). nwae: wean anew wane eslyep: sleepy rpeoims: semipro imposer promise ettniner: renitent.…arrow_forward
arrow_back_ios
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