CSV file unable to be found

Question

I am trying to run this code to read csv file then take an item number in the csv and search for it in a website, then give me URL of the results.

The issue is that it is unable to find the csv file.

Here's the code:

url = 'https://khusheimstore.com/?wc-ajax=aws_action'
urlist= []

with open ('./book1', mode='r') as file:
    csvfile = csv.reader(file)

    for line in csvfile:
        myobj = { 'keyword': line }
        resultlist= requests.post(url, data=myobj)
        for result in resultlist.product:
            urlist.append(result.url)

This the error message I received, although the file is there in the same folder of the code!

FileNotFoundError: [Errno 2] No such file or directory: './book1'

Is it maybe called "book1.csv"? `with open('book1.csv') as file` — not_speshal, Oct 06 '21 at 17:24
Add the extension too, it might work. You can also add the whole path — Aawan, Oct 06 '21 at 17:26
@not_speshal yes the name of the file is "book1.csv", is it wrong ? — Zainab Alkamal, Oct 06 '21 at 18:34
You need to **run** this script in the same folder as the CSV file, not only put them in the same folder. By default, your terminal isn't in the same folder. Otherwise, use the absolute path, not a relative one — OneCricketeer, Oct 06 '21 at 18:49
@ZainabAlkamal - You need to specify ".csv" in your code. You haven't done that. Use exactly: `with open("book1.csv") as file` — not_speshal, Oct 06 '21 at 19:22

score 0 · Answer 1 · answered Oct 06 '21 at 17:27

0

you might missed adding extension .csv in file name try this

url = 'https://khusheimstore.com/?wc-ajax=aws_action'
urlist= []

    
with open ('./book1.csv', mode='r') as file:
    csvfile = csv.reader(file)

    for line in csvfile:    
        myobj = { 'keyword': line }
        resultlist= requests.post(url, data=myobj)
        for result in resultlist.product:
            urlist.append(result.url)

answered Oct 06 '21 at 17:27

Kunal Sharma

416
3
12

1

I added it like this but i still get the same error – Zainab Alkamal Oct 06 '21 at 18:41

CSV file unable to be found

1 Answers1