我对Python非常陌生,这将是一个非常基本的问题。我希望用户输入csv文件的名称,我希望用panda打开该文件,以便轻松访问其行和列。这是我写的代码:
import pandas as pd
DATAFIN = str(raw_input("Name of your data file"))
dataset = pd.read_csv(DATAFIN)
dataset.head()
然而,我似乎犯了某种错误,因为这是我收到的信息(很抱歉长度(:
Traceback (most recent call last):
File "c:UsersFile.py", line 34, in <module>
dataset = pd.read_csv(DATAFIN)
File "C:Python27libsite-packagespandasioparsers.py", line 702, in parser_f
return _read(filepath_or_buffer, kwds)
File "C:Python27libsite-packagespandasioparsers.py", line 429, in _read
parser = TextFileReader(filepath_or_buffer, **kwds)
File "C:Python27libsite-packagespandasioparsers.py", line 895, in __init__
self._make_engine(self.engine)
File "C:Python27libsite-packagespandasioparsers.py", line 1122, in _make_engine
self._engine = CParserWrapper(self.f, **self.options)
File "C:Python27libsite-packagespandasioparsers.py", line 1853, in __init__
self._reader = parsers.TextReader(src, **kwds)
File "pandas_libsparsers.pyx", line 387, in pandas._libs.parsers.TextReader.__cinit__
File "pandas_libsparsers.pyx", line 705, in pandas._libs.parsers.TextReader._setup_parser_source
does not exist: ' maindata.csvr'csv
你知道哪个是问题吗?我对格式上的任何错误感到抱歉。
看起来你在字符串中使用了一个空格字符
' maindata.csvr'
尝试键入不带空格的csv名称
所以看起来像
Name of your data filemaindata.csv
尝试使用pd.read_csv(r'address of the file.csv
'读取csv文件(
使用argparse从命令行获取文件名。通过python script.py --filename file.csv
运行脚本并使用打印查看结果
import pandas as pd
import argparse
parser = argparse.ArgumentParser()
parser.add_argument('--filename')
args = parser.parse_args()
dataset = pd.read_csv(args.filename)
print(dataset.head())