Why do I get Pandas ValueError: invalid literal for int() with base 10: 'undefined' when I try to lo

smeetdev.vora

Pandas Version: 1.1.5

raksina.samasiri

hi @smeetdev.vora

This error is not related to Eikon Data API, it's related to how Pandas library handle the input Excel file.

However, I spotted that the error is because the excel file contains the string '--' in column Coupon and when Pandas's read_excel function is executed, it's failed to convert the string into int hence the error is thrown.

According to this question on Stackoverflow, one of the ways to fix this is to convert the file from xlsx to csv, then use read_csv instead of read_excel to read the data

Hope this could help

nick.zincone

Hi @smeetdev.vora

An alternative way to pull down the contracts is to utilize the Search APIs directly as opposed to manually creating and exporting a spreadsheet and importing it into your application.

If this is of interest, you can review the source code for this debt structure analysis article and also look at a series of examples of how to use search.