2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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 

PhilippK
Alteryx Alumni (Retired)
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

PhilippK
Alteryx Alumni (Retired)
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