Pandas Version: 1.1.5
Upgrade from Eikon -> Workspace. Learn about programming differences.
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?
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.
Thanks,
AHS
Hi,
Please be informed that a reply has been verified as correct in answering the question, and marked as such.
Thanks,
AHS
14.2k
●30 ●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
17.1k
●80 ●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.
