parsemixed
Purpose
Parse numerical and text data into a DataSet Object.
Synopsis
data = parsemixed(a,b)
Description
Given two inputs containing a numerical array a and a matching cell array
containing text b,
PARSEMIXED outputs a DataSet object with a "logical" interpretation
of the numerical and text data. It identifies contiguous block of numbers and
then attempts to interpret text as labels and label names for that block of
data.
INPUTS:
a
= numerical array containing the numerical portion of the data to
parse (NOTE: NaN's are OK).
b
= a cell array of the same size as (a) but containing any strings which
were not interpretable as numbers.
OUTPUT:
data = a DataSet object formed from the parsing of
the input data.
Options
options = a structure
array with the following fields:
labelcols: [] specifies one or more columns of the file which
should be interpreted as text labels for rows even if parsable as numbers,
labelrows: [] specifies one or more rows of the file which
should be interpreted as text labels for columns even if parsable as numbers,
includecols: [] Specifies one or more
columns of the file which should be interpreted as the
"include" field for ROWS of the matrix (i.e. this column
specifies which rows should be included). Multiple items in this list
will be combined using a logical "and" (all must be
"1" to include field.
includerows: [] Specifies one or more
rows of the file which should be interpreted as the "include"
field for COLUMNS of the matrix (see above notes about includecols).
classcols: [] Specifies one or more
columns of the file which should be interpreted as classes for rows of
the data.
classrows: [] Specifies one or more
rows of the file which should be interpreted as classes for columns of
the data.
axisscalecols: [] Specifies one or more
columns of the file which should be interpreted as axisscales for rows
of the data.
axisscalerows: [] Specifies one or more
rows of the file which should be interpreted as axisscales for columns
of the data.
compactdata:
[ 'no' | {'yes'} ]
Specifies if columns and rows which are entirely excluded should be
permanently removed from the table.
waitbar: [
'off' | {'on'} ] Specifies whether waitbars should be shown while
the data is being processed.
See Also
areadr, dataset, xclreadr, xlsreadr
