Data Table (table
)¶
- class Orange.data.Table(*args, **kwargs)[source]¶
Stores data instances as a set of 2d tables representing the independent variables (attributes, features) and dependent variables (classes, targets), and the corresponding weights and meta attributes.
The data is stored in 2d numpy arrays
X
,Y
,W
,metas
. The arrays may be dense or sparse. All arrays have the same number of rows. If certain data is missing, the corresponding array has zero columns.Arrays can be of any type; default is float (that is, double precision). Values of discrete variables are stored as whole numbers. Arrays for meta attributes usually contain instances of object.
The table also stores the associated information about the variables as an instance of
Domain
. The number of columns must match the corresponding number of variables in the description.There are multiple ways to get values or entire rows of the table.
The index can be an int, e.g. table[7]; the corresponding row is returned as an instance of
RowInstance
.The index can be a slice or a sequence of ints (e.g. table[7:10] or table[[7, 42, 15]], indexing returns a new data table with the selected rows.
If there are two indices, where the first is an int (a row number) and the second can be interpreted as columns, e.g. table[3, 5] or table[3, ‘gender’] or table[3, y] (where y is an instance of
Variable
), a single value is returned as an instance ofValue
.In all other cases, the first index should be a row index, a slice or a sequence, and the second index, which represent a set of columns, should be an int, a slice, a sequence or a numpy array. The result is a new table with a new domain.
Rules for setting the data are as follows.
If there is a single index (an int, slice, or a sequence of row indices) and the value being set is a single scalar, all attributes (not including the classes) are set to that value. That is, table[r] = v is equivalent to table.X[r] = v.
If there is a single index and the value is a data instance (
Orange.data.Instance
), it is converted into the table’s domain and set to the corresponding rows.Final option for a single index is that the value is a sequence whose length equals the number of attributes and target variables. The corresponding rows are set; meta attributes are set to unknowns.
- For two indices, the row can again be given as a single int, a
slice or a sequence of indices. Column indices can be a single int, str or
Orange.data.Variable
, a sequence of them, a slice or any iterable. The value can be a single value, or a sequence of appropriate length.
- domain¶
Description of the variables corresponding to the table’s columns. The domain is used for determining the variable types, printing the data in human-readable form, conversions between data tables and similar.
- property columns¶
A class whose attributes contain attribute descriptors for columns. For a table table, setting c = table.columns will allow accessing the table’s variables with, for instance c.gender, c.age ets. Spaces are replaced with underscores.
Constructors¶
The preferred way to construct a table is to invoke a named constructor.
- classmethod Table.from_domain(domain, n_rows=0, weights=False)[source]¶
Construct a new Table with the given number of rows for the given domain. The optional vector of weights is initialized to 1’s.
- Parameters
domain (Orange.data.Domain) – domain for the Table
n_rows (int) – number of rows in the new table
weights (bool) – indicates whether to construct a vector of weights
- Returns
a new table
- Return type
- classmethod Table.from_table(domain, source, row_indices=Ellipsis)[source]¶
Create a new table from selected columns and/or rows of an existing one. The columns are chosen using a domain. The domain may also include variables that do not appear in the source table; they are computed from source variables if possible.
The resulting data may be a view or a copy of the existing data.
- Parameters
domain (Orange.data.Domain) – the domain for the new table
source (Orange.data.Table) – the source table
row_indices (a slice or a sequence) – indices of the rows to include
- Returns
a new table
- Return type
- classmethod Table.from_table_rows(source, row_indices)[source]¶
Construct a new table by selecting rows from the source table.
- Parameters
source (Orange.data.Table) – an existing table
row_indices (a slice or a sequence) – indices of the rows to include
- Returns
a new table
- Return type
- classmethod Table.from_numpy(domain, X, Y=None, metas=None, W=None, attributes=None, ids=None)[source]¶
Construct a table from numpy arrays with the given domain. The number of variables in the domain must match the number of columns in the corresponding arrays. All arrays must have the same number of rows. Arrays may be of different numpy types, and may be dense or sparse.
- Parameters
domain (Orange.data.Domain) – the domain for the new table
X (np.array) – array with attribute values
Y (np.array) – array with class values
metas (np.array) – array with meta attributes
W (np.array) – array with weights
- Returns
Inspection¶
Row manipulation¶
Note
Methods that change the table length (append, extend, insert, clear, and resizing through deleting, slicing or by other means), were deprecated and removed in Orange 3.24.