New posts are disabled while we improve the user experience.

You can browse the site, or for urgent issues, raise a query at MyAccount.

question

Upvotes
Accepted
charles.malafosse avatar image
43 ●7 ●7 ●6

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

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

pythondatastream-apidsws-api
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvotes
Accepted
charles.malafosse avatar image
43 ●7 ●7 ●6

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))
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.