导入csv文件时出现问题

Question

我是Python的新手，不理解我收到的错误。我正在尝试将csv文件导入python，但遇到了问题。我正在使用Visual Studio，并尝试运行以下程序：

import pandas as pd
import numpy as np
data = pd.read_csv('data.csv')

并得到以下错误：

---------------------------------------------------------------------------
FileNotFoundError                         Traceback (most recent call last)
~AppDataLocalTemp/ipykernel_9712/3185619637.py in <module>
1 import pandas as pd
2 import numpy as np
----> 3 data = pd.read_csv('boxer_data')
~anaconda3libsite-packagespandasutil_decorators.py in wrapper(*args, **kwargs)
309                     stacklevel=stacklevel,
310                 )
--> 311             return func(*args, **kwargs)
312 
313         return wrapper
~anaconda3libsite-packagespandasioparsersreaders.py in read_csv(filepath_or_buffer, sep, delimiter, header, names, index_col, usecols, squeeze, prefix, mangle_dupe_cols, dtype, engine, converters, true_values, false_values, skipinitialspace, skiprows, skipfooter, nrows, na_values, keep_default_na, na_filter, verbose, skip_blank_lines, parse_dates, infer_datetime_format, keep_date_col, date_parser, dayfirst, cache_dates, iterator, chunksize, compression, thousands, decimal, lineterminator, quotechar, quoting, doublequote, escapechar, comment, encoding, encoding_errors, dialect, error_bad_lines, warn_bad_lines, on_bad_lines, delim_whitespace, low_memory, memory_map, float_precision, storage_options)
584     kwds.update(kwds_defaults)
585 
--> 586     return _read(filepath_or_buffer, kwds)
587 
588 
~anaconda3libsite-packagespandasioparsersreaders.py in _read(filepath_or_buffer, kwds)
480 
481     # Create the parser.
--> 482     parser = TextFileReader(filepath_or_buffer, **kwds)
483 
484     if chunksize or iterator:
~anaconda3libsite-packagespandasioparsersreaders.py in __init__(self, f, engine, **kwds)
809             self.options["has_index_names"] = kwds["has_index_names"]
810 
--> 811         self._engine = self._make_engine(self.engine)
812 
813     def close(self):
~anaconda3libsite-packagespandasioparsersreaders.py in _make_engine(self, engine)
1038             )
1039         # error: Too many arguments for "ParserBase"
-> 1040         return mapping[engine](self.f, **self.options)  # type: ignore[call-arg]
1041 
1042     def _failover_to_python(self):
~anaconda3libsite-packagespandasioparsersc_parser_wrapper.py in __init__(self, src, **kwds)
49 
50         # open handles
---> 51         self._open_handles(src, kwds)
52         assert self.handles is not None
53 
~anaconda3libsite-packagespandasioparsersbase_parser.py in _open_handles(self, src, kwds)
220         Let the readers open IOHandles after they are done with their potential raises.
221         """
--> 222         self.handles = get_handle(
223             src,
224             "r",
~anaconda3libsite-packagespandasiocommon.py in get_handle(path_or_buf, mode, encoding, compression, memory_map, is_text, errors, storage_options)
700         if ioargs.encoding and "b" not in ioargs.mode:
701             # Encoding
--> 702             handle = open(
703                 handle,
704                 ioargs.mode,
FileNotFoundError: [Errno 2] No such file or directory: 'boxer_data'

Answer 1

看起来您要读取的文件在另一个文件夹中。尝试使用操作系统库进行导航。

import os 
os.getcwd()

检查当前文件夹，然后将文件放在此处或使用以下命令更改文件所在的目录：

os.chdir(r'C:UsersFolder_where_your_file_is_located')