Heikki10 2020-02-29 10:42 采纳率: 0%
浏览 781

使用pd.read_clipboard()时报错

图片说明
然后就报错
ParserError Traceback (most recent call last)
in
----> 1 df = pd.read_clipboard()

D:\anaconda\lib\site-packages\pandas\io\clipboards.py in read_clipboard(sep, **kwargs)
71 )
72
---> 73 return read_csv(StringIO(text), sep=sep, **kwargs)
74
75

D:\anaconda\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, 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, dialect, error_bad_lines, warn_bad_lines, delim_whitespace, low_memory, memory_map, float_precision)
683 )
684
--> 685 return read(filepath_or_buffer, kwds)
686
687 parser_f.
_name__ = name

D:\anaconda\lib\site-packages\pandas\io\parsers.py in _read(filepath_or_buffer, kwds)
461
462 try:
--> 463 data = parser.read(nrows)
464 finally:
465 parser.close()

D:\anaconda\lib\site-packages\pandas\io\parsers.py in read(self, nrows)
1152 def read(self, nrows=None):
1153 nrows = _validate_integer("nrows", nrows)
-> 1154 ret = self._engine.read(nrows)
1155
1156 # May alter columns / col_dict

D:\anaconda\lib\site-packages\pandas\io\parsers.py in read(self, rows)
2491 content = content[1:]
2492
-> 2493 alldata = self._rows_to_cols(content)
2494 data = self._exclude_implicit_index(alldata)
2495

D:\anaconda\lib\site-packages\pandas\io\parsers.py in _rows_to_cols(self, content)
3155 msg += ". " + reason
3156
-> 3157 self._alert_malformed(msg, row_num + 1)
3158
3159 # see gh-13320

D:\anaconda\lib\site-packages\pandas\io\parsers.py in _alert_malformed(self, msg, row_num)
2912
2913 if self.error_bad_lines:
-> 2914 raise ParserError(msg)
2915 elif self.warn_bad_lines:
2916 base = "Skipping line {row_num}: ".format(row_num=row_num)

ParserError: Expected 2 fields in line 44, saw 3. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.

  • 写回答

1条回答 默认 最新

  • secular_ 2020-08-10 11:15
    关注

    虽然还是不知道根源是啥,但是可以试试带格式粘贴到WPS上,再从WPS复制粘贴过来,就好了。(而且WPS可以 word不行,不是很懂)继续蹲大神解答。。

    评论

报告相同问题?

悬赏问题

  • ¥15 stm32开发clion时遇到的编译问题
  • ¥15 lna设计 源简并电感型共源放大器
  • ¥15 如何用Labview在myRIO上做LCD显示?(语言-开发语言)
  • ¥15 Vue3地图和异步函数使用
  • ¥15 C++ yoloV5改写遇到的问题
  • ¥20 win11修改中文用户名路径
  • ¥15 win2012磁盘空间不足,c盘正常,d盘无法写入
  • ¥15 用土力学知识进行土坡稳定性分析与挡土墙设计
  • ¥70 PlayWright在Java上连接CDP关联本地Chrome启动失败,貌似是Windows端口转发问题
  • ¥15 帮我写一个c++工程