public class TextColumn extends AbstractStringColumn<TextColumn>
This is the default column type for SQL longvarchar and longnvarchar types
Because the MISSING_VALUE for this column type is an empty string, there is little or no need for special handling of missing values in this class's methods.
DEFAULT_ARRAY_SIZE
Modifier and Type | Method and Description |
---|---|
TextColumn |
addAll(List<String> stringValues)
Add all the strings in the list to this column
|
TextColumn |
append(Column<String> column) |
TextColumn |
append(String value)
Added for naming consistency with all other columns
|
TextColumn |
appendCell(String object) |
TextColumn |
appendCell(String object,
AbstractColumnParser<?> parser) |
TextColumn |
appendMissing()
Appends a missing value appropriate to the column
|
TextColumn |
appendObj(Object obj) |
byte[] |
asBytes(int rowNumber)
Returns the contents of the cell at rowNumber as a byte[]
|
List<String> |
asList()
Returns a List<String> representation of all the values in this column
|
String[] |
asObjectArray() |
Set<String> |
asSet() |
StringColumn |
asStringColumn()
Returns a StringColumn consisting of the (unformatted) String representation of this column
values
|
void |
clear() |
boolean |
contains(String aString)
Returns true if this column contains a cell with the given string, and false otherwise
|
TextColumn |
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 TextColumn |
create(String name) |
static TextColumn |
create(String name,
int size) |
static TextColumn |
create(String name,
List<String> strings) |
static TextColumn |
create(String name,
Stream<String> stream) |
static TextColumn |
create(String name,
String[] strings) |
TextColumn |
emptyCopy()
Returns a copy of the receiver with no data.
|
TextColumn |
emptyCopy(int rowSize)
Returns an empty copy of the receiver, with its internal storage initialized to the given row
size.
|
int |
firstIndexOf(String value) |
String |
get(int rowIndex)
Returns the value at rowIndex in this column.
|
boolean |
isEmpty()
Returns true if the column has no data
|
Selection |
isIn(Collection<String> strings) |
Selection |
isIn(String... strings) |
boolean |
isMissing(int rowNumber) |
Selection |
isNotIn(Collection<String> strings) |
Selection |
isNotIn(String... strings) |
Iterator<String> |
iterator() |
TextColumn |
lag(int n)
Returns a column of the same type and size as the receiver, containing the receivers values
offset by n.
|
TextColumn |
lead(int n)
Returns a column of the same type as the receiver, containing the receivers values offset -n
For example if you lead a column containing 2, 3, 4 by 1, you get a column containing 3, 4, NA.
|
TextColumn |
removeMissing() |
it.unimi.dsi.fastutil.ints.IntComparator |
rowComparator() |
TextColumn |
set(int rowIndex,
String stringValue) |
TextColumn |
set(Selection rowSelection,
String newValue)
Conditionally update this column, replacing current values with newValue for all rows where the
current value matches the selection criteria
|
Column<String> |
setMissing(int i) |
int |
size()
Returns the number of elements (a.k.a.
|
void |
sortAscending() |
void |
sortDescending() |
Table |
summary() |
TextColumn |
unique()
Returns a new Column containing all the unique values in this column
|
static boolean |
valueIsMissing(String string) |
TextColumn |
where(Selection selection) |
append, bottom, byteSize, compare, getPrintFormatter, getString, getUnformattedString, set, setPrintFormatter, top
filter, first, inRange, last, map, max, min, name, sampleN, sampleX, set, setName, sorted, subset, toString, type
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
countByCategory
containsString, endsWith, equalsIgnoreCase, equalsIgnoreCase, eval, eval, eval, eval, isAlpha, isAlphaNumeric, isEmptyString, isEqualTo, isEqualTo, isLongerThan, isLowerCase, isMissing, isNotEqualTo, isNotEqualTo, isNotMissing, isNumeric, isShorterThan, isUpperCase, lengthEquals, matchesRegex, startsWith, startsWith
abbreviate, capitalize, commonPrefix, commonSuffix, concatenate, concatenate, countTokens, distance, format, join, length, lowerCase, padEnd, padStart, parseDouble, parseFloat, parseInt, repeat, replaceAll, replaceAll, replaceFirst, substring, substring, tokenizeAndRemoveDuplicates, tokenizeAndSort, tokenizeAndSort, tokens, trim, uniqueTokens, upperCase
appendAll, appendAll
allMatch, anyMatch, columnWidth, count, count, filter, first, inRange, interpolate, last, map, map, mapInto, max, max, min, min, name, noneMatch, print, reduce, reduce, rolling, sampleN, sampleX, set, set, setMissingTo, setName, sorted, subset, title, type
forEach, spliterator
comparing, comparing, comparingDouble, comparingInt, comparingLong, equals, naturalOrder, nullsFirst, nullsLast, reversed, reverseOrder, thenComparing, thenComparing, thenComparing, thenComparingDouble, thenComparingInt, thenComparingLong
public static boolean valueIsMissing(String string)
public TextColumn appendMissing()
Column
public static TextColumn create(String name)
public static TextColumn create(String name, String[] strings)
public static TextColumn create(String name, List<String> strings)
public static TextColumn create(String name, int size)
public static TextColumn create(String name, Stream<String> stream)
public boolean isMissing(int rowNumber)
public TextColumn emptyCopy()
Column
emptyCopy
in interface Column<String>
emptyCopy
in class AbstractColumn<TextColumn,String>
Column
public TextColumn emptyCopy(int rowSize)
Column
rowSize
- the initial row sizeColumn
public void sortAscending()
public void sortDescending()
public int size()
public String get(int rowIndex)
rowIndex
- index of the rowIndexOutOfBoundsException
- if the given rowIndex is not in the columnpublic List<String> asList()
NOTE: Unless you really need a string consider using the column itself for large datasets as it uses much less memory
public Table summary()
public void clear()
public TextColumn lead(int n)
Column
public TextColumn lag(int n)
Column
For example if you lag a column containing 2, 3, 4 by 1, you get a column containing NA, 2, 3
public TextColumn set(Selection rowSelection, String newValue)
Examples: myCatColumn.set(myCatColumn.isEqualTo("Cat"), "Dog"); // no more cats myCatColumn.set(myCatColumn.valueIsMissing(), "Fox"); // no more missing values
set
in interface Column<String>
set
in class AbstractColumn<TextColumn,String>
public TextColumn set(int rowIndex, String stringValue)
public int countUnique()
Column
public boolean contains(String aString)
aString
- the value to look forpublic TextColumn addAll(List<String> stringValues)
stringValues
- a list of valuespublic TextColumn appendCell(String object)
public TextColumn appendCell(String object, AbstractColumnParser<?> parser)
public it.unimi.dsi.fastutil.ints.IntComparator rowComparator()
public boolean isEmpty()
Column
public TextColumn unique()
public TextColumn where(Selection selection)
public TextColumn copy()
Column
Column
public TextColumn append(Column<String> column)
public int countMissing()
public TextColumn removeMissing()
public byte[] asBytes(int rowNumber)
rowNumber
- index of the rowpublic TextColumn append(String value)
public TextColumn appendObj(Object obj)
public Selection isIn(Collection<String> strings)
public Selection isNotIn(Collection<String> strings)
public int firstIndexOf(String value)
public String[] asObjectArray()
public StringColumn asStringColumn()
Column
asStringColumn
in interface Column<String>
asStringColumn
in class AbstractColumn<TextColumn,String>
StringColumn
built using the column Column.getUnformattedString(int)
methodCopyright © 2020. All rights reserved.