maciejlach
commented
9 years ago If you want to convert and assign Python object to name in q, you can use builtin set function:
df = q('flip `name`iq`fullname!(`Dent`Beeblebrox`Prefect;98 42 126;("Arthur Dent"; "Zaphod Beeblebrox"; "Ford Prefect"))')
print df
print df.meta
print q('type', df)
q('set', numpy.string_('dataframe_set'), df)
print q('dataframe_set')Alternatively, you can define your own function in q which assigns parameter to a global name or use anonymous function, e.g.:
q('{[x;y] x set y}', numpy.string_('dataframe_fun'), df)
print q('dataframe_fun')Note, that set function expects name to be a q symbol, thus the parameter in Python call is represented as numpy.string_.
JebadiahJohnson
mrecht
Quick question: how do I insert data and convert from something like a pandas dataframe?
I can do the following:
q('(myHeader:5#myBars)') df = q('(myHeader)') print df print df.meta print q('type', df)
but then if I want to insert the data just returned I run into problems. I am probably not doing this correctly.
q.query(qconnection.MessageType.SYNC, 'myHeader2:', df)
I've tried other ways to insert a pandas dataframe as well. No luck. Any help is greatly appreciated.
Jebadiah