Class: DateTimeColumn

dg.DateTimeColumn

Strongly-typed column. Use get and set to access elements by index.

Hierarchy

• Column<dayjs.Dayjs>

  ↳ DateTimeColumn

Constructors

constructor

• new DateTimeColumn(dart)

Parameters

Name	Type
dart	any

Inherited from

Column.constructor

Defined in

src/dataframe.ts:594

Properties

dart

• dart: any

Inherited from

Column.dart

Defined in

src/dataframe.ts:588

---

tags

• tags: any

Inherited from

Column.tags

Defined in

src/dataframe.ts:590

---

temp

• temp: any

Inherited from

Column.temp

Defined in

src/dataframe.ts:589

Accessors

categories

• get categories(): string[]

Returns all unique strings in a sorted order. Applicable to string column only.

Returns

string[]

Inherited from

Column.categories

Defined in

src/dataframe.ts:960

---

colors

• get colors(): ColumnColorHelper

Returns

ColumnColorHelper

Inherited from

Column.colors

Defined in

src/dataframe.ts:815

---

dataFrame

• get dataFrame(): DataFrame

Parent table

Returns

DataFrame

Inherited from

Column.dataFrame

Defined in

src/dataframe.ts:769

---

dialogs

• get dialogs(): ColumnDialogHelper

Returns

ColumnDialogHelper

Inherited from

Column.dialogs

Defined in

src/dataframe.ts:808

---

isVirtual

• get isVirtual(): boolean

Is this column virtual

Returns

boolean

Inherited from

Column.isVirtual

Defined in

src/dataframe.ts:757

---

layoutColumnId

• get layoutColumnId(): string

Layout column ID

Returns

string

Inherited from

Column.layoutColumnId

Defined in

src/dataframe.ts:785

• set layoutColumnId(s): void

Parameters

Name	Type
s	string

Returns

void

Inherited from

Column.layoutColumnId

Defined in

src/dataframe.ts:789

---

length

• get length(): number

Number of elements

Returns

number

Inherited from

Column.length

Defined in

src/dataframe.ts:763

---

markers

• get markers(): ColumnMarkerHelper

Returns

ColumnMarkerHelper

Inherited from

Column.markers

Defined in

src/dataframe.ts:820

---

max

• get max(): number

Column's maximum value. The result is cached.

Returns

number

Inherited from

Column.max

Defined in

src/dataframe.ts:989

---

meta

• get meta(): ColumnMetaHelper

Returns

ColumnMetaHelper

Inherited from

Column.meta

Defined in

src/dataframe.ts:600

---

min

• get min(): number

Column's minimum value. The result is cached.

Returns

number

Inherited from

Column.min

Defined in

src/dataframe.ts:986

---

name

• get name(): string

Returns

string

Inherited from

Column.name

Defined in

src/dataframe.ts:794

• set name(s): void

Parameters

Name	Type
s	string

Returns

void

Inherited from

Column.name

Defined in

src/dataframe.ts:798

---

semType

• get semType(): string

Semantic type

Returns

string

Inherited from

Column.semType

Defined in

src/dataframe.ts:775

• set semType(s): void

Parameters

Name	Type
s	string

Returns

void

Inherited from

Column.semType

Defined in

src/dataframe.ts:779

---

stats

• get stats(): Stats

Basic descriptive statistics. The result is cached.

Returns

Stats

Inherited from

Column.stats

Defined in

src/dataframe.ts:999

---

type

• get type(): "string" | "bigint" | "object" | "int" | "double" | "bool" | "byte_array" | "datetime" | "qnum" | "dataframe"

Column data type.

Returns

"string" | "bigint" | "object" | "int" | "double" | "bool" | "byte_array" | "datetime" | "qnum" | "dataframe"

Inherited from

Column.type

Defined in

src/dataframe.ts:751

---

valueComparer

• get valueComparer(): null | Comparer

Value comparison function to be used for sorting. Null means default sorting. Sample: https://public.datagrok.ai/js/samples/data-frame/sorting/custom-comparer

Returns

null | Comparer

Inherited from

Column.valueComparer

Defined in

src/dataframe.ts:982

• set valueComparer(cmp): void

Parameters

Name	Type
cmp	null | Comparer

Returns

void

Inherited from

Column.valueComparer

Defined in

src/dataframe.ts:983

---

version

• get version(): number

Version of the column. Increases each time the column was changed

Returns

number

Inherited from

Column.version

Defined in

src/dataframe.ts:804

Methods

aggregate

▸ aggregate(type): any

Aggregates a column using the [type] function, which corresponds to

• [DG.AGG] for int, bigint, float, qnum columns,
• [DG.STR_AGG] and [DG.STAT_COUNTS] for string columns,
• [DG.STAT_COUNTS], [DG.AGG.MIN], [DG.AGG.MAX], [DG.AGG.AVG] for datetime columns,
• [DG.AGG.TOTAL_COUNT] and [DG.AGG.MISSING_VALUE_COUNT] for virtual columns.

Parameters

Name	Type
type	string

Returns

any

Inherited from

Column.aggregate

Defined in

src/dataframe.ts:1034

---

applyFormula

▸ applyFormula(formula, type?, treatAsString?): Promise<null | Column<any>>

Applies the specified formula to a calculated column. Returns a new column object, if applied successfully, and null otherwise.

Parameters

Name	Type	Default value
formula	string	undefined
type	null | "string" | "bigint" | "object" | "int" | "double" | "bool" | "byte_array" | "datetime" | "qnum" | "dataframe"	null
treatAsString	boolean	false

Returns

Promise<null | Column<any>>

Inherited from

Column.applyFormula

Defined in

src/dataframe.ts:1010

---

clone

▸ clone(mask?): Column<Dayjs>

Performs deep cloning, optionally taking mask of the rows to be included. Note that the cloned colum is not added to this column's dataframe.

Parameters

Name	Type
mask?	BitSet

Returns

Column<Dayjs>

Inherited from

Column.clone

Defined in

src/dataframe.ts:845

---

compact

▸ compact(): any

Compacts the internal column representation. Currently, it only affects string columns where values were modified.

Returns

any

Inherited from

Column.compact

Defined in

src/dataframe.ts:949

---

convertTo

▸ convertTo(newType, format?): Column<any>

Creates and returns a new column by converting [column] to the specified [newType].

Parameters

Name	Type	Default value
newType	string	undefined
format	null | string	null

Returns

Column<any>

Inherited from

Column.convertTo

Defined in

src/dataframe.ts:1019

---

get

▸ get(row): null | Dayjs

Gets [i]-th value.

Parameters

Name	Type
row	number

Returns

null | Dayjs

Overrides

Column.get

Defined in

src/dataframe.ts:1064

---

getCategory

▸ getCategory(categoryIndex): string

Returns i-th category. Applicable to string column only.

Parameters

Name	Type
categoryIndex	number

Returns

string

Inherited from

Column.getCategory

Defined in

src/dataframe.ts:965

---

getCategoryOrder

▸ getCategoryOrder(): string[]

Gets order of categories

Returns

string[]

Inherited from

Column.getCategoryOrder

Defined in

src/dataframe.ts:975

---

getNumber

▸ getNumber(i): number

Returns i-th value as number

Parameters

Name	Type
i	number

Returns

number

Inherited from

Column.getNumber

Defined in

src/dataframe.ts:898

---

getRawData

▸ getRawData(): Int32Array | Uint32Array | Float32Array | Float64Array

FOR EXPERT USE ONLY!

Returns the raw buffer containing data. Sample: https://public.datagrok.ai/js/samples/data-frame/performance/access Return type depends on the column type: {Int32Array} for ints, INT_NULL represents null. {Float32Array} for floats, FLOAT_NULL represents null. {Float64Array} for qnums, FLOAT_NULL represents null. {Float64Array} for datetime, in microseconds since epoch, FLOAT_NULL represents null. {Int32Array} for strings indexes of categories. {Uint32Array} bit array.

Returns

Int32Array | Uint32Array | Float32Array | Float64Array

Inherited from

Column.getRawData

Defined in

src/dataframe.ts:859

---

getSortedOrder

▸ getSortedOrder(): Int32Array

Returns an array of indexes sorted using [valueComparer].

Returns

Int32Array

Inherited from

Column.getSortedOrder

Defined in

src/dataframe.ts:978

---

getString

▸ getString(i): string

Returns i-th value as string, taking into account value format defined for the column. An empty string is returned if there is no value.

Parameters

Name	Type
i	number

Returns

string

Inherited from

Column.getString

Defined in

src/dataframe.ts:891

---

getTag

▸ getTag(tag): string

Gets the value of the specified tag.

Parameters

Name	Type
tag	string

Returns

string

Inherited from

Column.getTag

Defined in

src/dataframe.ts:934

---

init

▸ init(valueInitializer): Column<any>

Initializes all values in the column to [columnInitializer].

Parameters

Name	Type	Description
valueInitializer	string | number | boolean | (ind: number) => any	value, or a function that returns value by index

Returns

Column<any>

Inherited from

Column.init

Defined in

src/dataframe.ts:829

---

isNone

▸ isNone(i): boolean

Returns whether i-th value is missing.

Parameters

Name	Type	Description
i	number	Row index.

Returns

boolean

Inherited from

Column.isNone

Defined in

src/dataframe.ts:927

---

matches

▸ matches(filter): boolean

Checks whether the column passes the specified [filter]. [filter] can be either specific data [type] such as 'int' or 'string', more broadly - 'numerical', or 'categorical', or null for any columns.

Parameters

Name	Type
filter	null | "string" | "bigint" | "object" | "int" | "double" | "bool" | "byte_array" | "datetime" | "qnum" | "dataframe" | "categorical" | "numerical"

Returns

boolean

Inherited from

Column.matches

Defined in

src/dataframe.ts:994

---

scale

▸ scale(idx): number

Linearly maps idx-th value to the [0,1] interval, where 0 represents column minimum, and 1 represents maximum.

Parameters

Name	Type
idx	number

Returns

number

Inherited from

Column.scale

Defined in

src/dataframe.ts:872

---

set

▸ set(i, value, notify?): void

Sets [i]-th value to [x], and optionally notifies the dataframe about this change.

Parameters

Name	Type	Default value
i	number	undefined
value	null | Dayjs	undefined
notify	boolean	true

Returns

void

Overrides

Column.set

Defined in

src/dataframe.ts:1074

---

setCategoryOrder

▸ setCategoryOrder(order): void

Sets order of categories

Parameters

Name	Type
order	string[]

Returns

void

Inherited from

Column.setCategoryOrder

Defined in

src/dataframe.ts:970

---

setRawData

▸ setRawData(rawData, notify?): void

Parameters

Name	Type	Default value
rawData	Int32Array | Uint32Array | Float32Array | Float64Array	undefined
notify	boolean	true

Returns

void

Inherited from

Column.setRawData

Defined in

src/dataframe.ts:876

---

setString

▸ setString(i, str, notify?): boolean

Attempts to set i-th value by converting a provided string to the corresponding strongly-typed value. Returns true if text was successfully parsed and set, otherwise false. Examples: dateColumn.setString('April 1, 2020'); intColumn.setString('42');

Parameters

Name	Type	Default value	Description
i	number	undefined
str	string	undefined
notify	boolean	true	whether DataFrame's changed event should be fired

Returns

boolean

Inherited from

Column.setString

Defined in

src/dataframe.ts:910

---

setTag

▸ setTag(tag, value): Column<any>

Sets a tag to the specified value.

Parameters

Name	Type	Description
tag	string	Key.
value	string	Value.

Returns

Column<any>

. *

Inherited from

Column.setTag

Defined in

src/dataframe.ts:942

---

toList

▸ toList(): any[]

Copies column values to an array. Avoid using this method for performance-critical routines; consider using getRawData

Returns

any[]

Inherited from

Column.toList

Defined in

src/dataframe.ts:955

---

toString

▸ toString(): string

Returns

string

• string representation of this column

Inherited from

Column.toString

Defined in

src/dataframe.ts:1024

---

values

▸ values(): Generator<null | Dayjs, void, unknown>

An iterator over all values in this column.

Returns

Generator<null | Dayjs, void, unknown>

Inherited from

Column.values

Defined in

src/dataframe.ts:1002

---

bool

▸ Static bool(name, length?): Column<boolean>

Creates a boolean column with the specified name and length.

Parameters

Name	Type	Default value
name	string	undefined
length	number	0

Returns

Column<boolean>

Inherited from

Column.bool

Defined in

src/dataframe.ts:707

---

dataFrame

▸ Static dataFrame(name, length?): Column<DataFrame>

Creates a column containing dataframes with the specified name and length.

Parameters

Name	Type	Default value
name	string	undefined
length	number	0

Returns

Column<DataFrame>

Inherited from

Column.dataFrame

Defined in

src/dataframe.ts:723

---

dateTime

▸ Static dateTime(name, length?): Column<any>

Creates a datetime column with the specified name and length.

Parameters

Name	Type	Default value
name	string	undefined
length	number	0

Returns

Column<any>

Inherited from

Column.dateTime

Defined in

src/dataframe.ts:715

---

float

▸ Static float(name, length?): Column<number>

Creates a floating point column with the specified name and length.

Parameters

Name	Type	Default value
name	string	undefined
length	number	0

Returns

Column<number>

Inherited from

Column.float

Defined in

src/dataframe.ts:691

---

fromBigInt64Array

▸ Static fromBigInt64Array(name, array): Column<any>

Creates BigIntColumn from BigInt64Array / BigUint64Array

Parameters

Name	Type
name	string
array	BigInt64Array | BigUint64Array

Returns

Column<any>

Inherited from

Column.fromBigInt64Array

Defined in

src/dataframe.ts:644

---

fromBitSet

▸ Static fromBitSet(name, bitset): Column<boolean>

Creates a {Column} from the bitset.

Parameters

Name	Type
name	string
bitset	BitSet

Returns

Column<boolean>

Inherited from

Column.fromBitSet

Defined in

src/dataframe.ts:675

---

fromFloat32Array

▸ Static fromFloat32Array(name, array, length?): Column<number>

[array] will be not be copied and will be used as column's storage

Parameters

Name	Type	Default value
name	string	undefined
array	Float32Array	undefined
length	null | number	null

Returns

Column<number>

Inherited from

Column.fromFloat32Array

Defined in

src/dataframe.ts:639

---

fromIndexes

▸ Static fromIndexes(name, categories, indexes): Column<any>

Crates a Column of string type from categories and indexes

Parameters

Name	Type
name	string
categories	string[]
indexes	Int32Array

Returns

Column<any>

Inherited from

Column.fromIndexes

Defined in

src/dataframe.ts:667

---

fromInt32Array

▸ Static fromInt32Array(name, array, length?): Column<number>

[array] will be not be copied and will be used as column's storage

Parameters

Name	Type	Default value
name	string	undefined
array	Int32Array	undefined
length	null | number	null

Returns

Column<number>

Inherited from

Column.fromInt32Array

Defined in

src/dataframe.ts:634

---

fromList

▸ Static fromList(type, name, list): Column<any>

Creates a Column from the list of values.

Parameters

Name	Type
type	"string" | "bigint" | "object" | "int" | "double" | "bool" | "byte_array" | "datetime" | "qnum" | "dataframe"
name	string
list	any[]

Returns

Column<any>

Inherited from

Column.fromList

Defined in

src/dataframe.ts:655

---

fromStrings

▸ Static fromStrings(name, list): Column<any>

Creates a Column from the list of string values Please note that method performs type promotion if all listed values are numeric

Parameters

Name	Type	Description
name	string	Column name
list	string[]	List of column values https://dev.datagrok.ai/script/samples/javascript/data-frame/construction/create-from-columns https://dev.datagrok.ai/script/samples/javascript/data-frame/construction/create-from-arrays

Returns

Column<any>

Inherited from

Column.fromStrings

Defined in

src/dataframe.ts:616

---

fromType

▸ Static fromType(type, name?, length?): Column<any>

Creates a Column with explicitly specified type

Parameters

Name	Type	Default value	Description
type	"string" | "bigint" | "object" | "int" | "double" | "bool" | "byte_array" | "datetime" | "qnum" | "dataframe"	undefined	column type code COLUMN_TYPE
name?	null | string	undefined	Column name
length	number	0	Column length (should match row count of the data frame ) create {@see COLUMN_TYPE}

Returns

Column<any>

Inherited from

Column.fromType

Defined in

src/dataframe.ts:629

---

int

▸ Static int(name, length?): Column<number>

Creates an integer column with the specified name and length.

Parameters

Name	Type	Default value
name	string	undefined
length	number	0

Returns

Column<number>

Inherited from

Column.int

Defined in

src/dataframe.ts:683

---

qnum

▸ Static qnum(name, length?, values?, exact?): Column<number>

Creates a qualified number column with the specified name and length. Initialized values with [values], if it is specified; strips out the qualifier part if [exact] is true.

Parameters

Name	Type	Default value	Description
name	string	undefined
length	number	0
values	number[]	[]
exact	boolean	true	if true, strips out qualifier from [values].

Returns

Column<number>

Inherited from

Column.qnum

Defined in

src/dataframe.ts:736

---

string

▸ Static string(name, length?): Column<string>

Creates a string column with the specified name and length.

Parameters

Name	Type	Default value
name	string	undefined
length	number	0

Returns

Column<string>

Inherited from

Column.string

Defined in

src/dataframe.ts:699