python - 用pandas在csv中上传csv

Question

我已经在cloud9中下载并安装了 Pandas ，但是当我
采用

'''
pd.read_csv("Housing.csv")

'''

我不断收到此错误消息

'''
Traceback (most recent call last):

File "/home/ec2-user/environment/lab_5.py", line 4, in <module>
pd.read_csv("Housing.csv")

File "/usr/local/lib64/python3.6/site-     packages/pandas/io/parsers.py", line 685, in parser_f
return _read(filepath_or_buffer, kwds)

File "/usr/local/lib64/python3.6/site-packages/pandas/io/parsers.py", line 457, in _read
parser = TextFileReader(fp_or_buf, **kwds)

 File "/usr/local/lib64/python3.6/site-packages/pandas/io/parsers.py", line 895, in __init__
self._make_engine(self.engine)

File "/usr/local/lib64/python3.6/site-packages/pandas/io/parsers.py", line 1135, in _make_engine
self._engine = CParserWrapper(self.f, **self.options)

 File "/usr/local/lib64/python3.6/site-packages/pandas/io/parsers.py", line 1917, in __init__
self._reader = parsers.TextReader(src, **kwds)

 File "pandas/_libs/parsers.pyx", line 382, in pandas._libs.parsers.TextReader.__cinit__

 File "pandas/_libs/parsers.pyx", line 689, in pandas._libs.parsers.TextReader._setup_parser_source

FileNotFoundError: [Errno 2] File b'Housing.csv' does not exist: b'Housing.csv'

'''

我的housing.csv与lab_5.py位于同一文件夹中。谁能解释一下如何将csv上传到cloud9，以便可以正确读取它。

Answer 1

当它在您的输出中显示时，第二段:

'''
File "/home/ec2-user/environment/lab_5.py", line 4, in <module>
pd.read_csv("Housing.csv")
'''

它为您提供了Cloud9中的当前工作目录:

/home/ec2-user/environment/lab_5.py

如果您的csv与lab_5.py位于同一文件夹中，那么您应该可以像这样用Housing.csv替换它，然后将其插入pandas.read_csv():

pd.read_csv("/home/ec2-user/environment/Housing.csv")

当我这样做的时候，我就能够使它工作。
另外，在Cloud9文件浏览器的顶部，它应该说出您的目录。屏幕快照中的一个是“/home/ec2-user/environment”，而另一个常见的是“/home/ubuntu/environment”。
Your Cloud9 directory: This one is "/home/ec2-user/environment"