Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
Good evening,
I'm trying different Eikon API functions for downloading the Reuters screen "NARODOWY" as dataframe. Also considering words as "ROWS80_7" I have no results...
If anybody can help me i'll be very grateful.
My intention is to obtain a dataframe in my python code with the table attached.
You can use the following code to get the ROW80_nn fields.
df, err = ek.get_data('NBPFIXA',
['ROW80_1','ROW80_2','ROW80_3','ROW80_4','ROW80_5',
'ROW80_6','ROW80_7','ROW80_8','ROW80_9','ROW80_10',
'ROW80_11','ROW80_12','ROW80_13','ROW80_14','ROW80_15',
'ROW80_16','ROW80_17','ROW80_18','ROW80_19','ROW80_20',
'ROW80_21','ROW80_22','ROW80_23','ROW80_24','ROW80_25'])
df.T
The output is:
Hi @Nabil Edriss Sanchez1, Here is how you can get the ANSI page into dataframe. This is exactly that @Jirapongse has posted, but further splitting the rates data into a table.
idx = [1, 7, 16, 22, 31, 37, 46, 52, 61, 67, 76]
flds = ['ROW80_{}'.format(x) for x in range(7, 15)]
df, err = ek.get_data('NBPFIXA', fields=flds)
dfRes = pd.DataFrame()
for fld in flds:
sStr = [df[fld][0][pre:cur].strip() for pre,cur in zip(idx, idx[1:])]
dfRes = dfRes.append(pd.Series(sStr), ignore_index=True)
dfRes
