kdb+ and q

kdb+ and q

Q+A on all things kdb+ database and the q language

Forum Posts

Sorted by:

Start a conversation

How can I get rankings like pandas?

Hi,I want to rank a list of numbers: 1 2 3 4 5 3 3 3In kdb+/q, by using rank function, the result is 0 1 2 6 7 3 4 5. The duplicates do not get the same ranking results.Ideally, I want to have: 0 1 3.5 6 7 3.5 3.5 3.5Any help would be greatly appreci...

How could q read Unicode csv file correctly?

Hello all. I use the code below to read a csv file which contains Chinese characters, but the output is not shown correctly.CstInfo"sdsssbs"; 1# ",")0:`CustomerInfo1.csvThe content of csv file is:CstID,CstACDate,CstName,CstProp,CstCatag,IsFinanceInv,...

Merge two tables

Hello all, I may be having a brain freeze right now, but wondering if someone can help. I have two tables and I want to merge them by sym.First table (flip (enlist `sym)!(enlist `A`B`C))symABCSecond table (flip (enlist `minute)!(enlist {[st;en;i] st+...

splitting the difference

it's probably obvious to the more astute, but i didn't know what would happen at the end of a bargaining process starting at a bid of 1, ask of 2, bid of 1.5... splitting the difference each time {last[x],avg x}\[1 2]

Bloomberg.c question

Hi, K u = knk(3, ks(ss((S)blpapi_Message_typeString(m))), ki(c.value.intValue), sequence_to_dictionary(e)); K ret = k(0, "Update", u, (K)0);My understanding, the above code has bloomberg event data into k structure u and call update of q function.The...

Top Kudoed Authors

User

Count

6

5

5

4

2

Main Office Contacts

Useful Information

Resources

Popular Links

Follow Us

youtube

instagram

KX. All Rights Reserved.

KX and kdb+ are registered trademarks of KX Systems, Inc., a subsidiary of FD Technologies plc.

Export Statement

Processing Notice