New Contributor III
since ‎2021.11.15

User Statistics

  • 21 Posts
  • 0 Solutions
  • 15 Kudos given
  • 8 Kudos received

User Activity

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...
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...
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?
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))
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...