shilewenuw / get_all_tickers

Get all publicly traded tickers with this library
MIT License
273 stars 123 forks source link

parse Error #25

Open cefbursatil opened 2 years ago

cefbursatil commented 2 years ago

ParserError Traceback (most recent call last)

in ----> 1 gt.get_tickers() D:\Anaconda3\lib\site-packages\get_all_tickers\get_tickers.py in get_tickers(NYSE, NASDAQ, AMEX) 71 tickers_list = [] 72 if NYSE: ---> 73 tickers_list.extend(__exchange2list('nyse')) 74 if NASDAQ: 75 tickers_list.extend(__exchange2list('nasdaq')) D:\Anaconda3\lib\site-packages\get_all_tickers\get_tickers.py in __exchange2list(exchange) 136 137 def __exchange2list(exchange): --> 138 df = __exchange2df(exchange) 139 # removes weird tickers 140 df_filtered = df[~df['Symbol'].str.contains("\.|\^")] D:\Anaconda3\lib\site-packages\get_all_tickers\get_tickers.py in __exchange2df(exchange) 132 response = requests.get('https://old.nasdaq.com/screening/companies-by-name.aspx', headers=headers, params=params(exchange)) 133 data = io.StringIO(response.text) --> 134 df = pd.read_csv(data, sep=",") 135 return df 136 D:\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, 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:\Anaconda3\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:\Anaconda3\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:\Anaconda3\lib\site-packages\pandas\io\parsers.py in read(self, nrows) 2057 def read(self, nrows=None): 2058 try: -> 2059 data = self._reader.read(nrows) 2060 except StopIteration: 2061 if self._first_chunk: pandas\_libs\parsers.pyx in pandas._libs.parsers.TextReader.read() pandas\_libs\parsers.pyx in pandas._libs.parsers.TextReader._read_low_memory() pandas\_libs\parsers.pyx in pandas._libs.parsers.TextReader._read_rows() pandas\_libs\parsers.pyx in pandas._libs.parsers.TextReader._tokenize_rows() pandas\_libs\parsers.pyx in pandas._libs.parsers.raise_parser_error() ParserError: Error tokenizing data. C error: Expected 1 fields in line 6, saw 48
solvire commented 1 year ago

I got this too. Format changed?

EduardoDeLima commented 1 year ago

Any news about this issue? I am getting it too.

kapedalex commented 1 year ago

I got this error from CIS country, and ProxyError with VPN.