DataFrame df=pd.read_clipboard() 返回错误

来源:3-2 Pandas DataFrame

pyhton数分

2018-01-10

环境 win 10,python 3.0,jupyter note

import numpy as np
import pandas as pd
from pandas import Series,DataFrame

import webbrowser
link='https://www.tiobe.com/tiobe-index/'
webbrowser.open(link)

Out[13]:True

df=pd.read_clipboard()
df

#已经复制了

下面是返回的错误:

---------------------------------------------------------------------------
ParserError                               Traceback (most recent call last)
<ipython-input-17-a0594a35792f> in <module>()
----> 1 df=pd.read_clipboard()
     2 df

C:\ProgramData\Anaconda3\lib\site-packages\pandas\io\clipboards.py in read_clipboard(sep, **kwargs)
    61         sep = '\s+'
    62
---> 63     return read_table(StringIO(text), sep=sep, **kwargs)
    64
    65

C:\ProgramData\Anaconda3\lib\site-packages\pandas\io\parsers.py in parser_f(filepath_or_buffer, sep, delimiter, header, names, index_col, usecols, squeeze, prefix, mangle_dupe_cols, dtype, engine, converters, true_values, false_values, skipinitialspace, skiprows, nrows, na_values, keep_default_na, na_filter, verbose, skip_blank_lines, parse_dates, infer_datetime_format, keep_date_col, date_parser, dayfirst, iterator, chunksize, compression, thousands, decimal, lineterminator, quotechar, quoting, escapechar, comment, encoding, dialect, tupleize_cols, error_bad_lines, warn_bad_lines, skipfooter, skip_footer, doublequote, delim_whitespace, as_recarray, compact_ints, use_unsigned, low_memory, buffer_lines, memory_map, float_precision)
   653                     skip_blank_lines=skip_blank_lines)
   654
--> 655         return _read(filepath_or_buffer, kwds)
   656
   657     parser_f.__name__ = name

C:\ProgramData\Anaconda3\lib\site-packages\pandas\io\parsers.py in _read(filepath_or_buffer, kwds)
   409
   410     try:
--> 411         data = parser.read(nrows)
   412     finally:
   413         parser.close()

C:\ProgramData\Anaconda3\lib\site-packages\pandas\io\parsers.py in read(self, nrows)
  1003                 raise ValueError('skipfooter not supported for iteration')
  1004
-> 1005         ret = self._engine.read(nrows)
  1006
  1007         if self.options.get('as_recarray'):

C:\ProgramData\Anaconda3\lib\site-packages\pandas\io\parsers.py in read(self, nrows)
  1746     def read(self, nrows=None):
  1747         try:
-> 1748             data = self._reader.read(nrows)
  1749         except StopIteration:
  1750             if self._first_chunk:

pandas/_libs/parsers.pyx in pandas._libs.parsers.TextReader.read (pandas\_libs\parsers.c:10862)()

pandas/_libs/parsers.pyx in pandas._libs.parsers.TextReader._read_low_memory (pandas\_libs\parsers.c:11138)()

pandas/_libs/parsers.pyx in pandas._libs.parsers.TextReader._read_rows (pandas\_libs\parsers.c:11884)()

pandas/_libs/parsers.pyx in pandas._libs.parsers.TextReader._tokenize_rows (pandas\_libs\parsers.c:11755)()

pandas/_libs/parsers.pyx in pandas._libs.parsers.raise_parser_error (pandas\_libs\parsers.c:28765)()

ParserError: Error tokenizing data. C error: Expected 2 fields in line 46, saw 3

写回答

5回答

pyhton数分

提问者

2018-01-10

直接网页复制的,还需要复制到excle中去除相关的超链接。

1
1
王振2
赞,实测有效
2020-03-10
共1条回复

麦兜搞IT

2018-01-10

课程页面右侧有源码下载,可以点击下载

0
0

pyhton数分

提问者

2018-01-10

如何下载home work中的数据文档

0
0

麦兜搞IT

2018-01-10

我就是直接复制的,并没有加工处理

0
0

麦兜搞IT

2018-01-10

您好,read_clipboard方法能成功执行比较苛刻。绝对不能复制额外的东西。比如我把我复制的粘贴出来是这样的//img.mukewang.com/szimg/5a55af060001599c11720760.jpg

0
1
麦兜搞IT
pandas是通过这个文本,然后空格(有时候是别的字符)去分割出一个table的
2018-01-10
共1条回复

Python数据分析入门与实践,开启Data Science职业之旅

只要会python,就能轻松入门数据分析!

2217 学习 · 338 问题

查看课程