FileNotFoundError:使用Pandas

Question

我举了一个例子，我得到了下面的错误，不知道为什么。

# Import pandas as pd
import pandas as pd

# Import the cars.csv data: cars
cars = pd.read_csv('cars.csv')

# Print out cars
print(cars)

当我跑的时候，我得到：

Traceback (most recent call last):
  File "C:/Users/gaara_000/PycharmProjects/firstPj/index.py", line 2, in <module>
    cars = pd.read_csv('cars.csv')
  File "C:\Users\gaara_000\AppData\Local\Programs\Python\Python36-32\lib\site-packages\pandas\io\parsers.py", line 655, in parser_f
    return _read(filepath_or_buffer, kwds)
  File "C:\Users\gaara_000\AppData\Local\Programs\Python\Python36-32\lib\site-packages\pandas\io\parsers.py", line 405, in _read
    parser = TextFileReader(filepath_or_buffer, **kwds)
  File "C:\Users\gaara_000\AppData\Local\Programs\Python\Python36-32\lib\site-packages\pandas\io\parsers.py", line 764, in __init__
    self._make_engine(self.engine)
  File "C:\Users\gaara_000\AppData\Local\Programs\Python\Python36-32\lib\site-packages\pandas\io\parsers.py", line 985, in _make_engine
    self._engine = CParserWrapper(self.f, **self.options)
  File "C:\Users\gaara_000\AppData\Local\Programs\Python\Python36-32\lib\site-packages\pandas\io\parsers.py", line 1605, in __init__
    self._reader = parsers.TextReader(src, **kwds)
  File "pandas\_libs\parsers.pyx", line 394, in pandas._libs.parsers.TextReader.__cinit__ (pandas\_libs\parsers.c:4209)
  File "pandas\_libs\parsers.pyx", line 710, in pandas._libs.parsers.TextReader._setup_parser_source (pandas\_libs\parsers.c:8873)
FileNotFoundError: File b'cars.csv' does not exist

我认为这是正确的密码。

我从https://www.learnpython.org/en/Pandas_Basics那里得到这个代码 谢谢，我修好了

Answer 1

确保您的文件与python代码在同一个目录中，否则需要给它一个目录路径。希望能成功！

Answer 2

因为你没有cars.csv文件。打开文本编辑器并在与.py文件相同的目录中创建以下文件。

汽车.csv：

CarName,Price
Bmw,50000$
Audi,20000$
Ferrari,100000$

现在试着运行代码。你会得到输出

   CarName    Price
0      Bmw   50000$
1     Audi   20000$
2  Ferrari  100000$

所以pd.read_csv()所做的是读取csv文件（默认的分隔符是,，您也可以更改它）

Answer 3

如果您使用此文件，则必须将程序和cars.csv保存在同一文件夹中。cars = pd.read_csv('cars.csv')或者您可以像这样给出csv文件的完整路径(r'C:\Users\Vikas Chauhan\Desktop\cars.csv')。 你的代码是正确的。

import pandas as pd

cars = pd.read_csv(r'C:\Users\Vikas Chauhan\Desktop\cars.csv')

# Print out cars
print(cars)

输出为

  vikas   test
0  vika  test2