How could I transpose the table (Python Eikon Data API)?

The following code shows RICs in a column whereas I want to have RICs in a row (first row).

import eikon as ek

ek.set_app_key('')

df, err = ek.get_data(

instruments = ['GAZP.MM', 'SBER.MM'],

fields = ['TR.CLOSEPRICE(Frq=D,SDate=2021-12-01,EDate=2021-12-19,Curn=USD).date','TR.CLOSEPRICE(Frq=D,SDate=2021-12-01,EDate=2021-12-19,Curn=USD)' ]

)

display(df)

Find more posts tagged with

python

eikon-data-api

Accepted answers

zoya faberov

Hello @susskaya.anita ,

Try this:

df.pivot(index = 'Date', columns = 'Instrument', values ='Close Price')

Results with your request look like this from my testing:

All comments

zoya faberov

Hello @susskaya.anita ,

Are you looking for:

https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.transpose.html

df.transpose()

susskaya.anita

Thanks for your answer, but I would like to have something like this:

and not this:

In excel via Formula Builder we could do that easily.

zoya faberov

Hello @susskaya.anita ,

Try this:

df.pivot(index = 'Date', columns = 'Instrument', values ='Close Price')

Results with your request look like this from my testing:

dianne.palmario

Hello, how can I transpose the table for below script where the RICs are in rows while Dates/Values are in Columns?

I tried df.pivot(index = 'Instrument', columns = 'Date', values ='Close Price') ;

I also tried display(df.transpose) and both did not work.

import refinitiv.data as rd

rd.open_session()

df = rd.get_history(

universe=["EURNZDFIXM=WM", "USDEURFIXM=WM", "EURCADFIXM=WM", "EURGBPFIXM=WM", "EURJPYFIXM=WM", "EURNOKFIXM=WM", "EURSEKFIXM=WM", "EURDKKFIXM=WM", "EURCHFFIXM=WM", "EURHKDFIXM=WM", "EURAUDFIXM=WM", "EURSGDFIXM=WM", "EURZARFIXM=WM", "EURTOFFIXM=WM", "EURIDRFIXM=WM"],

fields=["TR.MIDPRICE"],

interval="1M",

start="2022-12-30",

end="2022-12-30"

)

EXPLORE OUR SITES