dates coming out as wrong number

LRE42
LRE42
in Refinitiv Data Platform Libraries

I have two problems:

1. sometimes when I run the below code chunk, I get an empty data frame, and sometimes I do not.

2. when I don't get an empty data frame, the dates are reported erroneously, as in not in a proper date-time format. (note that I am trying to get the data into a csv file with dates in a specific format)

Here is my code and a screenshot of the output showing the erroenous date-time format.

import refinitiv.data as rd
rd.open_session()
syntax = "SCREEN(U(IN(Equity(active,public,primary))), IN(TR.TRBCIndustryCode,54102030,54101010,54101020),CURN=USD)"
TSfields = ["TR.F.PeriodEndDate(IncludeSpl=Yes)","TR.F.TotAssets(IncludeSpl=Yes)"]
df2 = rd.get_data(
    universe = syntax,
    fields = TSfields,
    parameters = {'Scale': 0,  'SDate': "1989-01-01",'EDate': "2022-06-05", 'FRQ': 'FY', 'Curn': 'USD'},
    )

df2.rename(columns = {'Instrument':'#'},
            inplace = True)
df2.loc[-1] = df2.columns.to_list()
df2 = df2.sort_index().reset_index(drop=True)
df2.columns = ["ticker","PEDate","assets"]
print(df2)
df2.to_csv("tob_shutoff_TSraw.csv", date_format='%Y-%m-%d', index=False)
print(df2['PEDate'])



screenshot 1.png

Tagged:

Best Answer

  • nick.zincone
    nick.zincone
    Answer ✓

    Hi @LRE42

    Can you confirm the version of the refinitiv.data library you are using?

    I was able to replicate using the latest version (1.0.0b13).

    Can you try downgrading to version (refinitiv-data==1.0.0b9)? I had better success with this version. In the meantime, I will report the behavior to the development team.

    thanks.

Answers

  • LRE42
    LRE42

    Hi Nick -- Thanks. i am using 1.0.0b13. I have used the eikon package instead (with just a few text edits), and it is working for me now as expected. But I'm glad to know the development team will get the error message and hopefully improve the functionality.

Categories