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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
aryer avatar image
21 ●2 ●1 ●5

How to backfill missing data?

Hello,

There are always some missing data point for any inquiry and I understand that. For example:

ek.get_data('015351109', ['TR.PE'], {'SDate':'20180830'})

got nothing even 015351109 is a company on S&P 500 list.

My question is, is there a parameter in the ek.get_data function that can return the nearest available data if the data on '20180830' is not available? For example,

ek.get_data('015351109', ['TR.PE'], {'SDate':'20180730'}) has a value and I want to get that value return if my inquiry for data on '20180830' got nothing.


Thanks!


eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
error.png (11.9 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.

3 Answers

Upvotes
Accepted
chavalit-jintamalit avatar image
18k ●21 ●12 ●20

Hi @aryer

There are 2 topics:

1. Why the data between 2018-07-26 to 2018-10-25 is not available

For content question, please contact Refinitiv Content Helpdesk, specifying Eikon as product, so Eikon content experts can help identify the required content.

2. If you would like to remove NaN rows in dataframe

You can use this code:


ahs02.png (27.7 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
chavalit-jintamalit avatar image
18k ●21 ●12 ●20

Hi @aryer

I think you can request data in range to cover the date which you want and look for the next available data point if that data point is missing.

This is an example:


ahs3.png (38.6 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.

aryer avatar image aryer

got the result for '015351109' from 2018-01-01,EDate=2019-01-31 using the following function:

df,e = ek.get_data('015351109',['TR.PE(SDate = 2018-01-01,EDate=2019-01-31,Frq=D).Date','TR.PE(SDate = 2018-01-01,EDate=2019-01-31,Frq=D)'])

Please check attached for results. And you can see that the data jumped from 2018-07-26 to 2018-10-25, from 50.45 to 105.59, without any data points in between.

Could you let me know why this happened? Any methods to fix it?

Thank you!temp.txtresult.jpg

temp.txt (12.3 KiB)
result.jpg (134.5 KiB)
Upvotes
aryer avatar image
21 ●2 ●1 ●5

result.jpgI got the result for '015351109' from 2018-01-01,EDate=2019-01-31 using the following function:

df,e = ek.get_data('015351109',['TR.PE(SDate = 2018-01-01,EDate=2019-01-31,Frq=D).Date','TR.PE(SDate = 2018-01-01,EDate=2019-01-31,Frq=D)'])

Please check attached for results. And you can see that the data jumped from 2018-07-26 to 2018-10-25, from 50.45 to 105.59, without any data points in between.

Could you let me know why this happened? Any methods to fix it?

Thank you!


result.jpg (134.5 KiB)
temp.txt (12.3 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.

Click below to post an Idea Post Idea