时间戳

首页 > 解决方案 > 不断从python中的csv阅读器获取文件未找到错误

python - 不断从python中的csv阅读器获取文件未找到错误

问题描述

我对编码很陌生，所以希望这个问题比我想的更容易解决。我正在尝试在 python 中读取 CSV 文件并与之交互，但每次尝试代码都会返回一个文件/目录未找到错误。我只是简单地打印了代码，并且知道实际上可以找到和使用该文件，并且我知道该文件只能在打印为 .csv.csv 时调用。当我尝试调用 csv 文件以获取此特定代码块时，为什么找不到此文件/目录错误？请帮忙。

我得到的错误是：

$ python second_lesson.py
What show or movie are you looking for? Friends
Traceback (most recent call last):
  File "second_lesson.py", line 17, in <module>
    with open(csvpath, newline="") as csvfile:
FileNotFoundError: [Errno 2] No such file or directory: '..\\Downloads\\netflix_ratings.csv.csv'

import os
import csv

video = input("What show or movie are you looking for? ")

csvpath = os.path.join("C:", "Desktop", "Python2", "netflix_ratings.csv.csv")

found = False

with open(csvpath, newline="") as csvfile:
    csvreader = csv.reader(csvfile, delimiter=",")

    for row in csvreader:
        if row[0] == video:
            print(row[0] + " is rated " + row[1] + " with a rating of " + row[5])


            found = True

    if found is False:
        print("Sorry about this, we don't seem to have what you are looking for!")

标签： pythoncsvfile-not-found

解决方案

    FileNotFoundError: [Errno 2] No such file or directory: '..\\Downloads\\netflix_ratings.csv.csv'

与

    csvpath = os.path.join("C:", "Desktop", "Python2", "netflix_ratings.csv.csv")

=> C:\Desktop\Python2\netflix_ratings.csv.csv

我建议修复路径或将文件放在错误中指定的路径中。

推荐阅读