Question

7.13 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.

IN PYTHON PLEASE

Answer 1

Answer:

Dear student,

following is the python code for the given question which is compiled using python 3.7

Code:

import csv

# user input for the file
fileName = input("Enter the file name: ")

# dictionary to store words with their frequencies
wordsFrequency = {}

# reading the file
with open(fileName, 'r') as csvfile:
csvreader = csv.reader(csvfile)
# iterating throught each row
for row in csvreader:
for word in row:
# checking if word exixt in the dictionary or not if not present then add the word in the dictionary with frequency 1
if word not in wordsFrequency.keys():
wordsFrequency[word] = 1
# else increase the frequency by 1
else:
wordsFrequency[word] += 1

# printin the result
for key in wordsFrequency.keys():
print(key + " " + str(wordsFrequency[key]))   

Code Screenshot + sample Output

Content of the input1.csv file

Note: Let me know if you have any doubt.