从Adwords下载数据并使用Pandas读取fi

Question

我使用Python从Adwords下载一些报告，然后pandas重新格式化数据。在

import pandas as pd
from googleads import adwords

    stream_data = downloader.DownloadReportWithAwql(
        products_query,
        'CSV', output_file,
        client_customer_id='xxxxx',
        skip_report_header=True,
        skip_report_summary=True,
        skip_column_header=False)

    data = pd.read_csv(output_file,
                       sep=',',
                       encoding='utf-8-sig',
                       header=1,
                       error_bad_lines=False,
                       warn_bad_lines=False)
    print(data)

生成的文件如下所示：

^{pr2}$

但是，由于某些原因，我得到了这个错误：

Traceback (most recent call last):
  File "/Users/nasiantalla/PycharmProjects/adwords_test.py", line 95, in <module>
    error_bad_lines=False)
  File "/Users/nasiantalla/Library/Python/3.6/lib/python/site-packages/pandas/io/parsers.py", line 646, in parser_f
    return _read(filepath_or_buffer, kwds)
  File "/Users/nasiantalla/Library/Python/3.6/lib/python/site-packages/pandas/io/parsers.py", line 389, in _read
    parser = TextFileReader(filepath_or_buffer, **kwds)
  File "/Users/nasiantalla/Library/Python/3.6/lib/python/site-packages/pandas/io/parsers.py", line 730, in __init__
    self._make_engine(self.engine)
  File "/Users/nasiantalla/Library/Python/3.6/lib/python/site-packages/pandas/io/parsers.py", line 923, in _make_engine
    self._engine = CParserWrapper(self.f, **self.options)
  File "/Users/nasiantalla/Library/Python/3.6/lib/python/site-packages/pandas/io/parsers.py", line 1390, in __init__
    self._reader = _parser.TextReader(src, **kwds)
  File "pandas/parser.pyx", line 535, in pandas.parser.TextReader.__cinit__ (pandas/parser.c:6086)
  File "pandas/parser.pyx", line 710, in pandas.parser.TextReader._get_header (pandas/parser.c:8843)
  File "pandas/parser.pyx", line 911, in pandas.parser.TextReader._tokenize_rows (pandas/parser.c:11308)
  File "pandas/parser.pyx", line 2014, in pandas.parser.raise_parser_error (pandas/parser.c:26862)
TypeError: raise: exception class must be a subclass of BaseException

我试过用不同的腐蚀类型，但还是一样。。有什么想法吗？在

Answer 1

退房：

https://github.com/pandas-dev/pandas/issues/6035

试着把分隔符当作一根绳子来拉？在

sep = str(‘,’)