Package org.meteoinfo.data

Class TimeTableData

java.lang.Object

org.meteoinfo.table.DataTable

org.meteoinfo.data.TableData

org.meteoinfo.data.TimeTableData

public class TimeTableData
extends TableData

Field Summary

Fields inherited from class org.meteoinfo.table.DataTable

columns, nextRowIndex, readOnly, rows, tableName, tag

Fields inherited from class org.meteoinfo.data.TableData

missingValue

Constructor Summary

Constructors

Constructor	Description
TimeTableData()	Constructor
TimeTableData(DataTable dataTable, java.lang.String timeColName)	Constructor

Method Summary

Modifier and Type	Method	Description
DataTable	ave_Day(java.util.List<DataColumn> cols)	Average daily
DataTable	ave_DayOfWeek(java.util.List<DataColumn> cols)	Average by day of week
DataTable	ave_Hour(java.util.List<DataColumn> cols)	Average Hourly
DataTable	ave_HourOfDay(java.util.List<DataColumn> cols)	Average by hour of day
DataTable	ave_Month(java.util.List<DataColumn> cols)	Average month by month
DataTable	ave_MonthOfYear(java.util.List<DataColumn> cols)	Average monthly
DataTable	ave_SeasonOfYear(java.util.List<DataColumn> cols)	Average seasonal
DataTable	ave_Year(java.util.List<DataColumn> cols)	Average year by year
DataTable	ave_Year(java.util.List<DataColumn> cols, int year)	Average year
DataTable	ave_YearMonth(java.util.List<DataColumn> cols, int month)	Average month by year
java.util.List<DataRow>	getDataByDate(int year, int month, int day)	Get data row list by date
java.util.List<DataRow>	getDataByDate(int year, int month, int day, int hour)	Get data row list by date
java.util.List<DataRow>	getDataByDate(java.util.Date date, java.util.List<DataRow> drs)	Get data row list by date
java.util.List<DataRow>	getDataByDate_Hour(java.util.Date date, java.util.List<DataRow> drs)	Get data row list by date - hour
java.util.List<DataRow>	getDataByDayOfWeek(int dow)	Get data row list by day of week
java.util.List<DataRow>	getDataByHour(int hour)	Get data row list by hour
java.util.List<DataRow>	getDataByMonth(int month)	Get data row list by month
java.util.List<DataRow>	getDataBySeason(java.lang.String season)	Get data row list by year
java.util.List<DataRow>	getDataByYear(int year)	Get data row list by year
java.util.List<DataRow>	getDataByYearMonth(int year, int month)	Get data row list by year and month
java.util.List<DataRow>	getDataByYearMonth(java.lang.String yearMonth)	Get data row list by year and month
static java.util.List<java.util.Date>	getDateList(java.util.Date stdate, java.util.Date enddate, java.lang.String tdtype, int timeDelt)	Get date list - String
java.util.List<java.util.Date>	getDates_Day()	Get days
java.util.List<java.util.Date>	getDates_Hour()	Get date hours
java.lang.String	getTimeColName()	Get time column name
int	getTimeIndex(java.util.Date t)	Get time index
java.util.List<java.lang.Integer>	getTimeIndex(java.util.Date st, java.util.Date et, int step)	Get time index
java.util.List<java.lang.Integer>	getTimeIndex(java.util.List<java.util.Date> ts)	Get time index list
int	getTimeIndex_Ex(java.util.Date t)	Get time index
java.util.List<java.lang.String>	getYearMonths()	Get year months
java.util.List<java.lang.Integer>	getYears()	Get years
void	readASCIIFile(java.lang.String fileName, int timeColIdx, java.lang.String formatStr)	Read data table from ASCII file
void	readASCIIFile(java.lang.String fileName, int timeColIdx, java.lang.String formatStr, java.util.List<DataColumn> dataColumns)	Read data table from ASCII file
void	setTimeColName(java.lang.String value)	Set time column name
DataTable	sum_Day(java.util.List<DataColumn> cols)	Summary daily
DataTable	sum_DayOfWeek(java.util.List<DataColumn> cols)	Summary by day of week
DataTable	sum_Hour(java.util.List<DataColumn> cols)	Summary Hourly
DataTable	sum_HourOfDay(java.util.List<DataColumn> cols)	Summary by hour of day
DataTable	sum_Month(java.util.List<DataColumn> cols)	Summary month by month
DataTable	sum_MonthOfYear(java.util.List<DataColumn> cols)	Summary month of year
DataTable	sum_SeasonOfYear(java.util.List<DataColumn> cols)	Summary seasonal
DataTable	sum_Year(java.util.List<DataColumn> cols)	Average year by year
DataTable	sum_YearMonth(java.util.List<DataColumn> cols, int month)	Sum month by year
TimeTableData	timeOrder(java.util.Date stdate, java.util.Date enddate, java.lang.String tdtype, int timeDelt)	Time order for data

Methods inherited from class org.meteoinfo.table.DataTable

addColumn, addColumn, addColumn, addColumn, addColumnData, addColumnData, addColumnData, addRow, addRow, addRows, appendRow, avg, avg, cloneTable_Field, colSelect, findColumn, findColumns, findColumns_Index, getColumnCount, getColumnData, getColumnData, getColumnData, getColumnNames, getColumns, getRowCount, getRows, getRows, getRows, getTableName, getTag, getTotalCount, getValue, getValue, hasTimeColumn, head, isReadOnly, join, join, join, max, max, min, min, newRow, removeColumn, removeJoin, removeRow, removeRow, removeRows, renameColumn, renameColumn, renameColumn, saveAsASCIIFile, saveAsASCIIFile, saveAsASCIIFile_format, saveAsCSVFile, saveAsCSVFile, select, select, select, select, select, select, select, select, select, select, select, select, setColumnData, setReadOnly, setRows, setTableName, setTag, setValue, setValue, setValues, tail, toString, toString, toString, toString

Methods inherited from class java.lang.Object

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

Methods inherited from class org.meteoinfo.data.TableData

addColumnData, addColumnData, ave_DayOfWeek, ave_HourOfDay, ave_Month, ave_MonthOfYear, ave_SeasonOfYear, ave_stdev, ave_Year, average, clone, columnToDouble, getDataByDayOfWeek, getDataByHour, getDataByMonth, getDataBySeason, getDataByYear, getDataByYearMonth, getDataByYearMonth, getDataColumns, getMissingValue, getRow, getValidColumnValues, getValidColumnValues, getYearMonths, getYears, join, join, readASCIIFile, readASCIIFile, readASCIIFile, readASCIIFile, removeColumn, setColumnData, setMissingValue, sqlSelect, statistics, statistics, sum, toSingleRowTable, toSingleRowTable, toSingleRowTable

Constructor Detail

TimeTableData

public TimeTableData()

Constructor

TimeTableData

public TimeTableData(DataTable dataTable,
                     java.lang.String timeColName)

Constructor

Parameters:

dataTable - Data table

timeColName - Time column name

Method Detail

getTimeColName

public java.lang.String getTimeColName()

Get time column name

Overrides:

getTimeColName in class TableData

Returns:

Time column name

setTimeColName

public void setTimeColName(java.lang.String value)

Set time column name

Parameters:

value - Time column name

readASCIIFile

public void readASCIIFile(java.lang.String fileName,
                          int timeColIdx,
                          java.lang.String formatStr,
                          java.util.List<DataColumn> dataColumns)
                   throws java.io.FileNotFoundException,
                          java.io.IOException,
                          java.lang.Exception

Read data table from ASCII file

Parameters:

fileName - File name

timeColIdx - Time column index

formatStr - Time format string

dataColumns - Data columns

Throws:

java.io.FileNotFoundException

java.io.IOException

java.lang.Exception

readASCIIFile

public void readASCIIFile(java.lang.String fileName,
                          int timeColIdx,
                          java.lang.String formatStr)
                   throws java.io.FileNotFoundException,
                          java.io.IOException,
                          java.lang.Exception

Read data table from ASCII file

Parameters:

fileName - File name

timeColIdx - Time column index

formatStr - Time format string

Throws:

java.io.FileNotFoundException

java.io.IOException

java.lang.Exception

getTimeIndex_Ex

public int getTimeIndex_Ex(java.util.Date t)

Get time index

Parameters:

t - Time

Returns:

Index

getTimeIndex

public int getTimeIndex(java.util.Date t)

Get time index

Parameters:

t - Time

Returns:

Index

getTimeIndex

public java.util.List<java.lang.Integer> getTimeIndex(java.util.List<java.util.Date> ts)

Get time index list

Parameters:

ts - Times

Returns:

Index list

getTimeIndex

public java.util.List<java.lang.Integer> getTimeIndex(java.util.Date st,
                                                      java.util.Date et,
                                                      int step)

Get time index

Parameters:

st - Start time

et - End time

step - Step

Returns:

Time index

getYears

public java.util.List<java.lang.Integer> getYears()

Get years

Returns:

Year list

getYearMonths

public java.util.List<java.lang.String> getYearMonths()

Get year months

Returns:

Year month list

getDates_Day

public java.util.List<java.util.Date> getDates_Day()

Get days

Returns:

Date list

getDates_Hour

public java.util.List<java.util.Date> getDates_Hour()

Get date hours

Returns:

Date list

getDataByYear

public java.util.List<DataRow> getDataByYear(int year)

Get data row list by year

Parameters:

year - The year

Returns:

Data row list

getDataBySeason

public java.util.List<DataRow> getDataBySeason(java.lang.String season)

Get data row list by year

Parameters:

season - The season

Returns:

Data row list

getDataByYearMonth

public java.util.List<DataRow> getDataByYearMonth(java.lang.String yearMonth)

Get data row list by year and month

Parameters:

yearMonth - The year and month

Returns:

Data row list

getDataByYearMonth

public java.util.List<DataRow> getDataByYearMonth(int year,
                                                  int month)

Get data row list by year and month

Parameters:

year - The year

month - The month

Returns:

Data row list

getDataByDate

public java.util.List<DataRow> getDataByDate(java.util.Date date,
                                             java.util.List<DataRow> drs)

Get data row list by date

Parameters:

date - Date string

drs - Data rows

Returns:

Data row list

getDataByDate_Hour

public java.util.List<DataRow> getDataByDate_Hour(java.util.Date date,
                                                  java.util.List<DataRow> drs)

Get data row list by date - hour

Parameters:

date - Date string

drs - Data rows

Returns:

Data row list

getDataByDate

public java.util.List<DataRow> getDataByDate(int year,
                                             int month,
                                             int day)

Get data row list by date

Parameters:

year - The year

month - The month

day - The day

Returns:

Data row list

getDataByDate

public java.util.List<DataRow> getDataByDate(int year,
                                             int month,
                                             int day,
                                             int hour)

Get data row list by date

Parameters:

year - The year

month - The month

day - The day

hour - The hour

Returns:

Data row list

getDataByMonth

public java.util.List<DataRow> getDataByMonth(int month)

Get data row list by month

Parameters:

month - The month

Returns:

Data row list

getDataByDayOfWeek

public java.util.List<DataRow> getDataByDayOfWeek(int dow)

Get data row list by day of week

Parameters:

dow - Day of week

Returns:

Data row list

getDataByHour

public java.util.List<DataRow> getDataByHour(int hour)

Get data row list by hour

Parameters:

hour - The hour

Returns:

Result data row list

ave_Year

public DataTable ave_Year(java.util.List<DataColumn> cols)
                   throws java.lang.Exception

Average year by year

Parameters:

cols - The data columns

Returns:

Result data table

Throws:

java.lang.Exception

ave_Year

public DataTable ave_Year(java.util.List<DataColumn> cols,
                          int year)
                   throws java.lang.Exception

Average year

Parameters:

cols - The data columns

year - The year

Returns:

Result data table

Throws:

java.lang.Exception

sum_Year

public DataTable sum_Year(java.util.List<DataColumn> cols)
                   throws java.lang.Exception

Average year by year

Parameters:

cols - The data columns

Returns:

Result data table

Throws:

java.lang.Exception

ave_YearMonth

public DataTable ave_YearMonth(java.util.List<DataColumn> cols,
                               int month)
                        throws java.lang.Exception

Average month by year

Parameters:

cols - The data columns

month - The month

Returns:

Result data table

Throws:

java.lang.Exception

sum_YearMonth

public DataTable sum_YearMonth(java.util.List<DataColumn> cols,
                               int month)
                        throws java.lang.Exception

Sum month by year

Parameters:

cols - The data columns

month - The month

Returns:

Result data table

Throws:

java.lang.Exception

ave_Month

public DataTable ave_Month(java.util.List<DataColumn> cols)
                    throws java.lang.Exception

Average month by month

Parameters:

cols - The data columns

Returns:

Result data table

Throws:

java.lang.Exception

sum_Month

public DataTable sum_Month(java.util.List<DataColumn> cols)
                    throws java.lang.Exception

Summary month by month

Parameters:

cols - The data columns

Returns:

Result data table

Throws:

java.lang.Exception

ave_Day

public DataTable ave_Day(java.util.List<DataColumn> cols)
                  throws java.lang.Exception

Average daily

Parameters:

cols - The data columns

Returns:

Result data table

Throws:

java.lang.Exception

sum_Day

public DataTable sum_Day(java.util.List<DataColumn> cols)
                  throws java.lang.Exception

Summary daily

Parameters:

cols - The data columns

Returns:

Result data table

Throws:

java.lang.Exception

ave_Hour

public DataTable ave_Hour(java.util.List<DataColumn> cols)
                   throws java.lang.Exception

Average Hourly

Parameters:

cols - The data columns

Returns:

Result data table

Throws:

java.lang.Exception

sum_Hour

public DataTable sum_Hour(java.util.List<DataColumn> cols)
                   throws java.lang.Exception

Summary Hourly

Parameters:

cols - The data columns

Returns:

Result data table

Throws:

java.lang.Exception

ave_MonthOfYear

public DataTable ave_MonthOfYear(java.util.List<DataColumn> cols)
                          throws java.lang.Exception

Average monthly

Parameters:

cols - The data columns

Returns:

Result data table

Throws:

java.lang.Exception

sum_MonthOfYear

public DataTable sum_MonthOfYear(java.util.List<DataColumn> cols)
                          throws java.lang.Exception

Summary month of year

Parameters:

cols - The data columns

Returns:

Result data table

Throws:

java.lang.Exception

ave_SeasonOfYear

public DataTable ave_SeasonOfYear(java.util.List<DataColumn> cols)
                           throws java.lang.Exception

Average seasonal

Parameters:

cols - The data columns

Returns:

Result data table

Throws:

java.lang.Exception

sum_SeasonOfYear

public DataTable sum_SeasonOfYear(java.util.List<DataColumn> cols)
                           throws java.lang.Exception

Summary seasonal

Parameters:

cols - The data columns

Returns:

Result data table

Throws:

java.lang.Exception

ave_DayOfWeek

public DataTable ave_DayOfWeek(java.util.List<DataColumn> cols)
                        throws java.lang.Exception

Average by day of week

Parameters:

cols - The data columns

Returns:

Result data table

Throws:

java.lang.Exception

sum_DayOfWeek

public DataTable sum_DayOfWeek(java.util.List<DataColumn> cols)
                        throws java.lang.Exception

Summary by day of week

Parameters:

cols - The data columns

Returns:

Result data table

Throws:

java.lang.Exception

ave_HourOfDay

public DataTable ave_HourOfDay(java.util.List<DataColumn> cols)
                        throws java.lang.Exception

Average by hour of day

Parameters:

cols - The data columns

Returns:

Result data table

Throws:

java.lang.Exception

sum_HourOfDay

public DataTable sum_HourOfDay(java.util.List<DataColumn> cols)
                        throws java.lang.Exception

Summary by hour of day

Parameters:

cols - The data columns

Returns:

Result data table

Throws:

java.lang.Exception

getDateList

public static java.util.List<java.util.Date> getDateList(java.util.Date stdate,
                                                         java.util.Date enddate,
                                                         java.lang.String tdtype,
                                                         int timeDelt)
                                                  throws java.io.FileNotFoundException,
                                                         java.io.IOException,
                                                         java.text.ParseException

Get date list - String

Parameters:

stdate - Start date

enddate - End date

tdtype - Calendar type

timeDelt - Time delta value

Returns:

Date list

Throws:

java.io.FileNotFoundException

java.io.IOException

java.text.ParseException

timeOrder

public TimeTableData timeOrder(java.util.Date stdate,
                               java.util.Date enddate,
                               java.lang.String tdtype,
                               int timeDelt)
                        throws java.io.IOException,
                               java.io.FileNotFoundException,
                               java.text.ParseException,
                               java.lang.Exception

Time order for data

Parameters:

stdate - Start date

enddate - End date

tdtype - Calendar type

timeDelt - Time delta

Returns:

Ordered data

Throws:

java.io.IOException

java.io.FileNotFoundException

java.text.ParseException

java.lang.Exception