KX Community

powerpeanuts

Hi, I have a simple question: I have a list b:(1 5 6;9 10 76; 43 12 11) and I would like to take the nth indexed element from each list where n is a list, for example n = (0;2;1). So the output should be (1;76;12). What is the easiest syntax to do it...

powerpeanuts

Hi, is there a way to make select statements with multiple conditions in combinations? For example, for the table below: q)flip `date`data!(2023.05.20 2023.05.20 2023.05.20 2023.05.19 2023.05.19 2023.05.19;`a`c`b`b`b`c) date data --------------- 2023...

powerpeanuts

I remember in q, we can assign a temporary variable during select and use it again in the same column, but seems it is not working. For example, select (total+5)%(total:a+b) from t this should be same as select (a+b+5)%(a+b) from t What is wrong with...

powerpeanuts

Hi, in the select statement, we can easily do 5 xbar time.minute to group the data for every 5 minutes, what is the equivalent for doing like every 5 millisecond?

powerpeanuts

hi, how can we unpack nested column in a table? Thanks. e.g. t:flip `a`b!((1 2 3);((4 5 6);(6 12 23);)(12 36 14))) to t: flip `a`b1`b2`b3!((1 2 3);(4 6 12);(5 12 36);(6 23 14))

powerpeanuts

I have similar issue as well, already set QLIC pointing to license folder, but get license error: upd, not sure if same root cause as yours.

powerpeanuts

Thanks @rocuinneagain. I was trying the functional select and have to convert the strings to first (I am using python 3), i.e. q("{?[y;();0b;{x!x}(),x]}", np.bytes_("iq"), np.bytes_("t"))

powerpeanuts

Perfect, thanks!

powerpeanuts

perfect, exactly what I am looking for. Thanks David.

powerpeanuts

Thanks. I'm on linux and Ctrl + U works 

KX Community

User Statistics

User Activity

Apply a list of parameters to a list of input

select with combinational conditions

select with assignment

xbar millisecond

Unpack nested column in table

Re: LicenseException: A valid q license must be in a known location (e.g. `$QLIC`) to run q code via 'pykx.q'.

Re: qpython to select columns from table

Re: Assigning QDictionary in qpython to kdb

Re: select avg (ignore null)

Re: how to clear the current line