Page History
...
- Select ( ) from the quick action bar to invoke the interactive filter
- Select 43. CHR Gender for Column
For categorical columns, the interactive filter displays each category of the selected column as a colored bar. For 42. CHRGender, each bar represents a chromosome with the height of bar representing the number of probes from that chromosome in the selected spreadsheet. To filter out a category, left-click on its bar. Right clicking on a bar will include only the selected category. A pop up balloon will show the category label as you mouse over each bar.
- Left-click the X and Y chromosome columns Male column to filter them it out (Figure 35)
Numbered figure captions | ||||||||
---|---|---|---|---|---|---|---|---|
|
| |||||||
The yellow and black bar on the right-hand side of the spreadsheet panel shows the fraction of excluded cells rows in black and included cells rows in yellow. Right-clicking this bar brings up an option to clear the filter.
Now that we have filtered out probes on the X and Y chromosomesmale samples, we will create a spreadsheet containing only probes on the autosomesfemale samples.
- Right click on the ANOVA-1way 1 (ANOVAResultsMethylation) spreadsheet in the spreadsheet tree panel (Figure 4)
- 6)
Numbered figure captions | ||||
---|---|---|---|---|
| ||||
- Select Clone
- Rename the new spreadsheet Female_only using the Clone Spreadsheet dialog
- Select 1 (Methylation) from the Create new spreadsheet as a child spreadsheet: drop-down menu (Figure 7)
- Select OK
Numbered figure captions | ||||
---|---|---|---|---|
| ||||
- Specify a name for the spreadsheet, we chose female_only, using the Save File dialog
- Select Save to save the spreadsheet
It is best practice to occasionally save the project you are working on. Let's take the opportunity to do this now.
- Select File from the main command toolbar
- Select Save Project...
- Specify a name for the project, we chose Methylation, using the Save File dialog
- Select Save to save the project
Saving the project saves the identity and child-parent relationships of all spreadsheets displayed in the spreadsheet tree. This allows us to open all relevant spreadsheets for our analysis by selecting the project file.
Page Turner | ||
---|---|---|
|
...