程序報(bào)錯(cuò)，求指教
txt轉(zhuǎn)化csv文件內(nèi)容
學(xué)號(hào),姓名,得分
001,A,100
002,B,60
003,C,80
代碼
import pandas as pd
score=pd.read_csv("C:\Users\acer\Desktop\test")
print score
Traceback (most recent call last):
? File "D:\Java\myeclipse\workspace\IPython\com\Test\test_pandas_read.py", line 2, in <module>
??? score=pd.read_csv("C:\Users\acer\Desktop\test")
? File "D:\Python\Python\lib\site-packages\pandas\io\parsers.py", line 645, in parser_f
??? return _read(filepath_or_buffer, kwds)
? File "D:\Python\Python\lib\site-packages\pandas\io\parsers.py", line 388, in _read
??? parser = TextFileReader(filepath_or_buffer, **kwds)
? File "D:\Python\Python\lib\site-packages\pandas\io\parsers.py", line 729, in __init__
??? self._make_engine(self.engine)
? File "D:\Python\Python\lib\site-packages\pandas\io\parsers.py", line 922, in _make_engine
??? self._engine = CParserWrapper(self.f, **self.options)
? File "D:\Python\Python\lib\site-packages\pandas\io\parsers.py", line 1389, in __init__
??? self._reader = _parser.TextReader(src, **kwds)
? File "pandas\parser.pyx", line 373, in pandas.parser.TextReader.__cinit__ (pandas\parser.c:4175)
? File "pandas\parser.pyx", line 667, in pandas.parser.TextReader._setup_parser_source (pandas\parser.c:8440)
IOError: File C:\Userscer\Desktop?? ?est does not exist
2017-09-28
那個(gè)路徑需要當(dāng)前路徑
所以需要兩種方法：1.
import os?
os.getcwd()----獲取當(dāng)前工作路徑，把csv文件保存到當(dāng)前工作路徑下
2.
import os?
os.chdir('此處是你csv文件夾所在的目錄路徑')---改變當(dāng)前目錄
再調(diào)用os.getcwd()----獲取當(dāng)前工作路徑，看是否修改成功
>>> import os
>>> os.getcwd()
'D:\\software\\Python'
>>> os.chdir('E:\python')
>>> os.getcwd()
'E:\\python'
>>> br=pandas.read_csv('brics.csv')
>>>?
2016-12-25
import pandas as pd
score=pd.read_csv(r"C:\Users\acer\Desktop\test.csv")
print score
試下這個(gè)可以不，我這邊沒(méi)電腦試
2016-11-29
還是不行
2016-11-27
試一試下面的行不行，另外表格不用print吧,看到>>>以后直接輸入表格名字score就行了，我也是新手。
import?pandas?as?pd score=pd.read_csv("C:\Users\acer\Desktop\test"，encoding="gb2312")