Downloading financial statement data using the Eikon API get_data sometimes delivers numbers formatted in scientific notation like 5.4e-14. I down load several large files with several thousand RIC Codes and a variety financial statement data. I then upload the data to SQL Server. SQL Server fails to accept the scientific notation data but has no problem with the traditional number data.
Is there away to get the Eikon API to only deliver data in a traditional number format rather than using scientific notation? Or is there away to convert the scientific notation delivered in the panda dataframe for all the columns to get the data in a traditional number format?
Thanks, appreciate any help!!
I think you can set number format on the dataframe.
I have not verified this but this kind of article would help, https://kiwidamien.github.io/stylish-pandas.html
Please also be reminded that the data retrieved with Eikon Data API cannot leave the desktop, such as uploading them to other SQL Server.