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)



Welcome!

It looks like you're new here. Sign in or register to get started.

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.