Home › Forums › PyKX › PyKX for your CTO › Re: PyKX for your CTO
-
Nice blog !!
I have one suggestion:
Instead of copying the weather table into the kdb memory space, you can pass the weather PyKX object to kx.q.sql like so:
>>> weather = kx.q.read.csv('./abr_meteo23.csv', types='IIII****' + 'FS'*24, delimiter=';', as_table=True) >>> ## kx.q['weather'] = weather
>>> kx.q.sql('select STATION, count(distinct(MAGNITUDE)) from $1 group by STATION', weather)