For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
CT1309 avatar image
20 ●0 ●2 ●2

How to rename the column header in the data frame?

Hi, in using eikon.get_data() to extract SmartEstimate data into python dataframes, I get "Earnings Per Share - SmartEstimate®" but cannot rename the header given the "®". How do I rename the column header in this case?

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonpandas
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

2 Answers

Upvotes
Accepted
Zhenya Kovalyov avatar image
4.6k ●26 ●7 ●22

This should work

df = df.rename(columns={'Instrument': 'Test', 'Earnings Per Share - SmartEstimate®': 'Test2'})

screen-shot-2017-09-26-at-105329.png


screen-shot-2017-09-26-at-105329.png (125.0 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
CT1309 avatar image
20 ●0 ●2 ●2

thanks. somehow, it now works when it didn't earlier.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea