Tabular Output File
An abstraction for writing rows of tabular data. Columns of the tabular data can be of numeric or text. Using this subclass of TabularFile users can write rows of data. The user is responsible for filling rows with data of the appropriate type for the column and writing the row to the file.
Use the static methods of TabularFile to create and define the columns of the file. Use the methods of this class to write rows. After writing the rows, it is important to call the flushRows() method to ensure that all buffered rows are committed to the file.
Parameters
a map that defines the column names and their data types
the path to the file for writing the data
See also
For example code
Properties
Allows the user to configure the size of the batch writing if performance becomes an issue. This may or may not provide any benefit. The static methods related to this functionality can be used to recommend a reasonable batch size.
Functions
Transforms the file into an SQLite database file
Converts the columns and rows to a Dataframe.
Opens the file as a TabularInputFile
Returns the column index associated with the storage index
Returns the column index associated with the storage index
Returns the storage index of the numeric column at column index
Provides a row that can be used to set individual columns before writing the row to the file
Returns the storage index of the text column at column index
A convenience method. This writes the values in the array to the numeric columns in the file in the order of their appearance. Any text columns will have the value null and cannot be unwritten.
Writes the data represented by the TabularData instance to the file. The operation cannot be undone.
Writes the data currently in the row to the file. Once written, the operation cannot be undone.
A convenience method if the user has a list of rows to write. All rows in the list are written to the file.