Answered: Write a python program that first reads…

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

Concept explainers

Question

Write a python 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. I have an error code and I am confused as to why. If I identify the file and use "with open" shouldn't it refer to the input file?

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

import csv
import os
import sys
# Type your code here.
mycsvfile = open(input ())
word freq = {}
%3D
with open ('mycsvfile.csv','r') as csvfile:
csvreader = csv.reader(csvfile)
for row in csvreader:
for word in row:
if word not in word_freq.keys ():
word_freq[word]
else:
word_freq += 1
for key in word_freq.keys():
print(key,
", str(word_freq[key]))

Program errors displayed here
Traceback (most recent call last):
File "main.py", line 10, in <module>
with open ('mycsvfile.csv','r') as csvfile:
FileNotFoundError: [Errno 2] No such file or directory: 'mycsvfile.csv'

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

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