This is the data-table Reference Manual, version 0.1, generated automatically by Declt version 4.0 beta 2 "William Riker" on Mon Feb 26 16:12:27 2024 GMT+0.
The main system appears first, followed by any subsystem dependency.
data-tableA library providing a data-table class, and useful functionality around this
BSD
0.1
iterate (system).
symbol-munger (system).
alexandria (system).
cl-interpol (system).
data-table.lisp (file).
Files are sorted by type and then listed depth-first from the systems components trees.
data-table/data-table.lispdata-table (system).
*guessing-types-sample-size* (special variable).
add-column (function).
alists-to-data-table (function).
bad-type-guess (condition).
coerce-data-table-of-strings-to-types (function).
coerce-data-table-values-for-output (function).
coerce-data-table-values-for-output! (function).
coerce-value-for-output (method).
column-index (function).
column-name (function).
(setf column-name) (function).
column-names (reader method).
(setf column-names) (writer method).
column-type (function).
(setf column-type) (function).
column-types (reader method).
(setf column-types) (writer method).
data-table (class).
data-table-data-compare (method).
data-table-to-alists (function).
data-table-to-plists (function).
data-table-value (method).
(setf data-table-value) (method).
fill-in-missing-cells (method).
make-sub-table (method).
number-of-columns (method).
number-of-rows (method).
overlay-region (method).
plists-to-data-table (function).
print-object (method).
rows (reader method).
(setf rows) (writer method).
select-columns (function).
symbolize-column-names (method).
symbolize-column-names! (method).
%add-column-heading/type (function).
%insert-value-in-list (function).
*list-delimiter* (special variable).
+common-white-space-trimbag+ (special variable).
+largest-number+ (special variable).
alist-keys (function).
alist-values (function).
assign-types-to-column (function).
data-table-coerce (method).
ensure-column-data-types (function).
expected-type (reader method).
guess-types-for-data-table (function).
maybe-apply (function).
original-error (reader method).
plist-keys (function).
plist-values (function).
relaxed-parse-float (method).
sample-rows (function).
simplify-types (function).
transpose-lists (function).
trim-and-nullify (function).
trim-whitespace (function).
value (reader method).
Packages are listed by definition order.
data-tablecommon-lisp.
common-lisp-user.
iterate.
*guessing-types-sample-size* (special variable).
add-column (function).
alists-to-data-table (function).
bad-type-guess (condition).
coerce-data-table-of-strings-to-types (function).
coerce-data-table-values-for-output (function).
coerce-data-table-values-for-output! (function).
coerce-value-for-output (generic function).
column-index (function).
column-name (function).
(setf column-name) (function).
column-names (generic reader).
(setf column-names) (generic writer).
column-type (function).
(setf column-type) (function).
column-types (generic reader).
(setf column-types) (generic writer).
data-table (class).
data-table-data-compare (generic function).
data-table-to-alists (function).
data-table-to-plists (function).
data-table-value (generic function).
(setf data-table-value) (generic function).
fill-in-missing-cells (generic function).
make-sub-table (generic function).
number-of-columns (generic function).
number-of-rows (generic function).
overlay-region (generic function).
plists-to-data-table (function).
rows (generic reader).
(setf rows) (generic writer).
select-columns (function).
symbolize-column-names (generic function).
symbolize-column-names! (generic function).
%add-column-heading/type (function).
%insert-value-in-list (function).
*list-delimiter* (special variable).
+common-white-space-trimbag+ (special variable).
+largest-number+ (special variable).
alist-keys (function).
alist-values (function).
assign-types-to-column (function).
data-table-coerce (generic function).
ensure-column-data-types (function).
expected-type (generic reader).
guess-types-for-data-table (function).
maybe-apply (function).
original-error (generic reader).
plist-keys (function).
plist-values (function).
relaxed-parse-float (generic function).
sample-rows (function).
simplify-types (function).
transpose-lists (function).
trim-and-nullify (function).
trim-whitespace (function).
value (generic reader).
Definitions are sorted by export status, category, package, and then by lexicographic order.
how many rows to look at when trying to guess the types for each column of a data table
Adds a new column to the data table passed in
given a list of alists, (all with the same keys) convert them to a data-table
Figure out what the data-table-types should be then convert all the data in the table to those types
Coerce for output all the values in all the rows and return the new rows
Coerce for output all the values in all the rows and save the result to the rows slot
returns a new data table with only the columns requested, by name
data-table) column-name val output-type) ¶Coerce a data-tables-value to a specified output format.
By default only strings are supported. This method is intended to be extended in
other applications to allow mutating to html / csv / etc
data-table)) ¶automatically generated reader method
data-table)) ¶automatically generated writer method
data-table)) ¶automatically generated reader method
data-table)) ¶automatically generated writer method
tries to comapre the data in two data-tables
data-table) &key col-name col-idx row-idx row) ¶Extract a value or set of values from the data table
can be used to pull a column of data, a row of data or a specific cell of data
data-table) &key col-name row-idx col-idx) ¶Set a specific row, column or cell of the data table
data-table) &optional missing-value) ¶Ensures that the data table is square and that every column has the same number of rows and every row has the same number of columns, filling in nil to accomplish this
Make a new data table from a subset of another data-table
lci - low column index
uci - upper column index (as per subseq 1 beyond the col you want)
lri - low row index
uri - upper row index (as per subseq 1 beyond the row you want)
data-table)) ¶data-table)) ¶data-table) (dt data-table) &key row-idx col-idx) ¶puts all values from new-dt into dt starting at row-idx col-idx
data-table)) ¶automatically generated reader method
rows.
data-table)) ¶automatically generated writer method
rows.
data-table)) ¶Turn the column names of the data table into lisp symbols
data-table)) ¶Turn the column names of the data table into lisp symbols save the new column names to the data table
What we will splice lists together with in coerce-value-for-output
this is the largest number that will be considered a number for data-type purposes.
this function tries to handle their not being any current column types or names or incomplete specification but will leave us with the same (+ 1 number-of-columns) as we started with
build a new data row by splicing a value into the existing row
Given a list of values ‘column-values’, return a unique list of types present in that list.
Given missing data types or data-types only of strings, figure out
what the data-types for the table should be set the slot on the data-table
Guess the types of each column of data in a data-table.
Call a function, when it exists
used to avoid calling clsql code if it does not exits
get a subset of the rows using reservior sampling
try to get simple type definitions from complex ones
Transpose a matrix represented as a list of lists.
Example: (transpose ’((a b c) (d e f))) => ((a d) (b e) (c f)).
trims the whitespace from a string returning nil
if trimming produces an empty string or the string ’nil’
bad-type-guess)) ¶bad-type-guess)) ¶trys to read a value we hope to be a floating point number returns nil on failure
The goal is to allow reading strings with spaces commas and dollar signs in them correctly
bad-type-guess)) ¶| Jump to: | %
(
A C D E F G M N O P R S T V |
|---|
| Jump to: | %
(
A C D E F G M N O P R S T V |
|---|
| Jump to: | *
+
C E O R S V |
|---|
| Jump to: | *
+
C E O R S V |
|---|
| Jump to: | B C D F P S |
|---|
| Jump to: | B C D F P S |
|---|