We have recently published a post on PyKX, introducing the library from a C-level perspective. This will be followed by a more conventional, technical post, but for now we enjoyed writing this short technology tale!
https://www.habla.dev/blog/2023/07/31/all-roads-lead-to-pykx.html
Comments are welcome!
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)
Sure, thanks! It’s been already corrected.