atom无法读取同一目录下的csv

2024-10-04 01:35:10 发布

您现在位置:Python中文网/ 问答频道 /正文

CSV文件和.py文件位于其他目录下的同一目录中。你知道吗

upper_directory
 - lower_directory
    - test.py (where I read the csv file from)
    - student_data.csv

我尝试的是:

import pandas as pd
df = pd.read_csv('student_data.csv')

我得到的是:

Traceback (most recent call last):
  File "/Users/iwasiwas/Desktop/flask_dash_directory/myproject/dashboard/test.py", line 3, in <module>
    df = pd.read_csv("student_data.csv")
  File "/Users/iwasiwas/anaconda3/lib/python3.7/site-packages/pandas/io/parsers.py", line 702, in parser_f
    return _read(filepath_or_buffer, kwds)
  File "/Users/iwasiwas/anaconda3/lib/python3.7/site-packages/pandas/io/parsers.py", line 429, in _read
    parser = TextFileReader(filepath_or_buffer, **kwds)
  File "/Users/iwasiwas/anaconda3/lib/python3.7/site-packages/pandas/io/parsers.py", line 895, in __init__
    self._make_engine(self.engine)
  File "/Users/iwasiwas/anaconda3/lib/python3.7/site-packages/pandas/io/parsers.py", line 1122, in _make_engine
    self._engine = CParserWrapper(self.f, **self.options)
  File "/Users/iwasiwas/anaconda3/lib/python3.7/site-packages/pandas/io/parsers.py", line 1853, in __init__
    self._reader = parsers.TextReader(src, **kwds)
  File "pandas/_libs/parsers.pyx", line 387, in pandas._libs.parsers.TextReader.__cinit__
  File "pandas/_libs/parsers.pyx", line 705, in pandas._libs.parsers.TextReader._setup_parser_source
FileNotFoundError: [Errno 2] File b'student_data.csv' does not exist: b'student_data.csv'

我如何在不键入完整路径的情况下修复此问题?(它可以与完整的-但我需要让它工作没有我的本地完整路径部署,我不明白为什么它不工作,因为这两个.py文件和.csv文件都在同一个目录。)

谢谢你!你知道吗


Tags: csvinpyselfpandasreaddatalib