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

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=)

Find more posts tagged with

python

eikon

rics

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Alex Putkov.1

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

All comments

Alex Putkov.1

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

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

Thanks Alex, this solved the issue.

EXPLORE OUR SITES