RPR-Subsetting

Subsetting and filtering R objects

(Subsetting with the [], [[]], and $ operators, filtering)

 

Abstract:

Subsetting and filtering are among the most important operations with data. R provides powerful syntax for these operations. Learn about and practice them in this unit.

---

Objectives: This unit will ... ... introduce subsetting principles; ... practice them on data;

Outcomes: After working through this unit you ... ... can subset and filter data according to six different principles.

---

Deliverables:

• Time management: Before you begin, estimate how long it will take you to complete this unit. Then, record in your course journal: the number of hours you estimated, the number of hours you worked on the unit, and the amount of time that passed between start and completion of this unit.
• Journal: Document your progress in your Course Journal. Some tasks may ask you to include specific items in your journal. Don't overlook these.
• Insights: If you find something particularly noteworthy about this unit, make a note in your insights! page.

---

Prerequisites:
This unit builds on material covered in the following prerequisite units:

• RPR-Objects-Lists (R "Lists")

 

 

 

Evaluation

Evaluation: NA

This unit is not evaluated for course marks.

Contents

Task:

• Load the R-Exercise_BasicSetup project in RStudio if you don't already have it open.
• Type init() as instructed after the project has loaded.
• Recreate the plasmidData data frame that you worked with in the RPR-Objects-Data_frames unit, (if it is not still defined in your Workspace; or use the code below):

plasmidData <- data.frame(Name = c("pUC19", "pBR322", "pACYC184", "pMAL-p5x"),
                          Size = c(2686, 4361, 4245, 5752),
                          Marker = c("Amp", "Amp, Tet", "Cam", "Amp"),
                          Ori = c("ColE1", "ColE1", "p15A", "pMB1"),
                          Sites = c("EcoRI, SacI, SmaI, BamHI, HindIII",
                                    "EcoRI, ClaI, HindIII",
                                    "ClaI, HindIII",
                                    "SacI, AvaI, HindIII"))

• Continue below.

Subsetting

We have encountered "subsetting" before, but we really need to discuss this in more detail. It is one of the most important topics of R since it is indispensable to select, transform, and otherwise modify data to prepare it for analysis. You have seen that we use square brackets to indicate individual elements in vectors and matrices. These square brackets are actually "operators", and you can find more information about them in the help pages:

> ?"["     # Note that you need quotation marks around the operator for this.

Note especially: - [ ] "extracts" one or more elements defined within the brackets; - [[ ]] "extracts" a single element defined within the brackets; - $ "extracts" a single named element.

"Elements" are not necessarily scalars, but can apply to a row, column, or more complex data structure. But a "single element" can't be a range, or collection.

 

Here are some examples of subsetting data from the plasmidData data frame we constructed previously. For the most part, this is review:

plasmidData[1, ]
plasmidData[2, ]

# we can extract more than one row by specifying
# the rows we want in a vector ...
plasmidData[c(1, 2), ]

# ... this works in any order ...
plasmidData[c(3, 1), ]

# ... and for any number of rows ...
plasmidData[c(1, 2, 1, 2, 1, 2), ]


# Same for columns
plasmidData[ , 2 ]

# We can select rows and columns by name if a name has been defined...
plasmidData[, "Name"]
plasmidData$Name      # different syntax, same thing. This is the syntax I use most frequently.


# Watch this!
plasmidData$Name[plasmidData$Ori != "ColE1"]
# What happened here?
# plasmidData$Ori != "ColE1" is a logical expression, it gives a vector of TRUE/FALSE values:
plasmidData$Ori != "ColE1"

# ... insert this vector into the square brackets. R then returns all rows for
# which the corresponding vector element is TRUE.

# With this, we can "filter" for values
plasmidData$Size > 3000
plasmidData$Name[plasmidData$Size > 3000]

# Any operation that has TRUE or FALSE as a result can be used for filtering:
#   - the equality operators == and !=
#   - the comparison operators  >, <, >=, and <=
#   - %in%
#   - grepl()
#   - as.logical()

# plasmids that have only the Amp marker
plasmidData[plasmidData$Marker == "Amp"]

# plasmids that don't have the Amp marker
plasmidData[plasmidData$Marker == "Amp"]



# This principle is what we use when we want to "sort" an object
# by some value. The function order() is used to return values
# that are sorted. Remember this: not sort() but order().
order(plasmidData$Size)
plasmidData[order(plasmidData$Size), ]

# grep() matches substrings in strings and returns a vector of indices
grep("Tet", plasmidData$Marker)
plasmidData[grep("Tet", plasmidData$Marker), ]
plasmidData[grep("Tet", plasmidData$Marker), "Ori"]

Elements that can be extracted from an object also can be replaced. Simply assign the new value to the element.

( x <- sample(1:10) )
x[4] <- 99
x
( x <- x[order(x)] )

Try your own subsetting ideas. Play with this. I find that even seasoned investigators have problems with subsetting their data and if you become comfortable with the many ways of subsetting, you will be ahead of the game right away.

 

Subsetting practice

Task:
Practice, practice, practice. You need to develop an intuition about subsetting. This will help you tremendously to understand our code examples - but it will also help you develop ways to think about data.

• The R-Exercise_BasicSetup project contains a file subsettingPractice.R
• Open the file and work through it.

 

About ...
 
Author:

Boris Steipe <boris.steipe@utoronto.ca>

Created:

2017-08-05

Modified:

2020-09-18

Version:

1.0.2

Version history:

• 1.0.2 Maintenance
• 1.0.1 Maintenance
• 1.0 Completed to first live version
• 0.1 Material collected from previous tutorial

---

This copyrighted material is licensed under a Creative Commons Attribution 4.0 International License. Follow the link to learn more.