Python / Eikon data output

[JuhaP]

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

[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 

[PhilippK]

you are welcome!

Check out those posts:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-output-python-result-into-workf...

https://community.alteryx.com/t5/Data-Science/Code-Friendly-Data-Structures-DataFrames-in-Python-Pan...

I wish you a great weekend

Phil

[JuhaP]

Hi @PhilippK ,

Thanks for the links you sent. Interesting reading.

Can you check my attachment?

I'm still struggling with output. In the attachment all looks perfect at Out[171]. After resetting the Index, as suggested in few forums, error message is now 

[CachedData.write] couldn't find conversion for Instrument ("string") from pandas to yxdb

Any suggestions I should try next?

Cheers,

Juha

[PhilippK · Accepted solution]

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-...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Python-Tool-Won-t-Output-JSON-Interfac...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Question-amp-Problem-gt-Python-Tool-Ca...

Let me know whether something works for you.

Best regards

Phil

[JuhaP · Accepted solution]

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