powerpeanuts
New Contributor III
since ‎2021.11.15
2 weeks ago

User Statistics

  • 20 Posts
  • 0 Solutions
  • 12 Kudos given
  • 8 Kudos received

User Activity

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...
hi, how can I swap key and list of values using q? Thanks! python version: https://stackoverflow.com/questions/51740270/python-dictionary-swap-keyvalue-pair-when-values-exist-in-mutiple-keys for example: 1 2 3!(4 5 3;6 7 3;4 1) becomes 1 3 4 5 6 7!(e...