Cannot make sense of dataframe format returned by Python datastream API PyDSWS

Options
charles.malafosse
charles.malafosse Explorer
in Datastream

Hello,

I use the simple python line of code to get the constituents of S&P500:

data1= ds.get_data(tickers="LS&PCOMP", fields='P,PE,MV,NAME,RIC')

However I cannot make sense of the dataframe it returns. It seems to have multiple layers and I can't see how to iterate through the dataframe to create a simple list of (Id, P,PE,MV,NAME,RIC) for each constituent of S&P500. 

data1
Out[114]: 
Instrument   891399 916328 545101  777953  906187 936365    749382  891631  \
Field             P      P      P       P       P      P         P       P   
Date                                                                         
2019-03-22  1764.77  77.97  18.06  323.21  139.45  26.37  259.6899  141.72

I am sure it's not that difficult but I would greatly appreciate help on this.

Many thanks.

Charles

Tagged:

Best Answer

  • charles.malafosse
    charles.malafosse Explorer
    Answer ✓

    I found a solution.

    The dataframe returned has a multi index. I wish the documentation on the community dev website would clearly mention that.

    Here is what I use to get the data for each constituent:

    	df_index = data1.transpose()
            for item in df_index.index.get_level_values(0):
                print(item)
                print(df_index.xs(item))

Categories