Hi, i want to run in a dateframe calculations which include the RIC "EUR=". This causes an error...

w.jorissen · June 2019

Hi, i want to run in a dateframe calculations which include the RIC "EUR=". This causes an error where = is part of the python language. How can I work around this? Below my example df['COALEUR']=df.TRAPI2YZ0/(df.EUR=)

Alex Putkov.1 · June 2019

Selection using attribute operator in a pandas dataframe may be convenient in some cases, but it's not universally applicable as attribute operator has shortcomings like the one you encountered: it cannot be used when column label contains special characters such as a white space or an equals sign. Use index operator rather than attribute operator:

df['COALEUR'] = df['TRAPI2YZ0'] / df['EUR=']

Or if you prefer rename the column, then use attribute operator.

df.rename(columns={'EUR=': 'EUR'}, inplace=True)
df['COALEUR'] = df.TRAPI2YZ0 / df.EUR

nick.zincone · June 2019

Hi @w.jorissen,

The Eikon Data API uses the publicly available pandas.dataframe quite heavily and if you need to start manipulating or performing calculations I would suggest you refer to the documentation as a general guide.

You have not provided enough information to understand what you are attempting to calculate, but the way you want to access data from the data frame is invalid. For example, if you request for values related to the 'EUR=', you can't simply say: df.EUR=. You have to use a different syntax to get specific values from the dataframe, for example df.loc[0] for example.

w.jorissen · June 2019

https://community.developers.refinitiv.com/discussion/comment/44906#Comment_44906

Thanks Alex, this solved the issue.

Hi, i want to run in a dateframe calculations which include the RIC "EUR=". This causes an error...

Best Answer

Answers

Categories

EXPLORE OUR SITES

Hi, i want to run in a dateframe calculations which include the RIC "EUR=". This causes an error...

Best Answer

Answers

Categories