FileNotFoundError: [Errno 2] No such file or directory: '9788427133310_urls.csv'

Asked Mar 21 '22 at 18:03

Active Mar 21 '22 at 18:03

Viewed 25 times

I'm trying to take all files in a folder, join them and put their names in their rows so I can distinguish them. However, I get:

Traceback (most recent call last):
  File "C:/unite_try.py", line 21, in <module>
    with open(file, newline='') as f:
FileNotFoundError: [Errno 2] No such file or directory: '9788427133310_urls.csv'

The file, which is the first one in the folder, is in the right folder so I don't understand why this is happening. When I print "files" they are correct.

folder = './urls_files'
files = []
for file in os.listdir(folder):
    if file.endswith('.csv'):
        files.append(file)
with open('./urls_files/results.csv', 'w', newline='') as fw:
    cw = csv.writer(fw, delimiter=',')
    for file in files:
        with open(file, newline='') as f:
            for row in csv.reader(f, delimiter=','):
                row.append(file)
                cw.writerow(row)

asked Mar 21 '22 at 18:03

Idkwhatnomeis

1

`open` doesn't know what folder your file is in. – Scott Hunter Mar 21 '22 at 18:05
can you expand on that please? the folder is supposed to be urls_files – Idkwhatnomeis Mar 21 '22 at 18:06
"The file, which is the first one in the folder" -- you're not looking in a folder at the moment, you're looking in C:/ – jedwards Mar 21 '22 at 18:07
how can I fix it? – Idkwhatnomeis Mar 21 '22 at 18:07
1

stdlib's [pathlib](https://docs.python.org/3/library/pathlib.html) is outrageously underused, please consider checking it out – jedwards Mar 21 '22 at 18:08
You need to use `folder` in your call to `open` to build the full path to your file. – Scott Hunter Mar 21 '22 at 18:20

FileNotFoundError: [Errno 2] No such file or directory: '9788427133310_urls.csv'

0 Answers0