tsdb.util

Class Table

java.lang.Object

tsdb.util.Table

Direct Known Subclasses:

HoboTable, TOA5Table

public class Table
extends java.lang.Object

Helper class to read csv files and get data as a table

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	Table.ColumnReader
static class	Table.ColumnReaderBoolean
static class	Table.ColumnReaderBooleanMissing
static class	Table.ColumnReaderBooleanYN
static class	Table.ColumnReaderDateFullHourTimestamp
static class	Table.ColumnReaderDateHourWrapMinuteTimestamp example: "2014-04-14";"23";"45";"0" example: "2014-04-14";"24";"0";"0" example: "2014-04-15";"0";"30";"0" example: "2014-04-15";"0";"15";"0" example: "2014-04-15";"0";"45";"0"
static class	Table.ColumnReaderDayFirstAmPmTimestamp
static class	Table.ColumnReaderDouble
static class	Table.ColumnReaderFloat
static class	Table.ColumnReaderFloatMissing
static class	Table.ColumnReaderInt
static class	Table.ColumnReaderIntFunc
static class	Table.ColumnReaderMonthNameTimestamp
static class	Table.ColumnReaderSlashTimestamp
static class	Table.ColumnReaderSpaceTimestamp
static class	Table.ColumnReaderString
static class	Table.ColumnReaderStringMissing
static interface	Table.ColumnReaderTimestamp
static class	Table.ColumnReaderTimestampTwoCols
static interface	Table.ReaderConstructor<T>

Field Summary

Fields

Modifier and Type	Field and Description
java.util.Map<java.lang.String,java.lang.Integer>	nameMap header name -> column position
java.lang.String[]	names header names in csv file
java.lang.String[][]	rows table rows of csv file

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	Table()

Method Summary

Modifier and Type	Method and Description
boolean	containsColumn(java.lang.String name)
Table.ColumnReaderString	createColumnReader(java.lang.String name)
Table.ColumnReaderString	createColumnReader(java.lang.String name, java.lang.String missing)
Table.ColumnReaderBoolean	createColumnReaderBooleanYN(java.lang.String name, boolean missing)
Table.ColumnReaderDateFullHourTimestamp	createColumnReaderDateFullHourTimestamp(java.lang.String colDate, java.lang.String colFullHour)
Table.ColumnReaderDateHourWrapMinuteTimestamp	createColumnReaderDateHourWrapMinuteTimestamp(java.lang.String colDate, java.lang.String colHourWrap, java.lang.String colMinute)
Table.ColumnReaderDouble	createColumnReaderDouble(java.lang.String name)
Table.ColumnReaderFloat	createColumnReaderFloat(java.lang.String name)
Table.ColumnReaderFloat	createColumnReaderFloat(java.lang.String name, float missing) Creates reader of column or producer of value "missing" if columns does not exist.
Table.ColumnReaderInt	createColumnReaderInt(java.lang.String name)
Table.ColumnReaderIntFunc	createColumnReaderInt(java.lang.String name, Table.ColumnReaderIntFunc.IntegerParser parser)
Table.ColumnReaderMonthNameTimestamp	createColumnReaderMonthNameTimestamp(java.lang.String name)
Table.ColumnReaderSlashTimestamp	createColumnReaderSlashTimestamp(java.lang.String name)
Table.ColumnReaderTimestampTwoCols	createColumnReaderTimestamp(java.lang.String colDate, java.lang.String colTime)
int	getColumnIndex(java.lang.String name) get column position of one header name
int	getColumnIndex(java.lang.String name, boolean warn) get column position of one header name
<T> T	getColumnReader(java.lang.String name, Table.ReaderConstructor<T> readerConstructor)
java.lang.String	getName(Table.ColumnReader cr)
static boolean	isComment(java.lang.String[] row) Comment line starts with '#'
static boolean	isNoComment(java.lang.String[] row) Comment line starts with '#'
static Table	readCSV(java.io.File file, char separator) create a Table Object from CSV-File
static Table	readCSV(java.nio.file.Path filename, char separator)
static Table	readCSV(java.io.Reader r, char separator)
static Table	readCSV(java.lang.String filename, char separator)
static Table	readCSVFirstDataRow(java.lang.String filename, char separator)
java.lang.String	toString()
void	updateNames(java.lang.String[] columnNames)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

names

public java.lang.String[] names

header names in csv file

nameMap

public java.util.Map<java.lang.String,java.lang.Integer> nameMap

header name -> column position

rows

public java.lang.String[][] rows

table rows of csv file

Constructor Detail

Table

protected Table()

Method Detail

readCSV

public static Table readCSV(java.nio.file.Path filename,
                            char separator)

readCSV

public static Table readCSV(java.lang.String filename,
                            char separator)

readCSV

public static Table readCSV(java.io.Reader r,
                            char separator)
                     throws java.io.IOException

Throws:

java.io.IOException

readCSV

public static Table readCSV(java.io.File file,
                            char separator)

create a Table Object from CSV-File

Parameters:

filename -

Returns:

isComment

public static boolean isComment(java.lang.String[] row)

Comment line starts with '#'

Parameters:

row -

Returns:

isNoComment

public static boolean isNoComment(java.lang.String[] row)

Comment line starts with '#'

Parameters:

row -

Returns:

updateNames

public void updateNames(java.lang.String[] columnNames)

readCSVFirstDataRow

public static Table readCSVFirstDataRow(java.lang.String filename,
                                        char separator)

getColumnIndex

public int getColumnIndex(java.lang.String name)

get column position of one header name

Parameters:

name -

Returns:

if name not found -1

getColumnIndex

public int getColumnIndex(java.lang.String name,
                          boolean warn)

get column position of one header name

Parameters:

name -

Returns:

if name not found -1

containsColumn

public boolean containsColumn(java.lang.String name)

createColumnReader

public Table.ColumnReaderString createColumnReader(java.lang.String name)

getColumnReader

public <T> T getColumnReader(java.lang.String name,
                             Table.ReaderConstructor<T> readerConstructor)

createColumnReader

public Table.ColumnReaderString createColumnReader(java.lang.String name,
                                                   java.lang.String missing)

createColumnReaderFloat

public Table.ColumnReaderFloat createColumnReaderFloat(java.lang.String name)

createColumnReaderFloat

public Table.ColumnReaderFloat createColumnReaderFloat(java.lang.String name,
                                                       float missing)

Creates reader of column or producer of value "missing" if columns does not exist.

Parameters:

name -

missing -

Returns:

createColumnReaderDouble

public Table.ColumnReaderDouble createColumnReaderDouble(java.lang.String name)

createColumnReaderInt

public Table.ColumnReaderInt createColumnReaderInt(java.lang.String name)

createColumnReaderInt

public Table.ColumnReaderIntFunc createColumnReaderInt(java.lang.String name,
                                                       Table.ColumnReaderIntFunc.IntegerParser parser)

createColumnReaderBooleanYN

public Table.ColumnReaderBoolean createColumnReaderBooleanYN(java.lang.String name,
                                                             boolean missing)

createColumnReaderTimestamp

public Table.ColumnReaderTimestampTwoCols createColumnReaderTimestamp(java.lang.String colDate,
                                                                      java.lang.String colTime)

createColumnReaderSlashTimestamp

public Table.ColumnReaderSlashTimestamp createColumnReaderSlashTimestamp(java.lang.String name)

createColumnReaderMonthNameTimestamp

public Table.ColumnReaderMonthNameTimestamp createColumnReaderMonthNameTimestamp(java.lang.String name)

createColumnReaderDateFullHourTimestamp

public Table.ColumnReaderDateFullHourTimestamp createColumnReaderDateFullHourTimestamp(java.lang.String colDate,
                                                                                       java.lang.String colFullHour)

createColumnReaderDateHourWrapMinuteTimestamp

public Table.ColumnReaderDateHourWrapMinuteTimestamp createColumnReaderDateHourWrapMinuteTimestamp(java.lang.String colDate,
                                                                                                   java.lang.String colHourWrap,
                                                                                                   java.lang.String colMinute)

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

getName

public java.lang.String getName(Table.ColumnReader cr)