Filter for organizations with Empty GicsCode category via Python API

Using the Python Refinitiv.data API I want to filter for organizations without a GICS code. How can I setup the filter query to exactly filter for "" (empty string?)

This is the code I am using:

import refinitiv.data as rd
rd.open_session()

response = search.Definition(
view = search.Views.ORGANISATIONS,
filter = f"GicsCode xeq ''",
select = 'OAPermID,CommonName,GicsCode',
top=10000 # maximum number of rows
).get_data()

The result is an Empty List.

The code works, because when filtering for a GicsCode such as 20106020 I retrieve 1573 organizations.

However, not all organizations have a GicsCode. For example "Fox E-Mobility AG", organization OAPermID "5071502736" does not have a GicsCode, value is empty. How can I setup a filter to select organizations that do not have a Gics Code?

I would like to have an answer like filter req '' or isEmpty? Thanks

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @r.fernandez

    Thank you for reaching out to us.

    Please try this one:

    response = search.Definition(
                    view = search.Views.ORGANISATIONS,
                    filter = f"GicsCode eq null",
                    select = 'OAPermID,CommonName,GicsCode',
                    top=100 # maximum number of rows
                ).get_data()
    response.data.df

    1714368108297.png


Answers