I get an error when trying to retrieve news headlines with Python API. The error only seems to occur on certain time ranges. For example, this works:
import eikon as ek
df = ek.get_news_headlines('Topic:ESG AND Language:LEN', date_from='2022-01-01', date_to='2022-12-01', count=100)
But this does not work (the only difference is the time range):
import eikon as ek
df = ek.get_news_headlines('Topic:ESG AND Language:LEN', date_from='2020-01-01', date_to='2020-12-01', count=100)
This is the error I receive:
Traceback (most recent call last):
File "...\PycharmProjects\refinitivsentiment\main.py", line 12, in <module>
df = ek.get_news_headlines(date_from='2020-01-01',
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "...\AppData\Local\Programs\Python\Python311\Lib\site-packages\eikon\news_request.py", line 126, in get_news_headlines
return get_data_frame(result)
^^^^^^^^^^^^^^^^^^^^^^
File "...\AppData\Local\Programs\Python\Python311\Lib\site-packages\eikon\news_request.py", line 144, in get_data_frame
headlines_dataframe = pd.DataFrame([], numpy.array(first_created, dtype='datetime64'), Headline_Selected_Fields)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "...\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\frame.py", line 771, in __init__
mgr = dict_to_mgr(
^^^^^^^^^^^^
File "...\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\internals\construction.py", line 450, in dict_to_mgr
index = ensure_index(index)
^^^^^^^^^^^^^^^^^^^
File "...\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\indexes\base.py", line 7333, in ensure_index
return Index._with_infer(index_like, copy=copy)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "...\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\indexes\base.py", line 716, in _with_infer
result = cls(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^
File "...\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\indexes\base.py", line 486, in __new__
result = klass(data, copy=copy, name=name, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "...\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\indexes\datetimes.py", line 359, in __new__
dtarr = DatetimeArray._from_sequence_not_strict(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "...\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\arrays\datetimes.py", line 307, in _from_sequence_not_strict
subarr, tz, inferred_freq = _sequence_to_dt64ns(
^^^^^^^^^^^^^^^^^^^^
File "...\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\arrays\datetimes.py", line 2091, in _sequence_to_dt64ns
data = astype_overflowsafe(data, dtype=DT64NS_DTYPE)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "pandas\_libs\tslibs\np_datetime.pyx", line 288, in pandas._libs.tslibs.np_datetime.astype_overflowsafe
File "pandas\_libs\tslibs\np_datetime.pyx", line 321, in pandas._libs.tslibs.np_datetime.astype_overflowsafe
ValueError: datetime64/timedelta64 values and dtype must have a unit specified
Do you have any ideas what could be causing the error?
