[ Learn | Predict | Clustering | Table Merge | Columns | Append Rows ]

3.10.1 Build Prediction Model

Learn and Predict tools are described here.

3.10.2 Predict

Learn and Predict tools are described here.

3.10.3 Cluster Set

This is described in the cluster section of the Working with Tables Chapter.

3.10.4 Merge Two Sets

To merge two tables:

• Read the two tables into ICM.
• Tools/Table/Merge Two Sets
• Select the first table from the drop down list (Table A) and the column you wish to use to merge the table by.
• Select merge method 1. inner - only molecules present in BOTH A and B tables are kept; or 2. left ALL rows of A are kept ; or 3. right ALL rows of B are kept.
• Select the second table from the drop down list (Table B) and the column you wish to use to mergethe table by.
• Enter a name for the output table.
• Click OK and a new table will be displayed.

3.10.5 Add External Columns

To add external columns to a table:

• Read at least two tables into ICM - the table you want to add to and the table you want to add the column from.
• Tools/Table/Add External Columns
• Enter the target table name and the column you wish to match each table by.
• Enter the source of the new column (Other table and column name)
• Choose to add "all the columns" from the source or "overwrite matching columns" or select the columns you want to add by selecting the "choose column" option.

3.10.6 Append Rows

To append rows from one table to another one:

• Read at least two tables into ICM - the table you want to add to and the table you want to add the column from.
• Tools/Table/Append Rows
• Enter the name of the Target Table (where you will append).
• Enter the name of the Source Table (where you will append from).