Hi as the Point in Time data returns a multi-index dataframe, i am having trouble accessing the Dates Column. i intend to set the dates column as an index and to concat on the basis of the dates with another dataframe. Can you let me know how i should go about doing this
19
●2 ●1 ●4
Datastream Point in Time Data Manipulation
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
79.2k
●251 ●52 ●74
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:
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')
df
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'])
19
●2 ●1 ●4
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
19
●2 ●1 ●4
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.
