Why are there certain companies wherein Contact Email Address is not aligned in Python. Sample companies are OILI.NS’ , ‘ASPN.NS. Data is aligned in both excel and product.
Code used : import refinitiv.data as rd
rd.open_session()
df = rd.get_data(
universe = ['OILI.NS'],
fields = [
'TR.FirmInvestorId(SDate=2025-08-31)',
'TR.InvestorFullName(SDate=2025-08-31)',
'TR.InvContFirstName(SDate=2025-08-31)',
'TR.InvContFullName(SDate=2025-08-31)',
'TR.InvestorContactTitle(SDate=2025-08-31)',
'TR.InvContactEmailAddr(SDate=2025-08-31)'
]
)
display(df.head(50))
df.to_excel("Sample_title_and_email_mismatch1.xlsx", index=False)