question

Upvotes
Accepted
1 0 0 2

Hello community, my question is about reshaping datastream retrieved data to panel data form.

I have downloaded a set of data (equity, debt, cash ...) for 8 countries from 2006 to 2018 in datastream form where the years are placed on the first column and the variables on the first line. I would like to know whether it is possible to reshape my data into panel data form?

datastream-apidsws-api
icon clock
10 |1500

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

@abdessamadraghibi

Is it DataStream API or Excel?

Upvotes
Accepted
38.1k 69 35 53

@abdessamadraghibi

If you are using DataStream in Excel, please kindly contact the DataStream support team via MyRefinitiv for any further assistance.


1585810016497.png (6.7 KiB)
icon clock
10 |1500

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

Upvotes
11.5k 16 7 10

Hello @abdessamadraghibi

Is it Datastream API or Excel? If you are using DatastreamDSWS for Python, the returned data is Pandas Dataframe object which is already a panel form.

To learn more regarding DatastreamDSWS, please check the following resources:

icon clock
10 |1500

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

Hello @Wasinwaeosri,

Thank you for your feedback,


My data is on Excel form. I tried many tricks but in vain!

Click below to post an Idea Post Idea