Categories: Big Data

Learn R – How to Append Rows to Data Frame

This article represents concepts and code samples on how to append rows to a data frame when working with R programming language. Please feel free to comment/suggest if I missed mentioning one or more important points. Also, sorry for the typos.




Following are the key points described later in this article:

  • How to append one or more rows to an empty data frame
  • How to append one or more rows to non-empty data frame

For illustration purpose, we shall use a student data frame having following information:

  
First.Name Age
1     Calvin  10
2      Chris  25
3        Raj  19

How to Append one or more rows to an Empty Data Frame

Following code represents how to create an empty data frame and append a row.

# Create an empty data frame, teachers, with columns as name, and age
# Note stringsAsFactors = FALSE
teachers <- data.frame( "name" = character(), "age" = integer(), stringsAsFactors=FALSE)
# Alternate way to create is to specify 0 as size of vector
teachers <- data.frame( "name" = character(0), "age" = integer(0), stringsAsFactors=FALSE)
# Append a row
teachers[nrow(teachers) + 1, ] <- c( "ted", 50)
teachers[nrow(teachers) + 1, ] <- c( "james", 55)
# Print teachers
teachers

Following will get printed

   name age
1   ted  50
2 james  55

How to Append One or More Rows

Approach 1:Lets say, you have a student data frame consisting of two columns, namely, First name and Age. The need is to add additional rows. Following code demonstrate the way you could add rows to existing data frame.

# Following code uses rbind to append a data frame to existing data frame
student <- rbind( student, data.frame("First Name"="James", "Age"=55))
# View the student data frame
student

Following is the new data frame:

 First.Name Age
1     Calvin  10
2      Chris  25
3        Raj  19
4      James  55

Approach 2: Following is another approach. It assumed that the student data frame was created using stringsAsFactors=FALSE. Note that this is key for following to work.

# Assign a vector to the new row accessed using index, nrow(student) + 1
student[nrow(student)+1,] <- c("John", 55 )
# Print student
student

Following gets printed

   First.Name Age
1     Calvin  10
2      Chris  25
3        Raj  19
4      James  55
5       John  55
Ajitesh Kumar

I have been recently working in the area of Data analytics including Data Science and Machine Learning / Deep Learning. I am also passionate about different technologies including programming languages such as Java/JEE, Javascript, Python, R, Julia, etc, and technologies such as Blockchain, mobile computing, cloud-native technologies, application security, cloud computing platforms, big data, etc. I would love to connect with you on Linkedin. Check out my latest book titled as First Principles Thinking: Building winning products using first principles thinking.

View Comments

Recent Posts

Agentic Reasoning Design Patterns in AI: Examples

In recent years, artificial intelligence (AI) has evolved to include more sophisticated and capable agents,…

1 month ago

LLMs for Adaptive Learning & Personalized Education

Adaptive learning helps in tailoring learning experiences to fit the unique needs of each student.…

1 month ago

Sparse Mixture of Experts (MoE) Models: Examples

With the increasing demand for more powerful machine learning (ML) systems that can handle diverse…

2 months ago

Anxiety Disorder Detection & Machine Learning Techniques

Anxiety is a common mental health condition that affects millions of people around the world.…

2 months ago

Confounder Features & Machine Learning Models: Examples

In machine learning, confounder features or variables can significantly affect the accuracy and validity of…

2 months ago

Credit Card Fraud Detection & Machine Learning

Last updated: 26 Sept, 2024 Credit card fraud detection is a major concern for credit…

2 months ago