• PyKX

  PyKX for your CTO

  Posted by jserrano on July 31, 2023 at 12:00 am

  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!

  jserrano replied 1 year, 1 month ago 2 Members · 2 Replies
• 2 Replies

• 

  iodwyer

  Member

  July 31, 2023 at 12:00 am

  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)

• 

  jserrano

  Member

  August 1, 2023 at 12:00 am

  Sure, thanks! It’s been already corrected.

Log In to Reply