Answered: 7.8 LAB: Word frequencies (lists) Write…

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

Related questions

Question

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

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
Hello 1
woman 1
Cat 1
Note: There is a newline at the end of the output, and input1.csv is available to download.
440292.2711150.qx3zqy7

Input
Your output
Expected output
2:Compare output
Input
input1.csv
Your output
hello 1 cat 2 man 2 hey 2 dog 2 boy 2 Hello 1 woman 1 Cat 1
Output differs. See highlights below. Special character legend
hello 14
cat 24
man 2
hey 2
dog 2
boy 2
Hello 14
woman 1
Cat 1
input2.csv
hello 1 cat 2 man 2 hey 2 dog 2 boy 2 Hello 1
bubble 3
caring 1
unsuitable l
dispensable l
obtainable lª
bloody 1
meddle 14
crown 14
visitor lª
ahead 14
invention 1.1
woman 1 Cat 1
0/2

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Follow-up Questions

Read through expert solutions to related follow-up questions below.

Follow-up Question

The solution provided does not work appropriately.

Expected output
3:Compare output
Input
Output differs. See highlights below. Special character legend
Your output
delirious l
savory 1
servant lª
pot 1
increase lª
soothe 1ª
truculent lª
squeak 1
learn 2
troubled l
walk 1
tease 1
cumbersome 1
Expected output
deeply 2-
spark 1
science 1
island 14
narrow lª
input3.csv
Enter a file name: hi 1
hi 7
hey 24
Hi 34
HI 2
0/2

Output differs. See highlights below. Special character legend
Input
Your output
Expected output
2:Compare output
Input
input1.csv
Your output
Enter a file name: hello 1
Output differs. See highlights below. Special character legend
hello 14
cat 24
man 2
hey 2
dog 2
boy 2
Hello 1
woman 1
Cat 14
input2.csv
Enter a file name: bubble 1
bubble 3
caring 1
unsuitable l
dispensable l
obtainable l
bloody 1
meddle 14
crown 14
0/2

Solution

by Bartleby Expert

SEE SOLUTION

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