# Adding sample attributes

Now that the data has been imported, we need to make a few changes to the data annotation before analysis.

## Modifying sample attributes

Notice that the *Sample ID* names in column 1 are gray (Figure 1). This indicates that *Sample ID* is a text factor. Text factors cannot be used as a variable in downstream analysis so we need to change *Sample ID* to a categorical factor.

![](https://1384254481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJVEESmJAPppJ3ijFq5aR%2Fuploads%2Fgit-blob-6a1f89139afcf02282179b001744702527ea32d5%2F2018-08-20_11h54_08.png?alt=media)

Figure 1. Viewing the imported data in a spreadsheet

* Right-click on the column header to invoke the pop-up menu
* Select **Properties** (Figure 2)

![](https://1384254481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJVEESmJAPppJ3ijFq5aR%2Fuploads%2Fgit-blob-61fe2e8adb7de9f21521505bc13003af830c1cc2%2F2018-08-20_11h54_51.png?alt=media)

Figure 2. Changing column properties

* Configure the *Properties of Column 1 in Spreadsheet 1* dialog as shown (Figure 3) with *Type* set to **categorical** and *Attribute* set to **factor**

![](https://1384254481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJVEESmJAPppJ3ijFq5aR%2Fuploads%2Fgit-blob-358f2e758e45444b780a4ec6a8d784063554d648%2F2017-08-07%2010_11_51-Properties%20of%20Column%201%20in%20Spreadsheet%201.png?alt=media)

Figure 3. Changing column 1 properties

* Select **OK**

The samples names in column 1 are now black, indicating that they have been changed to a categorical variable. Next, we will add attributes for grouping the data.

## Adding sample attributes

* From the *RNA-seq* workflow panel, select **Add Sample Attributes** to bring up the Add Sample Attributes dialog (Figure 4)

![](https://1384254481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJVEESmJAPppJ3ijFq5aR%2Fuploads%2Fgit-blob-f1ef8f3047334fe953fb63980407b92478fb166e%2Ffig9.png?alt=media)

Figure 4. Add Sample Attributes dialog

* Select **Add a Categorical Attribute**
* Select **OK** to bring up the *Create categorical attribute* dialog

Creating a categorical sample attribute allows us to group samples. This is useful for designating samples as replicates, as members of an experimental group, or as sharing a phenotype of interest. In this tutorial, we have four different samples from different tissues and different donors, but to illustrate the available statistical analysis options, we need to divide the samples into two groups: *muscle* (Heart and Muscle) and *not muscle* (Brain and Liver).

* Set *Attribute name:* as *Tissue*
* Rename *Group 1* to *muscle* and *Group 2* to *not muscle*
* Select and drag the samples from the *Unassigned* panel to the correct group panel (Figure 5)

![](https://1384254481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJVEESmJAPppJ3ijFq5aR%2Fuploads%2Fgit-blob-94d96de5e3dda10c765914542c38624f1d72baaa%2Ffig10.png?alt=media)

Figure 5. Creating a categorical attribute

* Select **OK**
* Select **No** from the *Add another attribute?* dialog
* Select **Yes** from the *Save spreadsheet 1* dialog

The attribute will now appear as a new column in the *RNA-seq* spreadsheet with the heading *Tissue* and the groups *muscle* and *not muscle.*

## Choosing Sample ID column

The next available step in the *Import* panel of the *RNA-seq* workflow is **Choose Sample ID Column\_.\_** Verifying the correct column is designated the Sample ID becomes particularly important when data from multiple experiments is being combined.

* Select **Choose Sample ID Column** from the *Import* panel of the *RNA-Seq* workflow
* Select **OK** (Figure 6)

![](https://1384254481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJVEESmJAPppJ3ijFq5aR%2Fuploads%2Fgit-blob-b95f97fb0335c6ddb6dd48dbe25a79b405b05b96%2Ffig11.png?alt=media)

Figure 6. Choosing the correct column as Sample ID

## Additional Assistance

If you need additional assistance, please visit [our support page](http://www.partek.com/support) to submit a help ticket or find phone numbers for regional support.