A pandas dataframe is required for passing data to outgoing connections in Alteryx

[wonka1234]

Hi,

Is there a limitation to the dataframe size using Alteryx.write(df,1) ? 

I cant seem to write my dataframe to an anchor.

my code uses zipfile and read excel to get data.. and for some reason it is not reading in as a dataframe.. but it clearly is when i run it locally.

Is there anyway to convert it again to ensure i have it as a dataframe in alteryx?

[wonka1234]

@apathetichell 

Getting an error on your suggestion:

---------------------------------------------------------------------------
TypeError                                 Traceback (most recent call last)
<ipython-input-2-8d4e89bed36f> in <module>
     10 
     11 
---> 12 df = pd.concat(pd.DataFrame(pd.read_excel(xlfile, header = 1, sheet_name=None), ignore_index=True))
     13 
     14 print(df)

TypeError: __init__() got an unexpected keyword argument 'ignore_index'

[apathetichell]

o.k. - try playing around with the syntax key is to define df as a dataframe using the pd.DataFrame function...

[jaspartap_singh]

Hi, How can one pass a json object generated using a Python code to the outgoing connection