Reference Manual

(This section is generated from the PyQ source code. You can access most of this material using pydoc or the built-in help method.)

K
q

class K

K.abs()

absolute value function

For details, see q.abs and abs on code.kx.com.

K.acos()

arc cosine function

For details, see q.acos and acos on code.kx.com.

K.aj()

asof join function

For details, see q.aj and aj on code.kx.com.

K.aj0()

asof join function

For details, see q.aj0 and aj on code.kx.com.

K.all()

all function

For details, see q.all and all on code.kx.com.

K.and_()

and verb

For details, see q.and_ and and on code.kx.com.

K.any()

any function

For details, see q.any and any on code.kx.com.

K.asc()

ascending function

For details, see q.asc and asc on code.kx.com.

K.asin()

arc sine function

For details, see q.asin and asin on code.kx.com.

K.asof()

asof verb

For details, see q.asof and asof on code.kx.com.

K.atan()

arc tangent function

For details, see q.atan and atan on code.kx.com.

K.attr()

attributes function

For details, see q.attr and attr on code.kx.com.

K.avg()

average function

For details, see q.avg and avg on code.kx.com.

K.avgs()

running averages function

For details, see q.avgs and avgs on code.kx.com.

K.bin()

binary search verb

For details, see q.bin and bin on code.kx.com.

K.binr()

binary search verb

For details, see q.binr and bin on code.kx.com.

K.ceiling()

ceiling function

For details, see q.ceiling and ceiling on code.kx.com.

K.cols()

columns function

For details, see q.cols and cols on code.kx.com.

K.cor()

correlation verb

For details, see q.cor and cor on code.kx.com.

K.cos()

cosine function

For details, see q.cos and cos on code.kx.com.

K.count()

count function

For details, see q.count and count on code.kx.com.

K.cov()

covariance verb

For details, see q.cov and cov on code.kx.com.

K.cross()

cross product verb

For details, see q.cross and cross on code.kx.com.

K.csv()

csv global

For details, see q.csv and csv on code.kx.com.

K.cut()

cut verb

For details, see q.cut and cut on code.kx.com.

K.deltas()

deltas function

For details, see q.deltas and deltas on code.kx.com.

K.desc()

descending sort function

For details, see q.desc and desc on code.kx.com.

K.dev()

standard deviation function

For details, see q.dev and dev on code.kx.com.

K.differ()

differ function

For details, see q.differ and differ on code.kx.com.

K.distinct()

distinct function

For details, see q.distinct and distinct on code.kx.com.

K.div()

integer division verb

For details, see q.div and div on code.kx.com.

K.dsave()

dsave function

For details, see q.dsave and dsave on code.kx.com.

K.each()

each adverb

For details, see q.each and each on code.kx.com.

K.ej()

equijoin verb

For details, see q.ej and ej on code.kx.com.

K.ema()

exponentially weighted moving average verb

For details, see q.ema and ema on code.kx.com.

K.ema()

exponentially weighted moving average verb

For details, see q.ema and ema on code.kx.com.

K.enlist()

enlist function

For details, see q.enlist and enlist on code.kx.com.

K.eval()

eval function

For details, see q.eval and eval on code.kx.com.

K.except_()

except verb

For details, see q.except_ and except on code.kx.com.

K.exp()

exp function

For details, see q.exp and exp on code.kx.com.

K.fby()

filter-by

For details, see q.fby and fby on code.kx.com.

K.fills()

fills function

For details, see q.fills and fills on code.kx.com.

K.first()

first function

For details, see q.first and first on code.kx.com.

K.fkeys()

fkeys function

For details, see q.fkeys and fkeys on code.kx.com.

K.flip()

flip function

For details, see q.flip and flip on code.kx.com.

K.floor()

floor function

For details, see q.floor and floor on code.kx.com.

K.get()

get function

For details, see q.get and get on code.kx.com.

K.getenv()

getenv function

For details, see q.getenv and getenv on code.kx.com.

K.group()

group function

For details, see q.group and group on code.kx.com.

K.gtime()

gtime function

For details, see q.gtime and gtime on code.kx.com.

K.hclose()

hclose function

For details, see q.hclose and hclose on code.kx.com.

K.hcount()

hcount function

For details, see q.hcount and hcount on code.kx.com.

K.hdel()

hdel function

For details, see q.hdel and hdel on code.kx.com.

K.hopen()

hopen function

For details, see q.hopen and hopen on code.kx.com.

K.hsym()

hsym function

For details, see q.hsym and hsym on code.kx.com.

K.iasc()

ascending function

For details, see q.iasc and iasc on code.kx.com.

K.idesc()

descending function

For details, see q.idesc and idesc on code.kx.com.

K.ij()

inner join verb

For details, see q.ij and ij on code.kx.com.

K.ijf()

The ijf function.

For details, see q.ijf and ijf on code.kx.com.

K.in_()

membership verb

For details, see q.in_ and in on code.kx.com.

K.insert()

insert verb

For details, see q.insert and insert on code.kx.com.

K.inter()

intersect verb

For details, see q.inter and inter on code.kx.com.

K.inv()

inverse function

For details, see q.inv and inv on code.kx.com.

K.key()

key function

For details, see q.key and key on code.kx.com.

K.keys()

keys function

For details, see q.keys and keys on code.kx.com.

K.last()

last function

For details, see q.last and last on code.kx.com.

K.like()

pattern matching verb

For details, see q.like and like on code.kx.com.

K.lj()

left join verb

For details, see q.lj and lj on code.kx.com.

K.ljf()

The ljf function.

For details, see q.ljf and ljf on code.kx.com.

K.load()

load function

For details, see q.load and load on code.kx.com.

K.log()

log function

For details, see q.log and log on code.kx.com.

K.lower()

lowercase function

For details, see q.lower and lower on code.kx.com.

K.lsq()

least squares verb

For details, see q.lsq and lsq on code.kx.com.

K.ltime()

ltime function

For details, see q.ltime and ltime on code.kx.com.

K.ltrim()

left trim function

For details, see q.ltrim and ltrim on code.kx.com.

K.mavg()

moving average verb

For details, see q.mavg and mavg on code.kx.com.

K.max()

maximum function

For details, see q.max and max on code.kx.com.

K.maxs()

maximums function

For details, see q.maxs and maxs on code.kx.com.

K.mcount()

moving count verb

For details, see q.mcount and mcount on code.kx.com.

K.md5()

md5 function

For details, see q.md5 and md5 on code.kx.com.

K.mdev()

moving deviation verb

For details, see q.mdev and mdev on code.kx.com.

K.med()

median function

For details, see q.med and med on code.kx.com.

K.meta()

meta data function

For details, see q.meta and meta on code.kx.com.

K.min()

minimum function

For details, see q.min and min on code.kx.com.

K.mins()

minimums function

For details, see q.mins and mins on code.kx.com.

K.mmax()

moving maximum verb

For details, see q.mmax and mmax on code.kx.com.

K.mmin()

moving minimum verb

For details, see q.mmin and mmin on code.kx.com.

K.mmu()

matrix multiplication verb

For details, see q.mmu and mmu on code.kx.com.

K.mod()

modulus verb

For details, see q.mod and mod on code.kx.com.

K.msum()

moving sum verb

For details, see q.msum and msum on code.kx.com.

K.neg()

negative function

For details, see q.neg and neg on code.kx.com.

K.next()

next function

For details, see q.next and next on code.kx.com.

K.not_()

logical not function

For details, see q.not_ and not on code.kx.com.

K.null()

null function

For details, see q.null and null on code.kx.com.

K.or_()

or verb

For details, see q.or_ and or on code.kx.com.

K.over()

over adverb

For details, see q.over and over on code.kx.com.

K.parse()

parse function

For details, see q.parse and parse on code.kx.com.

K.peach()

parallel each adverb

For details, see q.peach and peach on code.kx.com.

K.pj()

plus join verb

For details, see q.pj and pj on code.kx.com.

K.prd()

product function

For details, see q.prd and prd on code.kx.com.

K.prds()

cumulative product function

For details, see q.prds and prds on code.kx.com.

K.prev()

prev function

For details, see q.prev and prev on code.kx.com.

K.prior()

prior function

For details, see q.prior and prior on code.kx.com.

K.rand()

random function

For details, see q.rand and rand on code.kx.com.

K.rank()

rank function

For details, see q.rank and rank on code.kx.com.

K.ratios()

ratios function

For details, see q.ratios and ratios on code.kx.com.

K.raze()

raze function

For details, see q.raze and raze on code.kx.com.

K.read0()

file read function

For details, see q.read0 and read0 on code.kx.com.

K.read1()

file read function

For details, see q.read1 and read1 on code.kx.com.

K.reciprocal()

reciprocal function

For details, see q.reciprocal and reciprocal on code.kx.com.

K.reval()

reval function

For details, see q.reval and reval on code.kx.com.

K.reval()

reval function

For details, see q.reval and reval on code.kx.com.

K.reverse()

reverse function

For details, see q.reverse and reverse on code.kx.com.

K.rload()

rload function

For details, see q.rload and rload on code.kx.com.

K.rotate()

rotate verb

For details, see q.rotate and rotate on code.kx.com.

K.rsave()

rsave function

For details, see q.rsave and rsave on code.kx.com.

K.rtrim()

right trim function

For details, see q.rtrim and rtrim on code.kx.com.

K.save()

save function

For details, see q.save and save on code.kx.com.

K.scan()

scan adverb

For details, see q.scan and scan on code.kx.com.

K.scov()

statistical covariance verb

For details, see q.scov and scov on code.kx.com.

K.scov()

statistical covariance verb

For details, see q.scov and scov on code.kx.com.

K.sdev()

statistical standard deviation function

For details, see q.sdev and sdev on code.kx.com.

K.sdev()

statistical standard deviation function

For details, see q.sdev and sdev on code.kx.com.

K.set()

set verb

For details, see q.set and set on code.kx.com.

K.setenv()

setenv verb

For details, see q.setenv and setenv on code.kx.com.

K.show()

show function

For details, see q.show and show on code.kx.com.

K.signum()

signum function

For details, see q.signum and signum on code.kx.com.

K.sin()

sine function

For details, see q.sin and sin on code.kx.com.

K.sqrt()

square root function

For details, see q.sqrt and sqrt on code.kx.com.

K.ss()

string search function

For details, see q.ss and ss on code.kx.com.

K.ssr()

string search replace function

For details, see q.ssr and ssr on code.kx.com.

K.string()

string function

For details, see q.string and string on code.kx.com.

K.sublist()

sublist verb

For details, see q.sublist and sublist on code.kx.com.

K.sum()

sum function

For details, see q.sum and sum on code.kx.com.

K.sums()

cumulative sum function

For details, see q.sums and sums on code.kx.com.

K.sv()

scalar from vector verb

For details, see q.sv and sv on code.kx.com.

K.svar()

statistical variance function

For details, see q.svar and svar on code.kx.com.

K.svar()

statistical variance function

For details, see q.svar and svar on code.kx.com.

K.system()

system command function

For details, see q.system and system on code.kx.com.

K.tables()

tables function

For details, see q.tables and tables on code.kx.com.

K.tan()

tangent function

For details, see q.tan and tan on code.kx.com.

K.til()

til function

For details, see q.til and til on code.kx.com.

K.trim()

trim function

For details, see q.trim and trim on code.kx.com.

K.type()

type function

For details, see q.type and type on code.kx.com.

K.uj()

union join verb

For details, see q.uj and uj on code.kx.com.

K.ungroup()

ungroup function

For details, see q.ungroup and ungroup on code.kx.com.

K.union()

union verb

For details, see q.union and union on code.kx.com.

K.upper()

uppercase function

For details, see q.upper and upper on code.kx.com.

K.upsert()

upsert verb

For details, see q.upsert and upsert on code.kx.com.

K.value()

value function

For details, see q.value and value on code.kx.com.

K.var()

variance function

For details, see q.var and var on code.kx.com.

K.view()

view function

For details, see q.view and view on code.kx.com.

K.views()

views function

For details, see q.views and views on code.kx.com.

K.vs()

vector from scalar verb

For details, see q.vs and vs on code.kx.com.

K.wavg()

weighted average verb

For details, see q.wavg and wavg on code.kx.com.

K.where()

where function

For details, see q.where and where on code.kx.com.

K.within()

within verb

For details, see q.within and within on code.kx.com.

K.wj()

window join function

For details, see q.wj and wj on code.kx.com.

K.wj1()

The wj1 function.

For details, see q.wj1 and wj1 on code.kx.com.

K.wsum()

weighted sum verb

For details, see q.wsum and wsum on code.kx.com.

K.ww()

The ww function.

For details, see q.ww and ww on code.kx.com.

K.xasc()

ascending sort verb

For details, see q.xasc and xasc on code.kx.com.

K.xbar()

interval bar verb

For details, see q.xbar and xbar on code.kx.com.

K.xcol()

rename columns verb

For details, see q.xcol and xcol on code.kx.com.

K.xcols()

reorder columns verb

For details, see q.xcols and xcols on code.kx.com.

K.xdesc()

descending sort verb

For details, see q.xdesc and xdesc on code.kx.com.

K.xexp()

power verb

For details, see q.xexp and xexp on code.kx.com.

K.xgroup()

grouping verb

For details, see q.xgroup and xgroup on code.kx.com.

K.xkey()

set primary key verb

For details, see q.xkey and xkey on code.kx.com.

K.xlog()

base-x log verb

For details, see q.xlog and xlog on code.kx.com.

K.xprev()

previous verb

For details, see q.xprev and xprev on code.kx.com.

K.xrank()

buckets verb

For details, see q.xrank and xrank on code.kx.com.

namespace q

pyq.q

Q functions

q.abs()

absolute value function The abs function computes the absolute value of its argument. Null is returned if the argument is null.

>>> q.abs([-1, 0, 1, None])
k('1 0 1 0N')

See also abs on code.kx.com.

q.acos()

arc cosine function

See also acos on code.kx.com.

q.aj()

asof join function

See also aj on code.kx.com.

q.aj0()

asof join function

See also aj on code.kx.com.

q.all()

all function

See also all on code.kx.com.

q.and_()

and verb

See also and on code.kx.com.

q.any()

any function

See also any on code.kx.com.

q.asc()

ascending function

See also asc on code.kx.com.

q.asin()

arc sine function

See also asin on code.kx.com.

q.asof()

asof verb

See also asof on code.kx.com.

q.atan()

arc tangent function

See also atan on code.kx.com.

q.attr()

attributes function

See also attr on code.kx.com.

q.avg()

average function

See also avg on code.kx.com.

q.avgs()

running averages function

See also avgs on code.kx.com.

q.bin()

binary search verb

See also bin on code.kx.com.

q.binr()

binary search verb

See also bin on code.kx.com.

q.ceiling()

ceiling function

See also ceiling on code.kx.com.

q.cols()

columns function

See also cols on code.kx.com.

q.cor()

correlation verb

See also cor on code.kx.com.

q.cos()

cosine function

See also cos on code.kx.com.

q.count()

count function

See also count on code.kx.com.

q.cov()

covariance verb

See also cov on code.kx.com.

q.cross()

cross product verb

See also cross on code.kx.com.

q.csv()

csv global

See also csv on code.kx.com.

q.cut()

cut verb

See also cut on code.kx.com.

q.deltas()

deltas function

See also deltas on code.kx.com.

q.desc()

descending sort function

See also desc on code.kx.com.

q.dev()

standard deviation function

See also dev on code.kx.com.

q.differ()

differ function

See also differ on code.kx.com.

q.distinct()

distinct function

See also distinct on code.kx.com.

q.div()

integer division verb

See also div on code.kx.com.

q.dsave()

dsave function

See also dsave on code.kx.com.

q.each()

each adverb

See also each on code.kx.com.

q.ej()

equijoin verb

See also ej on code.kx.com.

q.ema()

exponentially weighted moving average verb

See also ema on code.kx.com.

q.ema()

exponentially weighted moving average verb

See also ema on code.kx.com.

q.enlist()

enlist function

See also enlist on code.kx.com.

q.eval()

eval function

See also eval on code.kx.com.

q.except_()

except verb

See also except on code.kx.com.

q.exp()

exp function

See also exp on code.kx.com.

q.fby()

filter-by

See also fby on code.kx.com.

q.fills()

fills function

See also fills on code.kx.com.

q.first()

first function

See also first on code.kx.com.

q.fkeys()

fkeys function

See also fkeys on code.kx.com.

q.flip()

flip function

See also flip on code.kx.com.

q.floor()

floor function

See also floor on code.kx.com.

q.get()

get function

See also get on code.kx.com.

q.getenv()

getenv function

See also getenv on code.kx.com.

q.group()

group function

See also group on code.kx.com.

q.gtime()

gtime function

See also gtime on code.kx.com.

q.hclose()

hclose function

See also hclose on code.kx.com.

q.hcount()

hcount function

See also hcount on code.kx.com.

q.hdel()

hdel function

See also hdel on code.kx.com.

q.hopen()

hopen function

See also hopen on code.kx.com.

q.hsym()

hsym function

See also hsym on code.kx.com.

q.iasc()

ascending function

See also iasc on code.kx.com.

q.idesc()

descending function

See also idesc on code.kx.com.

q.ij()

inner join verb

See also ij on code.kx.com.

q.ijf()

The ijf function.

See also ijf on code.kx.com.

q.in_()

membership verb

See also in on code.kx.com.

q.insert()

insert verb

See also insert on code.kx.com.

q.inter()

intersect verb

See also inter on code.kx.com.

q.inv()

inverse function

See also inv on code.kx.com.

q.key()

key function

See also key on code.kx.com.

q.keys()

keys function

See also keys on code.kx.com.

q.last()

last function

See also last on code.kx.com.

q.like()

pattern matching verb

See also like on code.kx.com.

q.lj()

left join verb

See also lj on code.kx.com.

q.ljf()

The ljf function.

See also ljf on code.kx.com.

q.load()

load function

See also load on code.kx.com.

q.log()

log function

See also log on code.kx.com.

q.lower()

lowercase function

See also lower on code.kx.com.

q.lsq()

least squares verb

See also lsq on code.kx.com.

q.ltime()

ltime function

See also ltime on code.kx.com.

q.ltrim()

left trim function

See also ltrim on code.kx.com.

q.mavg()

moving average verb

See also mavg on code.kx.com.

q.max()

maximum function

See also max on code.kx.com.

q.maxs()

maximums function

See also maxs on code.kx.com.

q.mcount()

moving count verb

See also mcount on code.kx.com.

q.md5()

md5 function

See also md5 on code.kx.com.

q.mdev()

moving deviation verb

See also mdev on code.kx.com.

q.med()

median function

See also med on code.kx.com.

q.meta()

meta data function

See also meta on code.kx.com.

q.min()

minimum function

See also min on code.kx.com.

q.mins()

minimums function

See also mins on code.kx.com.

q.mmax()

moving maximum verb

See also mmax on code.kx.com.

q.mmin()

moving minimum verb

See also mmin on code.kx.com.

q.mmu()

matrix multiplication verb

See also mmu on code.kx.com.

q.mod()

modulus verb

See also mod on code.kx.com.

q.msum()

moving sum verb

See also msum on code.kx.com.

q.neg()

negative function

See also neg on code.kx.com.

q.next()

next function

See also next on code.kx.com.

q.not_()

logical not function

See also not on code.kx.com.

q.null()

null function

See also null on code.kx.com.

q.or_()

or verb

See also or on code.kx.com.

q.over()

over adverb

See also over on code.kx.com.

q.parse()

parse function

See also parse on code.kx.com.

q.peach()

parallel each adverb

See also peach on code.kx.com.

q.pj()

plus join verb

See also pj on code.kx.com.

q.prd()

product function

See also prd on code.kx.com.

q.prds()

cumulative product function

See also prds on code.kx.com.

q.prev()

prev function

See also prev on code.kx.com.

q.prior()

prior function

See also prior on code.kx.com.

q.rand()

random function

See also rand on code.kx.com.

q.rank()

rank function

See also rank on code.kx.com.

q.ratios()

ratios function

See also ratios on code.kx.com.

q.raze()

raze function

See also raze on code.kx.com.

q.read0()

file read function

See also read0 on code.kx.com.

q.read1()

file read function

See also read1 on code.kx.com.

q.reciprocal()

reciprocal function

See also reciprocal on code.kx.com.

q.reval()

reval function

See also reval on code.kx.com.

q.reval()

reval function

See also reval on code.kx.com.

q.reverse()

reverse function

See also reverse on code.kx.com.

q.rload()

rload function

See also rload on code.kx.com.

q.rotate()

rotate verb

See also rotate on code.kx.com.

q.rsave()

rsave function

See also rsave on code.kx.com.

q.rtrim()

right trim function

See also rtrim on code.kx.com.

q.save()

save function

See also save on code.kx.com.

q.scan()

scan adverb

See also scan on code.kx.com.

q.scov()

statistical covariance verb

See also scov on code.kx.com.

q.scov()

statistical covariance verb

See also scov on code.kx.com.

q.sdev()

statistical standard deviation function

See also sdev on code.kx.com.

q.sdev()

statistical standard deviation function

See also sdev on code.kx.com.

q.set()

set verb

See also set on code.kx.com.

q.setenv()

setenv verb

See also setenv on code.kx.com.

q.show()

show function

See also show on code.kx.com.

q.signum()

signum function

See also signum on code.kx.com.

q.sin()

sine function

See also sin on code.kx.com.

q.sqrt()

square root function

See also sqrt on code.kx.com.

q.ss()

string search function

See also ss on code.kx.com.

q.ssr()

string search replace function

See also ssr on code.kx.com.

q.string()

string function

See also string on code.kx.com.

q.sublist()

sublist verb

See also sublist on code.kx.com.

q.sum()

sum function

See also sum on code.kx.com.

q.sums()

cumulative sum function

See also sums on code.kx.com.

q.sv()

scalar from vector verb

See also sv on code.kx.com.

q.svar()

statistical variance function

See also svar on code.kx.com.

q.svar()

statistical variance function

See also svar on code.kx.com.

q.system()

system command function

See also system on code.kx.com.

q.tables()

tables function

See also tables on code.kx.com.

q.tan()

tangent function

See also tan on code.kx.com.

q.til()

til function

See also til on code.kx.com.

q.trim()

trim function

See also trim on code.kx.com.

q.type()

type function

See also type on code.kx.com.

q.uj()

union join verb

See also uj on code.kx.com.

q.ungroup()

ungroup function

See also ungroup on code.kx.com.

q.union()

union verb

See also union on code.kx.com.

q.upper()

uppercase function

See also upper on code.kx.com.

q.upsert()

upsert verb

See also upsert on code.kx.com.

q.value()

value function

See also value on code.kx.com.

q.var()

variance function

See also var on code.kx.com.

q.view()

view function

See also view on code.kx.com.

q.views()

views function

See also views on code.kx.com.

q.vs()

vector from scalar verb

See also vs on code.kx.com.

q.wavg()

weighted average verb

See also wavg on code.kx.com.

q.where()

where function

See also where on code.kx.com.

q.within()

within verb

See also within on code.kx.com.

q.wj()

window join function

See also wj on code.kx.com.

q.wj1()

The wj1 function.

See also wj1 on code.kx.com.

q.wsum()

weighted sum verb

See also wsum on code.kx.com.

q.ww()

The ww function.

See also ww on code.kx.com.

q.xasc()

ascending sort verb

See also xasc on code.kx.com.

q.xbar()

interval bar verb

See also xbar on code.kx.com.

q.xcol()

rename columns verb

See also xcol on code.kx.com.

q.xcols()

reorder columns verb

See also xcols on code.kx.com.

q.xdesc()

descending sort verb

See also xdesc on code.kx.com.

q.xexp()

power verb

See also xexp on code.kx.com.

q.xgroup()

grouping verb

See also xgroup on code.kx.com.

q.xkey()

set primary key verb

See also xkey on code.kx.com.

q.xlog()

base-x log verb

See also xlog on code.kx.com.

q.xprev()

previous verb

See also xprev on code.kx.com.

q.xrank()

buckets verb

See also xrank on code.kx.com.