KX Community

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

hi, is there a function to compute rolling linear regression (multiple independent variables) for a q table? I am looking for something like https://www.statsmodels.org/dev/generated/statsmodels.regression.rolling.RollingOLS.html in python. Thanks. p...

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

select with combinational conditions

select with assignment

xbar millisecond

Unpack nested column in table

rolling linear regression in 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