使用Pandas加载CSV时遇FileNotFoundError的解决方法咨询

问题背景 #

我将文件creditcard.cvs放在分支侧边栏的lib目录下，运行以下代码时出现FileNotFoundError：

我的代码 #

import pandas as pd

# Load your dataset (adjust the path as needed)
data = pd.read_csv('/Users/aditya/ID Tech Python Files/ID Lab Tech Correct 1/Science Fair/lib/creditcard.csv')

报错信息 #

Traceback (most recent call last):
  File "/Users/aditya/ID Tech Python Files/ID Lab Tech Correct 1/Science Fair/main.py", line 6, in <module>
    data = pd.read_csv('/Users/aditya/ID Tech Python Files/ID Lab Tech Correct 1/Science Fair/lib/creditcard.csv')
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/aditya/ID Tech Python Files/ID Lab Tech Correct 1/Science Fair/.venv/lib/python3.11/site-packages/pandas/io/parsers/readers.py", line 1026, in read_csv
    return _read(filepath_or_buffer, kwds)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/aditya/ID Tech Python Files/ID Lab Tech Correct 1/Science Fair/.venv/lib/python3.11/site-packages/pandas/io/parsers/readers.py", line 620, in _read
    parser = TextFileReader(filepath_or_buffer, **kwds)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/aditya/ID Tech Python Files/ID Lab Tech Correct 1/Science Fair/.venv/lib/python3.11/site-packages/pandas/io/parsers/readers.py", line 1620, in __init__
    self._engine = self._make_engine(f, self.engine)
                   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/aditya/ID Tech Python Files/ID Lab Tech Correct 1/Science Fair/.venv/lib/python3.11/site-packages/pandas/io/parsers/readers.py", line 1880, in _make_engine
    self.handles = get_handle(
                   ^^^^^^^^^^^
  File "/Users/aditya/ID Tech Python Files/ID Lab Tech Correct 1/Science Fair/.venv/lib/python3.11/site-packages/pandas/io/common.py", line 873, in get_handle
    handle = open(
             ^^^^^
FileNotFoundError: [Errno 2] No such file or directory: '/Users/aditya/ID Tech Python Files/ID Lab Tech Correct 1/Science Fair/lib/creditcard.csv'

Process finished with exit code 1

解决方法 #

• 检查文件名拼写：你提到的文件名是creditcard.cvs，但代码里调用的是creditcard.csv，后缀名差了一个字母（cvs vs csv），这大概率是核心问题。把文件名改成creditcard.csv再试。
• 用相对路径替代绝对路径：绝对路径容易因为环境变化出错，从main.py所在的Science Fair目录出发，相对路径可以写成：

  data = pd.read_csv('./lib/creditcard.csv')
  # 或者更简洁的写法
  data = pd.read_csv('lib/creditcard.csv')
  

• 验证文件实际位置：打开终端，执行以下命令查看目标路径下的文件列表，确认文件存在：

  ls /Users/aditya/ID Tech Python Files/ID Lab Tech Correct 1/Science Fair/lib/
  

• 打印当前工作目录排查：在代码开头加入以下代码，确认Python运行时的工作目录是否和预期一致：

  import os
  print(os.getcwd())
  

内容的提问来源于stack exchange，提问作者Aditya General