Pandas Version: 1.1.5
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
1
●1 ●2 ●2
Why do I get Pandas ValueError: invalid literal for int() with base 10: 'undefined' when I try to load a downloaded excel file from GOVSRCH into Python via read_excel?
12.8k
●27 ●5 ●10
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
16k
●72 ●39 ●63
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.
