0

When I run this command: 

k1=pd.read_table("https://raw.githubusercontent.com/justmarkham/pandas-videos/master/data/chipotle.tsv")

I receive this error:

Command on Pandas: attached.

--------------------------------------------------------------------------- ParserError Traceback (most recent call last) in () ----> 1 pd.read_table('')

~\AppData\Local\Continuum\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

~\AppData\Local\Continuum\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()

~\AppData\Local\Continuum\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'):

~\AppData\Local\Continuum\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 1 fields in line 7, saw 2

Followed this stackoverflow thread, but no help

Improve this question
2
  • read_table and other read_* functions work on files, not webpages. Commented Mar 19, 2018 at 5:36
  • @BurhanKhalid not sure that is true pandas.pydata.org/docs/reference/api/… Commented Apr 5, 2021 at 21:00

1 Answer 1

Reset to default
1

try this to handle bad lines:

k1=pd.read_table(
r'https://raw.githubusercontent.com/justmarkham/pandas-videos/master/data/chipotle.tsv'
,error_bad_lines=False
)
Improve this answer
Sign up to request clarification or add additional context in comments.

3 Comments

Received following error. URLError: <urlopen error [SSL: TLSV1_ALERT_ACCESS_DENIED] tlsv1 alert access denied (_ssl.c:777)>
@prvreddy i assume you are working behind a corporate proxy.... you need to set your proxy before you can access external web resources
@prvreddy Add "https_proxy" and "http_proxy" to you system environment variable, like: proxy.XXXX.com:8020... you can check your OS manual to see how to add environment variables and you IT department for the proxy address. After adding, you need to restart your python to enable the proxy.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.