Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Python / Eikon data output

JuhaP
7 - Meteor

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

 

 

6 REPLIES 6
PhilippK
Alteryx Alumni (Retired)

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

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 

JuhaP
7 - Meteor

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

JuhaP
7 - Meteor

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

Labels