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

susskaya.anita
susskaya.anita
in Eikon Data APIs

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)



Tagged:

Best Answer

  • zoya faberov
    zoya faberov
    Answer ✓

    Hello @susskaya.anita ,

    Try this:

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

    Results with your request look like this from my testing:

    pivot.gif


Answers

  • zoya faberov
    zoya faberov

    Hello @susskaya.anita ,

    Are you looking for:

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

    df.transpose()
  • susskaya.anita
    susskaya.anita

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

    1640077162232.png

    and not this:

    1640077197978.png

    In excel via Formula Builder we could do that easily.

  • dianne.palmario
    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"

    )


Categories