Datastream Point in Time Data Manipulation

Thank you for sharing the code.

I ran the code and found that Dates is already an index.

You may refer to this article on Medium regarding How to flatten MultiIndex Columns and Rows in Pandas.

I can run the following code to concatenate two data frames by Dates.

df1 = ds.get_data(tickers='@AAPL, @FB, @GOOGL, @MSFT, @NXPI';, 
            fields=['SOCOO01V','ENPIDP048','SOHRDP012','SOEQ','SOTDDP018','SODODP0012','ENRRDP033','ENERDP052','CGVSDP030'],
            start='-5Y', freq='Y')
df2 = ds.get_data(tickers='U:JPM, U:XOM, U:BAC, U:BABA, U:V', 
            fields=['SOCOO01V','ENPIDP048','SOHRDP012','SOEQ','SOTDDP018','SODODP0012','ENRRDP033','ENERDP052','CGVSDP030'],
            start='-5Y', freq='Y')
pd.concat([df1, df2], axis=1)

The output is:

All comments

Please share the code that you are using to retrieve the data.

ds.get_data(tickers='@AAPL, @FB, @GOOGL, @MSFT, @NXPI, U:JPM, U:XOM, U:BAC, U:BABA, U:V', fields=['SOCOO01V','ENPIDP048','SOHRDP012','SOEQ','SOTDDP018','SODODP0012','ENRRDP033','ENERDP052','CGVSDP030'], start='-5Y', freq='Y')

if you print df.dtypes() you will see that "Dates" is not one of the column

@Jirapongse

if you print df.dtypes() you will see that "Dates" is not one of the column

Thank you for sharing the code.

I ran the code and found that Dates is already an index.

You may refer to this article on Medium regarding How to flatten MultiIndex Columns and Rows in Pandas.

I can run the following code to concatenate two data frames by Dates.

df1 = ds.get_data(tickers='@AAPL, @FB, @GOOGL, @MSFT, @NXPI';, 
            fields=['SOCOO01V','ENPIDP048','SOHRDP012','SOEQ','SOTDDP018','SODODP0012','ENRRDP033','ENERDP052','CGVSDP030'],
            start='-5Y', freq='Y')
df2 = ds.get_data(tickers='U:JPM, U:XOM, U:BAC, U:BABA, U:V', 
            fields=['SOCOO01V','ENPIDP048','SOHRDP012','SOEQ','SOTDDP018','SODODP0012','ENRRDP033','ENERDP052','CGVSDP030'],
            start='-5Y', freq='Y')
pd.concat([df1, df2], axis=1)

The output is:

@Jirapongse

Hi Jirapongse, try an economic data item from datastream navigator.

df = ds.get_data (tickers='USCONPRCE',

start='2007-05-10', end='2023-04-21', freq='D')

when you try the df.types() later u will only get, i need to be able to access the Dates column to make it an index

Instrument  Field  Currency
USCONPRCE          U$          float64
dtype: object 

MultiIndex([('USCONPRCE', '', 'U$')],
           names=['Instrument', 'Field', 'Currency'])

After doing the above, the dates have been set as the index as such i am able to concat both dataframes. the problem now is that the column with the values does not have a column headers, because the instrument is a multindex format hence it is not directly above the values of the column that it is supposed to relate to. how should i go about solving this issue.