How can one define empty (NULL) fields in a Python request for Refinitiv Data Library?

The Python command

df=rd.get_data('AAPL.OQ', ['TR.ISINCode', , , 'TR.InstrumentType'])

returns a syntax error.

What I would like to do is for formatting purposes to have some empty (NULL) fields between the fields TR.ISINCode and TR.InstrumentType. How can empty fields be specified?

Find more posts tagged with

python api

#technology

Accepted answers

Gurpreet

Hi @IoannisG,

Its always a good idea to separate the data from display. You cannot add null fields into the request and it is not a good idea anyways. Formatting the displayed data should be done with dataframe. Pandas has couple of options for column width settings which you can utilize.

You can even iterate over the dataframe and write your own data render routines, in the manner that you prefer.

All comments

Gurpreet

Hi @IoannisG,

You can even iterate over the dataframe and write your own data render routines, in the manner that you prefer.

Hi @IoannisG ,

As Gurpreet mentionned, you can use Pandas functions to rework a result.
This example will insert an empty column between TR.ISINCode and TR.InstrumentType:

df = rd.get_data('AAPL.OQ', ['TR.ISINCode', 'TR.InstrumentType'])
df.insert(1, "", "")

But columns are unique so you can't do this insert twice.

EXPLORE OUR SITES