emzed.table¶

the name of the new column.

either a list with the same length as table or an expression.

supported colum types are int, float, bool, MzType, RtType, str, PeakMap, Table, object. In case you want to use Python objects like lists or dicts, use column type 'object' instead.

is a format string as "%d" or an executable string with python code. To suppress visibility set format_ = None. The default not_specified is a sentinel meaning "argument not provided" and is different from None. In that case the method determines a default format for the column type.

to add column name at a defined position, one can specify its position left-wise to column insert_before via the name of an existing column, or an integer index (negative values allowed !).

to add column name at a defined position, one can specify its position right-wise to column insert_after.

new column name.

any of accepted types int, float, bool, MzType, RtType, str, PeakMap, Table.

target column type.

target column format. The default not_specified is a sentinel (different from None) and means "use the default format for type_".

insertion position for the new column.

insertion position for the new column.

name of added column. Default name is id.

to add column col_name at a defined position, one can specify its position via the name of an existing column, or an integer index (negative values allowed). setting insert_before and the insert_after at the same time is not allowed.

to add column col_name at a defined position, one can specify its position via the name of an existing column, or an integer index (negative values allowed). setting insert_before and the insert_after at the same time is not allowed.

start value for creating the ids. default value is 0.

column name to replace or create.

either a list with the same length as table or an expression.

target column type. If None and the column exists, the current column type is reused.

target column format. The default not_specified is a sentinel (different from None) and means "use the existing format or the default format for type_".

insertion position used when the column is created.

insertion position used when the column is created.

column name to replace or create.

scalar value assigned to all rows.

target column type. If None and the column exists, the current column type is reused.

target column format. The default not_specified is a sentinel (different from None) and means "use the existing format or the default format for type_".

insertion position used when the column is created.

insertion position used when the column is created.

list or tuple of values. Length must match.

Callable that receives args row-wise.

Function inputs, typically column expressions or constants.

If True, rows with None in any input produce None without calling function.

Deprecated compatibility parameter. It is currently ignored; set the target type when you add/replace the destination column.

Apply expression usable in column operations.

Column names defining grouping keys.

Name of the column that stores collapsed subtables.

Optional target database path for the result.

Collapsed emzed.Table with one nested table per group.

If specified the result will be a Table with a db file backend, else the result will be managed in memory.

Indicate if an already existing database file should be overwritten.

emzed.Table.

list or tuple of strings.

list of types.

list of formats using format specifiers like "%.2f" If not specified emzed tries to guess appropriate formats based on column type and column name.

list of lists.

table title as string.

dictionary to manage user defined meta data.

path for the db backend, default is None to use the the in-memory db backend.

emzed.Table.

column names. either exact names or names containg wild cards like ? and *.

Example: Table t with colnames id, mz, mzmin, mzmax, sample_1k1, sample_1m1, sample_1k2

t.drop_columns('mz*', 'sample_1?1')

results t with columns id, sample_1k2

table with the same columns, types, and formats.

unused legacy argument kept for API compatibility.

unused legacy argument kept for API compatibility.

list or tuple with selected, existing column names.

second table for join.

column name to consider.

column name of other to consider in case it is different to col_name.

absolute tolerance for approximate equality check.

relative tolerance for approximate equality check.

optional additional join expression that must also match for a row pair to be included.

emzed.Table.

Performance: In case other is significantly larger than self, it is recommended to swap the tables.

The apprimate equality check for two numbers a and b is:

 abs(a - b) <= atol + rtol * abs(a)

So if you only need comparison based absolute tolerance you can set rtol to 0.0, and if you only need relative tolerance check you can set atol to 0.0.

second table for join.

column name to consider.

column name of other to consider in case it is different to col_name.

absolute tolerance for approximate equlity check.

relative tolerance for approximate equlity check.

optional additional join expression that must also match for a row pair to be included.

emzed.Table.

Performance: In case other is significantly larger than self, it is recommended to swap the tables.

The apprimate equality check for two numbers a and b is:

 abs(a - b) <= atol + rtol * abs(a)

So if you only need comparison based absolute tolerance you can set rtol to 0.0, and if you only need relative tolerance check you can set atol to 0.0.

expression like t.a < 0 or t.a <= t.b.

emzed.Table with filtered rows.

pandas data frame.

list of colum names, can be used to override data frame colum names.

list of colum types, if not provided emzed determines types from column contents and names.

list of colum formats, if not provided emzed determines formats from column contents and names.

emzed.Table.

existing column name or "_index".

You can use t[name] or t.name instead.

Grouping columns, for example t.a or t["b"].

If False, rows with None in grouping columns are excluded from groups.

GroupBy helper (for example .min(...)).

Right-hand side table.

Optional join condition expression. If None, a full row-wise cross product is returned.

Optional target database path for the result.

Whether an existing path may be overwritten.

Joined emzed.Table.

Right-hand side table.

Optional join condition expression. If None, a full row-wise cross product is used.

Optional target database path for the result.

Whether an existing path may be overwritten.

Joined emzed.Table with all left-side rows preserved.

path to file.

emzed.Table.

path to csv file.

list of colum names, if not provided first line of csv file is used instead.

list of colum types, if not provided emzed determines types from column contents and names.

list of colum formats, if not provided emzed determines formats from column contents and names.

csv delimiter character.

cells with '-' are interpreted as None (missing value). types. In case - should be handled as a string with the single character "-" one must set this argument to False.

emzed.Table.

path to file.

list of column names, if not provided first line of .xlsx or .xls file is used instead.

list of colum types, if not provided emzed determines types from column contents and names.

list of colum formats, if not provided emzed determines formats from column contents and names.

emzed.Table.

path to file.

emzed.Table.

Maximum number of rows to display. If the table is longer only head and tail of the table are shown. The missing part is denoted with "...".

If specified the width of columns can be restricted.

file object to redirect printing, e.g. to a file.

Keyword arguments mapping old column names to new column names, for example a="b".

Example: t.rename_columns(a="b") renames column "a" to "b".

the name of the exisiting column.

you can use a list with the same length as table or an expression.

supported colum types are int, float, bool, MzType, RtType, str, PeakMap, Table, object. In case you want to use Python objects like lists or dicts, use column type 'object' instead.

is a format string as "%d" or an executable string with python code. To suppress visibility set format_ = None. The default not_specified is a sentinel meaning "argument not provided" and is different from None. In that case the method determines a default format for the column type.

The column keeps its existing position in the table.

existing column name.

any of accepted types int, float, bool, MzType, RtType, str, PeakMap, Table.

target column type. If None, the current column type is used.

target column format. The default not_specified is a sentinel (different from None) and means "use the existing format or the default format for type_".

path describing target location.

If set to True an existing file will be overwritten, else an exception will be thrown.

specifies path of the file. The path must end with .csv.

Alias for sep. Default value is set to Excel dialect ';'.

If True, formatted values will be stored. Note, format settings can lead to information loss, i.e. if column format value is set to .2f% only the first 2 decimal places will be saved.

if True, missing values are written as - when as_printed is enabled.

If set to True an existing file will be overwritten, else an exception will be thrown.

specifies path of the file. The path must end with .xls or .xlsx.

column name.

accepted column format (see add_column).

None.

column name.

accepted column type (see add_column).

None.

title string stored with the table metadata.

one or more column names as separate arguments.

either bool or list/tuple of bools of same number as specified column names.

emzed.Table.

Column names defining split groups.

If True, return views. If False, return consolidated standalone tables.

List of Table subtables, one per unique group.

Column names defining split groups.

If True, yield views. If False, yield consolidated standalone tables.

Generator yielding Table subtables lazily.

list or tuple of Tables. All tables must have the same colum names with same types and formats.

If specified the result will be a Table with a db file backend, else the result will be managed in memory.

Indicate if an already existing database file should be overwritten.

emzed.Table.

list or tuple of column names.

list of common postfixes.

Examples: Assuming a Table with columns ['rt', 'rtmin', 'rtmax', 'rt1', 'rtmin1'].

t.supported_postfixes(['rt'])

returns ['', 'min', 'max', '1', 'min1']

t.supported_postfixes(['rt', 'rtmin'])

returns ['', '1']

t.supported_postfixes(['rt', 'rtmax'])

returns ['']