python - python(pandas)中的Dataframe有问题

Question

我的数据框有问题，我需要帮助

代码：

import pandas as pd
from pandas import Series, DataFrame

# example - Revenue of companies

revenue_df = pd.read_clipboard()
print revenue_df

Traceback (most recent call last):
  File "C:/Users/Techie-Jife/PycharmProjects/Data Science/DataFrame.py", line 6, in <module>
    revenue_df = pd.read_clipboard()
  File "C:\Users\Techie-Jife\venv\lib\site-packages\pandas\io\clipboards.py", line 85, in read_clipboard
    return read_csv(StringIO(text), sep=sep, **kwargs)
  File "C:\Users\Techie-Jife\venv\lib\site-packages\pandas\io\parsers.py", line 702, in parser_f
    return _read(filepath_or_buffer, kwds)
  File "C:\Users\Techie-Jife\venv\lib\site-packages\pandas\io\parsers.py", line 435, in _read
    data = parser.read(nrows)
  File "C:\Users\Techie-Jife\venv\lib\site-packages\pandas\io\parsers.py", line 1139, in read
    ret = self._engine.read(nrows)
  File "C:\Users\Techie-Jife\venv\lib\site-packages\pandas\io\parsers.py", line 2415, in read
    alldata = self._rows_to_cols(content)
  File "C:\Users\Techie-Jife\venv\lib\site-packages\pandas\io\parsers.py", line 3066, in _rows_to_cols
    self._alert_malformed(msg, row_num + 1)
  File "C:\Users\Techie-Jife\venv\lib\site-packages\pandas\io\parsers.py", line 2835, in _alert_malformed
    raise ParserError(msg)
pandas.errors.ParserError: Expected 4 fields in line 4, saw 5. Error could possibly be due to quotes being ignored when a multi-char delimiter is used.

Process finished with exit code 1

标签： pythonpandasdataframe

Answer 1

Edit1：如果您不选择剪贴板的标题，您不会遇到问题。

import pandas as pd
from pandas import Series, DataFrame

# example - Revenue of companies

revenue_df = pd.read_clipboard(sep='\t', header=None)
print (revenue_df)