Manipulating Data Frames in R: Adding and Removing Rows

Hello and welcome! Today, we're learning to add and remove rows from data frames in R. This is an essential skill for data manipulation. By the end of the lesson, you'll be proficient in using the rbind() function to add rows and negative indexing to remove rows.

As you may recall, a data frame in R is a tabular storage medium for data. It's akin to a table in a library, where each book corresponds to a row, and each detail of a book has a column.

students <- data.frame(
  Name = c("John", "Anna", "Peter", "Laura"),
  Age = c(12, 13, 11, 12),
  Grade = c(7, 8, 7, 7)
)
print(students)

Here, we're tracking the details of students with a data frame named students.

The rbind() function in R helps us add new rows to data frames. It requires that the new row aligns structurally with the existing data frame.

Let's add a new student to our data frame.

new_student <- data.frame(
  Name = "Amy",
  Age = 12,
  Grade = 7
)
students <- rbind(students, new_student)
print(students)  # We now see Amy's data included in the `students` data frame.

To remove rows from a data frame, you can use negative indexing. Let's say, for example, that we want to remove "Peter" from the students data frame.

students <- students[-3, ]
print(students)  # Peter is now removed from our `students` data frame.

Errors can arise if the new row's structure does not align with the data frame's structure. Always confirm the structure and data types of your data frame using the str() function. For example, if we use str(students), we will see the following:

'data.frame':	4 obs. of  3 variables:
 $ Name : chr  "John" "Anna" "Laura" "Amy"
 $ Age  : num  12 13 12 12
 $ Grade: num  7 8 7 7

Imagine you're attempting to add a new student to our students data frame but accidentally leave out one of the required columns. For example, if you forget to include the Grade column for the new student:

incomplete_new_student <- data.frame(
  Name = "Ben",
  Age = 14
  # Note: We forgot to include the Grade column for Ben
)

Trying to add incomplete_new_student to the students data frame using rbind() will produce an error because the columns in incomplete_new_student do not match those in students. R will display a message similar to:

Error in rbind(deparse.level, ...) : 
  numbers of columns of arguments do not match

This error occurs because all rows in a data frame must have the same columns. Always ensure that the new row includes all the columns present in the original data frame.