q.abs()

absolute value 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

See also acos on code.kx.com.

q.aj()

as-of join

See also aj on code.kx.com.

q.aj0()

as-of join

See also aj on code.kx.com.

q.all()

all nonzero

See also all on code.kx.com.

q.and_()

and

See also and on code.kx.com.

q.any()

any item is non-zero

See also any on code.kx.com.

q.asc()

ascending sort

See also asc on code.kx.com.

q.asin()

arc sine

See also asin on code.kx.com.

q.asof()

as-of operator

See also asof on code.kx.com.

q.atan()

arc tangent

See also atan on code.kx.com.

q.attr()

attributes

See also attr on code.kx.com.

q.avg()

arithmetic mean

See also avg on code.kx.com.

q.avgs()

running averages

See also avgs on code.kx.com.

q.bin()

binary search

See also bin on code.kx.com.

q.binr()

binary search

See also bin on code.kx.com.

q.ceiling()

lowest integer above

See also ceiling on code.kx.com.

q.cols()

column names of a table

See also cols on code.kx.com.

q.cor()

correlation

See also cor on code.kx.com.

q.cos()

cosine

See also cos on code.kx.com.

q.count()

number of items

See also count on code.kx.com.

q.cov()

statistical covariance

See also cov on code.kx.com.

q.cross()

cross product

See also cross on code.kx.com.

q.csv()

comma delimiter

See also csv on code.kx.com.

q.cut()

cut

See also cut on code.kx.com.

q.deltas()

differences between consecutive pairs

See also deltas on code.kx.com.

q.desc()

descending sort

See also desc on code.kx.com.

q.dev()

standard deviation

See also dev on code.kx.com.

q.differ()

flag differences in consecutive pairs

See also differ on code.kx.com.

q.distinct()

unique items

See also distinct on code.kx.com.

q.div()

integer division

See also div on code.kx.com.

q.dsave()

save global tables to disk

See also dsave on code.kx.com.

q.ej()

equi-join

See also ej on code.kx.com.

q.ema()

exponentially-weighted moving average

See also ema on code.kx.com.

q.ema()

exponentially-weighted moving average

See also ema on code.kx.com.

q.enlist()

arguments as a list

See also enlist on code.kx.com.

q.eval()

evaluate a parse tree

See also eval on code.kx.com.

q.except_()

left argument without items in right argument

See also except on code.kx.com.

q.exp()

power of e

See also exp on code.kx.com.

q.fby()

filter-by

See also fby on code.kx.com.

q.fills()

forward-fill nulls

See also fills on code.kx.com.

q.first()

first item

See also first on code.kx.com.

q.fkeys()

foreign-key columns mapped to their tables

See also fkeys on code.kx.com.

q.flip()

transpose

See also flip on code.kx.com.

q.floor()

greatest integer less than argument

See also floor on code.kx.com.

q.get()

get

See also get on code.kx.com.

q.getenv()

value of an environment variable

See also getenv on code.kx.com.

q.group()

dictionary of distinct items

See also group on code.kx.com.

q.gtime()

UTC timestamp

See also gtime on code.kx.com.

q.hclose()

close a file or process

See also hclose on code.kx.com.

q.hcount()

size of a file

See also hcount on code.kx.com.

q.hdel()

delete a file

See also hdel on code.kx.com.

q.hopen()

open a file

See also hopen on code.kx.com.

q.hsym()

convert symbol to filename or IP address

See also hsym on code.kx.com.

q.iasc()

indices of ascending sort

See also iasc on code.kx.com.

q.idesc()

indices of descending sort

See also idesc on code.kx.com.

q.ij()

inner join

See also ij on code.kx.com.

q.ijf()

The ijf function.

See also ijf on code.kx.com.

q.in_()

membership

See also in on code.kx.com.

q.insert()

append records to a table

See also insert on code.kx.com.

q.inter()

items common to both arguments

See also inter on code.kx.com.

q.inv()

matrix inverse

See also inv on code.kx.com.

q.key()

key

See also key on code.kx.com.

q.keys()

names of a table’s columns

See also keys on code.kx.com.

q.last()

last item

See also last on code.kx.com.

q.like()

pattern matching

See also like on code.kx.com.

q.lj()

left join

See also lj on code.kx.com.

q.ljf()

left join

See also ljf on code.kx.com.

q.load()

load binary data

See also load on code.kx.com.

q.log()

natural logarithm

See also log on code.kx.com.

q.lower()

lower case

See also lower on code.kx.com.

q.lsq()

least squares matrix divide

See also lsq on code.kx.com.

q.ltime()

local timestamp

See also ltime on code.kx.com.

q.ltrim()

function remove leading spaces

See also ltrim on code.kx.com.

q.mavg()

moving average

See also mavg on code.kx.com.

q.max()

maximum

See also max on code.kx.com.

q.maxs()

maxima of preceding items

See also maxs on code.kx.com.

q.mcount()

moving count

See also mcount on code.kx.com.

q.md5()

MD5 hash

See also md5 on code.kx.com.

q.mdev()

moving deviation

See also mdev on code.kx.com.

q.med()

median

See also med on code.kx.com.

q.meta()

metadata of a table

See also meta on code.kx.com.

q.min()

minimum

See also min on code.kx.com.

q.mins()

minimum of preceding items

See also mins on code.kx.com.

q.mmax()

moving maxima

See also mmax on code.kx.com.

q.mmin()

moving minima

See also mmin on code.kx.com.

q.mmu()

mmu

See also mmu on code.kx.com.

q.mod()

remainder

See also mod on code.kx.com.

q.msum()

moving sum

See also msum on code.kx.com.

q.neg()

negate

See also neg on code.kx.com.

q.next()

next items

See also next on code.kx.com.

q.not_()

not

See also not on code.kx.com.

q.null()

null

See also null on code.kx.com.

q.or_()

or

See also or on code.kx.com.

q.parse()

parse a string

See also parse on code.kx.com.

q.peach()

peach

See also peach on code.kx.com.

q.pj()

plus join

See also pj on code.kx.com.

q.prd()

product

See also prd on code.kx.com.

q.prds()

cumulative products

See also prds on code.kx.com.

q.prev()

previous items

See also prev on code.kx.com.

q.prior()

prior

See also prior on code.kx.com.

q.rand()

random number

See also rand on code.kx.com.

q.rank()

grade up

See also rank on code.kx.com.

q.ratios()

ratios of consecutive pairs

See also ratios on code.kx.com.

q.raze()

join items

See also raze on code.kx.com.

q.read0()

read file as lines

See also read0 on code.kx.com.

q.read1()

read file as bytes

See also read1 on code.kx.com.

q.reciprocal()

reciprocal of a number

See also reciprocal on code.kx.com.

q.reval()

variation of eval

See also reval on code.kx.com.

q.reverse()

reverse the order of items

See also reverse on code.kx.com.

q.rload()

load a splayed table

See also rload on code.kx.com.

q.rotate()

rotate items

See also rotate on code.kx.com.

q.rsave()

rsave

See also rsave on code.kx.com.

q.rtrim()

remove trailing spaces

See also rtrim on code.kx.com.

q.save()

save global data to file

See also save on code.kx.com.

q.scov()

statistical covariance

See also scov on code.kx.com.

q.scov()

statistical covariance

See also scov on code.kx.com.

q.sdev()

statistical standard deviation

See also sdev on code.kx.com.

q.sdev()

statistical standard deviation

See also sdev on code.kx.com.

q.set()

set

See also set on code.kx.com.

q.setenv()

set an environment variable

See also setenv on code.kx.com.

q.show()

format to the console

See also show on code.kx.com.

q.signum()

sign of its argument/s

See also signum on code.kx.com.

q.sin()

sine

See also sin on code.kx.com.

q.sqrt()

square root

See also sqrt on code.kx.com.

q.ss()

string search

See also ss on code.kx.com.

q.ssr()

string search and replace

See also ssr on code.kx.com.

q.string()

cast to string

See also string on code.kx.com.

q.sublist()

sublist of a list

See also sublist on code.kx.com.

q.sum()

sum of a list

See also sum on code.kx.com.

q.sums()

cumulative sums of a list

See also sums on code.kx.com.

q.sv()

consolidate

See also sv on code.kx.com.

q.svar()

statistical variance

See also svar on code.kx.com.

q.svar()

statistical variance

See also svar on code.kx.com.

q.system()

system

See also system on code.kx.com.

q.tables()

sorted list of tables

See also tables on code.kx.com.

q.tan()

tangent

See also tan on code.kx.com.

q.til()

integers up to x

See also til on code.kx.com.

q.trim()

remove leading and trailing spaces

See also trim on code.kx.com.

q.type()

data type

See also type on code.kx.com.

q.uj()

union join

See also uj on code.kx.com.

q.ujf()

The ujf function.

See also ujf on code.kx.com.

q.ungroup()

flattened table

See also ungroup on code.kx.com.

q.union()

distinct items of combination of two lists

See also union on code.kx.com.

q.upper()

upper-case

See also upper on code.kx.com.

q.upsert()

add table records

See also upsert on code.kx.com.

q.value()

value

See also value on code.kx.com.

q.var()

variance

See also var on code.kx.com.

q.view()

definition of a dependency

See also view on code.kx.com.

q.views()

list of defined views

See also views on code.kx.com.

q.vs()

split

See also vs on code.kx.com.

q.wavg()

weighted average

See also wavg on code.kx.com.

q.where()

replicated items

See also where on code.kx.com.

q.within()

flag items within range

See also within on code.kx.com.

q.wj()

window join

See also wj on code.kx.com.

q.wj1()

window join

See also wj1 on code.kx.com.

q.wsum()

weighted sum

See also wsum on code.kx.com.

q.ww()

The ww function.

See also ww on code.kx.com.

q.xasc()

table sorted ascending by columns

See also xasc on code.kx.com.

q.xbar()

interval bar

See also xbar on code.kx.com.

q.xcol()

rename table columns

See also xcol on code.kx.com.

q.xcols()

re-order table columns

See also xcols on code.kx.com.

q.xdesc()

table sorted descending by columns

See also xdesc on code.kx.com.

q.xexp()

raised to a power

See also xexp on code.kx.com.

q.xgroup()

table grouped by keys

See also xgroup on code.kx.com.

q.xkey()

set primary keys of a table

See also xkey on code.kx.com.

q.xlog()

base-x logarithm

See also xlog on code.kx.com.

q.xprev()

previous items

See also xprev on code.kx.com.

q.xrank()

items assigned to buckets

See also xrank on code.kx.com.