Infrastructure 360 (GINFR) through Python API

I'm looking for a way to access the data available in LSEG Workspace under "Infrastructure 360" (GINFR) through the Python API. They don't appear in the DEALS_MERGERS_AND_ACQUISITIONS and LOAN_INSTRUMENTS views, which is reasonable. However, I haven't been able to find any record of them by just searching for the (supposed) PermID/DealID either. How can I get a pull of all projects in the dataset straight into Python to then perform further analyses on?

Find more posts tagged with

python api

workspace-data-api

#content

Accepted answers

Dhruv Singal

I came up with the following, which matches the number of obervations the Screener returns. It's (significantly) less than in GINFR, though there seemingly are duplicated in the latter. pjf_fields is a list of the fields related to project finance (TR.PJF) I found in the CodeCreator.

pjf_data = []

for year in trange(1990,2024):
    df,err = ek.get_data("SCREEN(U(IN(DEALS)/*UNV:DEALSPROJECTFINANCE*/), IN(TR.PJFProjectUniverseType,""SDCPJF""), BETWEEN(TR.PJFFinancedDate," + str(year) + "0101," + str(year) + "1231)/*dt:Date*/)",
                         pjf_fields)
    pjf_data.append(df)

pjf_data = pd.concat(pjf_data,ignore_index=True)

All comments

jason.ramchandani01

@eikon29 So I don't believe this content set is available via API search views. The only way I think you can get this data in Workspace is by pulling it via the excel button. I have asked the content team to confirm and I will report back here. Please bear with me.

Dhruv Singal

pjf_data = []

for year in trange(1990,2024):
    df,err = ek.get_data("SCREEN(U(IN(DEALS)/*UNV:DEALSPROJECTFINANCE*/), IN(TR.PJFProjectUniverseType,""SDCPJF""), BETWEEN(TR.PJFFinancedDate," + str(year) + "0101," + str(year) + "1231)/*dt:Date*/)",
                         pjf_fields)
    pjf_data.append(df)

pjf_data = pd.concat(pjf_data,ignore_index=True)

EXPLORE OUR SITES