Null float to KDB+ converts to empty string about qpython HOT 3 OPEN

Does anyone know why sending
q.sync('foo', numpy.string_('test_trade'),[numpy.string_('PYTHON'),numpy.fromstring(_QNAN64)]) would send KDB a value of ,0n

from qpython.

Hi @dberrios2000

it looks like there is a bug connected with Pandas integration. When serializing generic lists, NaN values are converted to single space.

Before the patch is available and pulled by the maintainer, please use this workaround:

from qpython.qtype import qnull, QDOUBLE
from qpython import qconnection
from qpython.qwriter import QWriter

with qconnection.QConnection(host = 'localhost', port = 5000, writer_class = QWriter) as q:
  q.sync('foo', 'table', ['PYTHON', qnull(QDOUBLE)])

This enforces qpython to use default, non-pandas serializer, even if the pandas package is installed.

Best regards
Maciej

from qpython.

This worked.. thank you for your help.

from qpython.