Python / Eikon data output

Hi all,

Hope you all are well.

I'm having little problem with python output. I'm using AYX to get data from Eikon API. In this case I need to get Lipper and RIC code to replace ISIN code if those exist.

All looks good until output. Not being a Python wizard, I'm pretty much out of options now.

See attachment for a error message.

Any help would be great.

BR, Juha

python_eikon1.png

Python

Accepted answers

PhilippK

Hello @JuhaP ,

unfortunately, I am not a Python expert, but I found something similar here:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Problem-with-datetime-conversion-from-pandas-to-Alteryx/td-p/547353

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Python-Tool-Won-t-Output-JSON-Interface-Error/td-p/519068

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Question-amp-Problem-gt-Python-Tool-Cannot-write-Output-data/td-p/303019

Let me know whether something works for you.

Best regards

Phil

JuhaP

Hi @PhilippK ,

I found a solution in one of links you sent

Solution is

prices = pd.DataFrame(df)
prices.reset_index(inplace=False)
prices = prices.applymap(str)

Cheers,

Juha

All comments

PhilippK

Can you check whether "codes" is a proper data frame? This is needed to output it back to the Alteryx workflow:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Python/ta-p/197860

JuhaP

Hi,

Thanks for your reply @PhilippK

My output seems to be

<class 'pandas.core.frame.DataFrame'>

Just need to figure out how to convert to pd.DataFrame. Any tips?

Cheers,

Juha

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703