FutureWarning for data_grid.py (pandas.np module is deprecated and will be removed... import numpy directly instead) when using Eikon Python API

Question

Question by Keng Onn · Apr 23, 2020 at 02:40 AM · eikon eikon-data-api workspace workspace-data-api refinitiv-dataplatform-eikon python pandas deprecated

FutureWarning for data_grid.py (pandas.np module is deprecated and will be removed... import numpy directly instead) when using Eikon Python API

Hi,

I see a warning when using Eikon's Python API package (eikon). The commands I ran were:

import eikon as ek
ek.set_app_key('....')
df2, err = ek.get_data(['RIC_1', 'RIC_2' ...], ['TRD_STATUS'])

The warning message I see is:

C:\Users\kengwong\KOminiconda3\envs\brk\lib\site-packages\eikon\data_grid.py:247: FutureWarning: The pandas.np module is deprecated and will be removed from pandas in a future version. Import numpy directly instead
  data = pd.np.array([[get_data_value(value) for value in row] for row in data_dict['data']])

This is not an error, it looks more like a warning.

Cheers,
Keng Onn

0 Show 2

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

alex.yermolayev · May 11, 2020 at 01:01 PM 1

Share

Hello! @

Is there an update to this, please? The pandas.np submodule will be deprecated and we will not be able to run get_data() requests unless they are changed.

Keng Onn · Apr 23, 2020 at 02:43 AM 0

Share

Here're the versions of Python, pandas and eikon that I'm using:

Python: 3.6.8
eikon: 1.1.2
pandas: 1.0.1

Answer 1 · 2020-04-23T06:39:45Z

REFINITIV

Best Answer

Answer by Jirapongse · Apr 23, 2020 at 06:39 AM

@Keng Onn

Thank you so much for the information.

Refer to Pandas: What’s new in 1.0.0 (January 29, 2020), it indicates that the pandas.np submodule is now deprecated.

However, Eikon Data APIs python still uses pd.np. Eikon Data APIs library requires pandas>=0.17.0.

I will report this problem to the product team for consideration.

1587623684550.png (57.9 KiB)

0 Show 3 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

alex.yermolayev · May 11, 2020 at 01:01 PM 0

Share

Hello! @

Is there an update to this, please? The pandas.np submodule will be deprecated and we will not be able to run get_data() requests unless they are changed.

REFINITIV

Jirapongse ♦♦ alex.yermolayev · May 13, 2020 at 03:47 AM 0

Share

@alex.yermolayev

There is no update from the product team.

However, from my testing, the data can be retrieved properly although it reports the warning messages.

Otherwise, you may need to use pandas < 1.0.0 instead.

1589341511612.png (31.0 KiB)

davidk Jirapongse ♦♦ · May 13, 2020 at 07:35 PM 2

Share

Pandas is now using SemVer so pd.np should be available through pandas 2.0.0 without code breakage (deprecations introduced in the 1.x series will no longer be removed until 2.x). Realistically it will probably last at least a year.

That said, referencing pd.np was never good design practice. Pandas's internal import of numpy accidentally made it into the public pandas namespace but wasn't supposed to be used. This should be fixed in the eikon code to import numpy as np directly.

FutureWarning for data_grid.py (pandas.np module is deprecated and will be removed... import numpy directly instead) when using Eikon Python API

1 Reply

Watch this question

Related Questions