DateTimeColumn (tablesaw-core 0.37.0 API)

java.lang.Object
- tech.tablesaw.columns.AbstractColumn<DateTimeColumn,LocalDateTime>
- - tech.tablesaw.api.DateTimeColumn

All Implemented Interfaces:

Iterable<LocalDateTime>, Comparator<LocalDateTime>, CategoricalColumn<LocalDateTime>, Column<LocalDateTime>, DateTimeFilters, DateTimeMapFunctions, TemporalColumn<LocalDateTime>, TemporalFillers<LocalDateTime,DateTimeColumn>, TemporalFilters<LocalDateTime>, TemporalMapFunctions<LocalDateTime>, DateAndDateTimeFilterSpec<Selection>, DateTimeFilterSpec<Selection>, FilterSpec<Selection>, InstantFilterSpec<Selection>, TimeAndDateTimeFilterSpec<Selection>
```
public class DateTimeColumn
extends AbstractColumn<DateTimeColumn,LocalDateTime>
implements DateTimeMapFunctions, DateTimeFilters, TemporalFillers<LocalDateTime,DateTimeColumn>, CategoricalColumn<LocalDateTime>
```
A column in a table that contains long-integer encoded (packed) local date-time values

Field Summary
- Fields inherited from class tech.tablesaw.columns.AbstractColumn
  DEFAULT_ARRAY_SIZE

Method Summary

All Methods Static Methods Instance Methods Concrete Methods Deprecated Methods
Modifier and Type	Method and Description
`DateTimeColumn`	`append(Column<LocalDateTime> column)`
`DateTimeColumn`	`append(Column<LocalDateTime> column, int row)`
`DateTimeColumn`	`append(LocalDateTime dateTime)`
`DateTimeColumn`	`appendCell(String stringValue)`
`DateTimeColumn`	`appendCell(String stringValue, AbstractColumnParser<?> parser)`
`DateTimeColumn`	`appendInternal(long dateTime)`
`DateTimeColumn`	`appendMissing()` Appends a missing value appropriate to the column
`DateTimeColumn`	`appendObj(Object obj)`
`byte[]`	`asBytes(int rowNumber)` Returns the contents of the cell at rowNumber as a byte[]
`double[]`	`asDoubleArray()`
`DoubleColumn`	`asDoubleColumn()`
`long[]`	`asEpochMillisArray()` Returns an array where each entry is the difference, measured in milliseconds, between the LocalDateTime and midnight, January 1, 1970 UTC.
`long[]`	`asEpochMillisArray(ZoneOffset offset)` Returns an array where each entry is the difference, measured in milliseconds, between the LocalDateTime and midnight, January 1, 1970 UTC.
`long[]`	`asEpochSecondArray()` Returns an array where each entry is the difference, measured in seconds, between the LocalDateTime and midnight, January 1, 1970 UTC.
`long[]`	`asEpochSecondArray(ZoneOffset offset)` Returns the seconds from epoch for each value as an array based on the given offset
`InstantColumn`	`asInstantColumn()`
`InstantColumn`	`asInstantColumn(ZoneId zone)`
`LocalDateTime[]`	`asObjectArray()`
`Set<LocalDateTime>`	`asSet()`
`List<LocalDateTime>`	`bottom(int n)` Returns the smallest ("bottom") n values in the column
`int`	`byteSize()` Returns the width of a cell in this column, in bytes.
`void`	`clear()`
`int`	`compare(LocalDateTime o1, LocalDateTime o2)`
`boolean`	`contains(LocalDateTime dateTime)` Returns `true` if the given object appears in this column, and false otherwise
`DateTimeColumn`	`copy()` Returns a deep copy of the receiver
`int`	`countMissing()` Returns the count of missing values in this column
`int`	`countUnique()` Returns the count of unique values in this column.
`static DateTimeColumn`	`create(String name)`
`static DateTimeColumn`	`create(String name, int initialSize)`
`static DateTimeColumn`	`create(String name, List<LocalDateTime> data)`
`static DateTimeColumn`	`create(String name, LocalDateTime[] data)`
`static DateTimeColumn`	`create(String name, Stream<LocalDateTime> stream)`
`it.unimi.dsi.fastutil.longs.LongArrayList`	`data()` Deprecated. Please use the longIterator() or getLongInternal() methods
`DateTimeColumn`	`emptyCopy()` Returns a copy of the receiver with no data.
`DateTimeColumn`	`emptyCopy(int rowSize)` Returns an empty copy of the receiver, with its internal storage initialized to the given row size.
`DateTimeColumn`	`fillWith(Iterable<LocalDateTime> iterable)`
`DateTimeColumn`	`fillWith(Iterator<LocalDateTime> iterator)`
`DateTimeColumn`	`fillWith(Supplier<LocalDateTime> supplier)`
`LocalDateTime`	`get(int index)`
`double`	`getDouble(int i)`
`long`	`getLongInternal(int index)`
`protected long`	`getPackedDateTime(int index)`
`String`	`getString(int row)` Returns a string representation of the value at the given row.
`String`	`getUnformattedString(int row)`
`boolean`	`isEmpty()` Returns true if the column has no data
`boolean`	`isMissing(int rowNumber)`
`Iterator<LocalDateTime>`	`iterator()` Returns an iterator over elements of type `T`.
`DateTimeColumn`	`lag(int n)` Returns a column of the same type and size as the receiver, containing the receivers values offset by n.
`it.unimi.dsi.fastutil.longs.LongIterator`	`longIterator()`
`LocalDateTime`	`max()`
`LocalDateTime`	`min()`
`DateTimeColumn`	`plus(long amountToAdd, ChronoUnit unit)`
`DateTimeColumn`	`removeMissing()`
`it.unimi.dsi.fastutil.ints.IntComparator`	`rowComparator()`
`DateTimeColumn`	`set(int row, Column<LocalDateTime> column, int sourceRow)`
`DateTimeColumn`	`set(int index, LocalDateTime value)`
`DateTimeColumn`	`set(int index, long value)`
`DateTimeColumn`	`set(Selection rowSelection, LocalDateTime newValue)` Conditionally update this column, replacing current values with newValue for all rows where the current value matches the selection criteria
`Column<LocalDateTime>`	`setMissing(int i)`
`void`	`setPrintFormatter(DateTimeColumnFormatter formatter)`
`void`	`setPrintFormatter(DateTimeFormatter dateTimeFormatter)`
`void`	`setPrintFormatter(DateTimeFormatter dateTimeFormatter, String missingValueString)`
`int`	`size()`
`void`	`sortAscending()`
`void`	`sortDescending()`
`DateTimeColumn`	`subset(int[] rows)`
`Table`	`summary()`
`List<LocalDateTime>`	`top(int n)` Returns the largest ("top") n values in the column
`DateTimeColumn`	`unique()` Returns a column of the same type as the receiver, containing only the unique values of the receiver.
`static boolean`	`valueIsMissing(long value)`
`DateTimeColumn`	`where(Selection selection)`

Methods inherited from class tech.tablesaw.columns.AbstractColumn
asStringColumn, filter, first, inRange, last, map, max, min, name, sampleN, sampleX, set, setName, sorted, toString, type

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface tech.tablesaw.columns.datetimes.DateTimeMapFunctions
date, dayOfMonth, dayOfWeek, dayOfWeekValue, dayOfYear, hour, hourMinute, lead, minute, minuteOfDay, month, monthValue, plusDays, plusHours, plusMicros, plusMillis, plusMinutes, plusMonths, plusSeconds, plusWeeks, plusYears, secondOfDay, time, timeWindow, timeWindow, year, yearDay, yearMonth, yearQuarter, yearWeek

Methods inherited from interface tech.tablesaw.columns.temporal.TemporalMapFunctions
difference, differenceInDays, differenceInHours, differenceInMilliseconds, differenceInMinutes, differenceInSeconds, differenceInYears, missingValues, temporalColumnName

Methods inherited from interface tech.tablesaw.columns.Column
allMatch, anyMatch, asList, asStringColumn, columnWidth, count, count, filter, first, inRange, interpolate, isMissing, isNotMissing, last, map, map, mapInto, max, max, min, min, name, noneMatch, print, reduce, reduce, rolling, sampleN, sampleX, set, set, setMissingTo, setName, sorted, title, type

Methods inherited from interface java.lang.Iterable
forEach, spliterator

Methods inherited from interface java.util.Comparator
comparing, comparing, comparingDouble, comparingInt, comparingLong, equals, naturalOrder, nullsFirst, nullsLast, reversed, reverseOrder, thenComparing, thenComparing, thenComparing, thenComparingDouble, thenComparingInt, thenComparingLong

Methods inherited from interface tech.tablesaw.columns.datetimes.DateTimeFilters
isAfter, isAfter, isAfter, isAfterNoon, isBefore, isBefore, isBefore, isBeforeNoon, isBetweenExcluding, isBetweenIncluding, isEqualTo, isEqualTo, isFirstDayOfMonth, isFriday, isInApril, isInAugust, isInDecember, isInFebruary, isInJanuary, isInJuly, isInJune, isInMarch, isInMay, isInNovember, isInOctober, isInQ1, isInQ2, isInQ3, isInQ4, isInSeptember, isInYear, isLastDayOfMonth, isMidnight, isMissing, isMonday, isNoon, isNotEqualTo, isNotEqualTo, isNotMissing, isOnOrAfter, isOnOrAfter, isOnOrAfter, isOnOrBefore, isOnOrBefore, isOnOrBefore, isSaturday, isSunday, isThursday, isTuesday, isWednesday

Methods inherited from interface tech.tablesaw.columns.temporal.TemporalFilters
eval, eval, eval, eval, eval, isAfter, isBefore, isBetweenExcluding, isBetweenIncluding, isEqualTo

Methods inherited from interface tech.tablesaw.api.CategoricalColumn
countByCategory

- Method Detail
  - create
```
public static DateTimeColumn create(String name)
```
  - create
```
public static DateTimeColumn create(String name,
                                    int initialSize)
```
  - create
```
public static DateTimeColumn create(String name,
                                    List<LocalDateTime> data)
```
  - create
```
public static DateTimeColumn create(String name,
                                    Stream<LocalDateTime> stream)
```
  - plus
```
public DateTimeColumn plus(long amountToAdd,
                           ChronoUnit unit)
```
    Specified by:
    
    plus in interface DateTimeMapFunctions
    
    Specified by:
    
    plus in interface TemporalMapFunctions<LocalDateTime>
  - create
```
public static DateTimeColumn create(String name,
                                    LocalDateTime[] data)
```
  - valueIsMissing
```
public static boolean valueIsMissing(long value)
```
  - isMissing
```
public boolean isMissing(int rowNumber)
```
    Specified by:
    
    isMissing in interface Column<LocalDateTime>
  - subset
```
public DateTimeColumn subset(int[] rows)
```
    Specified by:
    
    subset in interface Column<LocalDateTime>
    
    Overrides:
    
    subset in class AbstractColumn<DateTimeColumn,LocalDateTime>
  - removeMissing
```
public DateTimeColumn removeMissing()
```
    Specified by:
    
    removeMissing in interface Column<LocalDateTime>
  - contains
```
public boolean contains(LocalDateTime dateTime)
```
    Description copied from interface: Column
    
    Returns true if the given object appears in this column, and false otherwise
    TODO override in column subtypes for performance
    
    Specified by:
    
    contains in interface Column<LocalDateTime>
  - setMissing
```
public Column<LocalDateTime> setMissing(int i)
```
    Specified by:
    
    setMissing in interface Column<LocalDateTime>
  - where
```
public DateTimeColumn where(Selection selection)
```
    Specified by:
    
    where in interface Column<LocalDateTime>
  - setPrintFormatter
```
public void setPrintFormatter(DateTimeFormatter dateTimeFormatter,
                              String missingValueString)
```
  - setPrintFormatter
```
public void setPrintFormatter(DateTimeFormatter dateTimeFormatter)
```
  - setPrintFormatter
```
public void setPrintFormatter(DateTimeColumnFormatter formatter)
```
  - lag
```
public DateTimeColumn lag(int n)
```
    Description copied from interface: Column
    
    Returns a column of the same type and size as the receiver, containing the receivers values offset by n.
    For example if you lag a column containing 2, 3, 4 by 1, you get a column containing NA, 2, 3
    
    Specified by:
    
    lag in interface Column<LocalDateTime>
    
    Specified by:
    
    lag in interface DateTimeMapFunctions
  - appendCell
```
public DateTimeColumn appendCell(String stringValue)
```
    Specified by:
    
    appendCell in interface Column<LocalDateTime>
  - appendCell
```
public DateTimeColumn appendCell(String stringValue,
                                 AbstractColumnParser<?> parser)
```
    Specified by:
    
    appendCell in interface Column<LocalDateTime>
  - append
```
public DateTimeColumn append(LocalDateTime dateTime)
```
    Specified by:
    
    append in interface Column<LocalDateTime>
  - appendObj
```
public DateTimeColumn appendObj(Object obj)
```
    Specified by:
    
    appendObj in interface Column<LocalDateTime>
  - size
```
public int size()
```
    Specified by:
    
    size in interface Column<LocalDateTime>
    
    Specified by:
    
    size in interface TemporalFilters<LocalDateTime>
  - data
```
@Deprecated
public it.unimi.dsi.fastutil.longs.LongArrayList data()
```
    Deprecated. Please use the longIterator() or getLongInternal() methods
  - appendInternal
```
public DateTimeColumn appendInternal(long dateTime)
```
    Specified by:
    
    appendInternal in interface TemporalColumn<LocalDateTime>
  - getString
```
public String getString(int row)
```
    Description copied from interface: Column
    
    Returns a string representation of the value at the given row.
    
    Specified by:
    
    getString in interface Column<LocalDateTime>
    
    Parameters:
    
    row - The index of the row.
    
    Returns:
    
    value as String
  - getUnformattedString
```
public String getUnformattedString(int row)
```
    Specified by:
    
    getUnformattedString in interface Column<LocalDateTime>
  - emptyCopy
```
public DateTimeColumn emptyCopy()
```
    Description copied from interface: Column
    
    Returns a copy of the receiver with no data. The column name and type are the same.
    
    Specified by:
    
    emptyCopy in interface Column<LocalDateTime>
    
    Specified by:
    
    emptyCopy in interface TemporalMapFunctions<LocalDateTime>
    
    Specified by:
    
    emptyCopy in class AbstractColumn<DateTimeColumn,LocalDateTime>
    
    Returns:
    
    a empty copy of Column
  - emptyCopy
```
public DateTimeColumn emptyCopy(int rowSize)
```
    Description copied from interface: Column
    
    Returns an empty copy of the receiver, with its internal storage initialized to the given row size.
    
    Specified by:
    
    emptyCopy in interface Column<LocalDateTime>
    
    Parameters:
    
    rowSize - the initial row size
    
    Returns:
    
    a Column
  - copy
```
public DateTimeColumn copy()
```
    Description copied from interface: Column
    
    Returns a deep copy of the receiver
    
    Specified by:
    
    copy in interface Column<LocalDateTime>
    
    Returns:
    
    a Column
  - clear
```
public void clear()
```
    Specified by:
    
    clear in interface Column<LocalDateTime>
  - sortAscending
```
public void sortAscending()
```
    Specified by:
    
    sortAscending in interface Column<LocalDateTime>
  - sortDescending
```
public void sortDescending()
```
    Specified by:
    
    sortDescending in interface Column<LocalDateTime>
  - summary
```
public Table summary()
```
    Specified by:
    
    summary in interface Column<LocalDateTime>
  - countUnique
```
public int countUnique()
```
    Description copied from interface: Column
    
    Returns the count of unique values in this column.
    
    Specified by:
    
    countUnique in interface Column<LocalDateTime>
    
    Returns:
    
    unique values as int
  - unique
```
public DateTimeColumn unique()
```
    Description copied from interface: Column
    
    Returns a column of the same type as the receiver, containing only the unique values of the receiver.
    
    Specified by:
    
    unique in interface Column<LocalDateTime>
    
    Returns:
    
    a Column
  - isEmpty
```
public boolean isEmpty()
```
    Description copied from interface: Column
    
    Returns true if the column has no data
    
    Specified by:
    
    isEmpty in interface Column<LocalDateTime>
    
    Returns:
    
    true if empty, false if not
  - getLongInternal
```
public long getLongInternal(int index)
```
    Specified by:
    
    getLongInternal in interface TemporalColumn<LocalDateTime>
    
    Specified by:
    
    getLongInternal in interface TemporalFilters<LocalDateTime>
  - getPackedDateTime
```
protected long getPackedDateTime(int index)
```
  - get
```
public LocalDateTime get(int index)
```
    Specified by:
    
    get in interface Column<LocalDateTime>
    
    Specified by:
    
    get in interface TemporalColumn<LocalDateTime>
    
    Specified by:
    
    get in interface TemporalFilters<LocalDateTime>
  - rowComparator
```
public it.unimi.dsi.fastutil.ints.IntComparator rowComparator()
```
    Specified by:
    
    rowComparator in interface Column<LocalDateTime>
  - set
```
public DateTimeColumn set(Selection rowSelection,
                          LocalDateTime newValue)
```
    Conditionally update this column, replacing current values with newValue for all rows where the current value matches the selection criteria
    Example: myColumn.set(myColumn.valueIsMissing(), LocalDateTime.now()); // no more missing values
    
    Specified by:
    
    set in interface Column<LocalDateTime>
    
    Overrides:
    
    set in class AbstractColumn<DateTimeColumn,LocalDateTime>
  - countMissing
```
public int countMissing()
```
    Returns the count of missing values in this column
    
    Specified by:
    
    countMissing in interface Column<LocalDateTime>
    
    Returns:
    
    missing values as int
  - asEpochSecondArray
```
public long[] asEpochSecondArray()
```
    Returns an array where each entry is the difference, measured in seconds, between the LocalDateTime and midnight, January 1, 1970 UTC.
    If a value is missing, DateTimeColumnType.missingValueIndicator() is used
  - asEpochSecondArray
```
public long[] asEpochSecondArray(ZoneOffset offset)
```
    Returns the seconds from epoch for each value as an array based on the given offset
    If a value is missing, DateTimeColumnType.missingValueIndicator() is used
  - asEpochMillisArray
```
public long[] asEpochMillisArray()
```
    Returns an array where each entry is the difference, measured in milliseconds, between the LocalDateTime and midnight, January 1, 1970 UTC.
    If a missing value is encountered, DateTimeColumnType.missingValueIndicator() is inserted in the array
  - asEpochMillisArray
```
public long[] asEpochMillisArray(ZoneOffset offset)
```
    Returns an array where each entry is the difference, measured in milliseconds, between the LocalDateTime and midnight, January 1, 1970 UTC.
    If a missing value is encountered, DateTimeColumnType.missingValueIndicator() is inserted in the array
  - asInstantColumn
```
public InstantColumn asInstantColumn()
```
  - asInstantColumn
```
public InstantColumn asInstantColumn(ZoneId zone)
```
  - append
```
public DateTimeColumn append(Column<LocalDateTime> column)
```
    Specified by:
    
    append in interface Column<LocalDateTime>
  - append
```
public DateTimeColumn append(Column<LocalDateTime> column,
                             int row)
```
    Specified by:
    
    append in interface Column<LocalDateTime>
  - set
```
public DateTimeColumn set(int row,
                          Column<LocalDateTime> column,
                          int sourceRow)
```
    Specified by:
    
    set in interface Column<LocalDateTime>
  - max
```
public LocalDateTime max()
```
  - appendMissing
```
public DateTimeColumn appendMissing()
```
    Description copied from interface: Column
    
    Appends a missing value appropriate to the column
    
    Specified by:
    
    appendMissing in interface Column<LocalDateTime>
  - min
```
public LocalDateTime min()
```
    Specified by:
    
    min in interface TemporalMapFunctions<LocalDateTime>
  - set
```
public DateTimeColumn set(int index,
                          long value)
```
  - set
```
public DateTimeColumn set(int index,
                          LocalDateTime value)
```
    Specified by:
    
    set in interface Column<LocalDateTime>
  - top
```
public List<LocalDateTime> top(int n)
```
    Returns the largest ("top") n values in the column
    
    Parameters:
    
    n - The maximum number of records to return. The actual number will be smaller if n is greater than the number of observations in the column
    
    Returns:
    
    A list, possibly empty, of the largest observations
  - bottom
```
public List<LocalDateTime> bottom(int n)
```
    Returns the smallest ("bottom") n values in the column
    
    Parameters:
    
    n - The maximum number of records to return. The actual number will be smaller if n is greater than the number of observations in the column
    
    Returns:
    
    A list, possibly empty, of the smallest n observations
  - longIterator
```
public it.unimi.dsi.fastutil.longs.LongIterator longIterator()
```
  - asSet
```
public Set<LocalDateTime> asSet()
```
  - byteSize
```
public int byteSize()
```
    Description copied from interface: Column
    
    Returns the width of a cell in this column, in bytes.
    
    Specified by:
    
    byteSize in interface Column<LocalDateTime>
    
    Returns:
    
    width in bytes
  - asBytes
```
public byte[] asBytes(int rowNumber)
```
    Returns the contents of the cell at rowNumber as a byte[]
    
    Specified by:
    
    asBytes in interface Column<LocalDateTime>
    
    Parameters:
    
    rowNumber - index of the row
    
    Returns:
    
    content as byte[]
  - getDouble
```
public double getDouble(int i)
```
  - asDoubleArray
```
public double[] asDoubleArray()
```
  - asDoubleColumn
```
public DoubleColumn asDoubleColumn()
```
  - iterator
```
public Iterator<LocalDateTime> iterator()
```
    Returns an iterator over elements of type T.
    
    Specified by:
    
    iterator in interface Iterable<LocalDateTime>
    
    Returns:
    
    an Iterator.
  - fillWith
```
public DateTimeColumn fillWith(Iterator<LocalDateTime> iterator)
```
    Specified by:
    
    fillWith in interface TemporalFillers<LocalDateTime,DateTimeColumn>
  - fillWith
```
public DateTimeColumn fillWith(Iterable<LocalDateTime> iterable)
```
    Specified by:
    
    fillWith in interface TemporalFillers<LocalDateTime,DateTimeColumn>
  - fillWith
```
public DateTimeColumn fillWith(Supplier<LocalDateTime> supplier)
```
    Specified by:
    
    fillWith in interface TemporalFillers<LocalDateTime,DateTimeColumn>
  - asObjectArray
```
public LocalDateTime[] asObjectArray()
```
    Specified by:
    
    asObjectArray in interface Column<LocalDateTime>
  - compare
```
public int compare(LocalDateTime o1,
                   LocalDateTime o2)
```
    Specified by:
    
    compare in interface Comparator<LocalDateTime>

Class DateTimeColumn

Field Summary

Fields inherited from class tech.tablesaw.columns.AbstractColumn

Method Summary

Methods inherited from class tech.tablesaw.columns.AbstractColumn

Methods inherited from class java.lang.Object

Methods inherited from interface tech.tablesaw.columns.datetimes.DateTimeMapFunctions

Methods inherited from interface tech.tablesaw.columns.temporal.TemporalMapFunctions

Methods inherited from interface tech.tablesaw.columns.Column

Methods inherited from interface java.lang.Iterable

Methods inherited from interface java.util.Comparator

Methods inherited from interface tech.tablesaw.columns.datetimes.DateTimeFilters

Methods inherited from interface tech.tablesaw.columns.temporal.TemporalFilters

Methods inherited from interface tech.tablesaw.api.CategoricalColumn

Method Detail

create

create

create

create

plus

create

valueIsMissing

isMissing

subset

removeMissing

contains

setMissing

where

setPrintFormatter

setPrintFormatter

setPrintFormatter

lag

appendCell

appendCell

append

appendObj

size

data

appendInternal

getString

getUnformattedString

emptyCopy

emptyCopy

copy

clear

sortAscending

sortDescending

summary

countUnique

unique

isEmpty

getLongInternal

getPackedDateTime

get

rowComparator

set

countMissing

asEpochSecondArray

asEpochSecondArray

asEpochMillisArray

asEpochMillisArray

asInstantColumn

asInstantColumn

append

append

set

max

appendMissing

min

set

set

top

bottom

longIterator

asSet

byteSize

asBytes

getDouble

asDoubleArray

asDoubleColumn