How to Add a Row To a Data Frame in R

Adding new rows to a data frame is a bit trickier than adding columns. The row must be a data frame and the column names have to match the original data frame.

Code used in this clip:

# Load a data set and break off a row
df = mtcars
row_to_add = df[1,]
row_to_add

# Add the row back to the data set
df = rbind(df, row_to_add)
tail(df)

# Add a new row with given values

# Column names must match!
names(new_row) = names(df)
df = rbind(df, new_row)
tail(df)

Code Clips are basic code explanations in 2 minutes or less. They are intended to be short reference guides that provide quick breakdowns and copy/paste access to code needed to accomplish common data science tasks. Think Stack Overflow with a video explanation.

* Note: YouTube does not allow greater than or less than symbols in the text description, so the code above will not be exactly the same as the code shown in the video! For R that means I may use = for assignment and the special Unicode large ＜ and ＞ symbols in place of the standard sized ones for dplyr pipes and comparisons. These special symbols should work as expected for R code on Windows, but may need to be replaced with standard greater than and less than symbols for other operating systems.

[johnpoole]

Thanks for this - the only problem I have is that it doesn't add data to the original vectors. For example, if you want to calculate average MPG of all cars, it won't include the new car you just added.

[mitchellem]

Can you do a tutorial or advice on how to add multiple rows rather than one.Thanks

[wadjay]

Hi so i have two different data frames. they both match but one is empty. Rbind(nonempty, empty) works. I get an empty row at the end. What i want to do is Rbind(empty, nonempty) this doesn't work. I would like the empty row first and the non empty follow by.

[jean-carlsatumalay]

Hi. Can u help me with a code. I have a data.frame. In one column there are numerical values. And i am using if/else statements to determine the value.

So if the numerical value > 0.25 it should give output "positive". This string-value should come next to (cell next to) the numerical value in the data.frame... but how do i do that? Can you help me?

[manyoeur]

hello, how if we have hundred of rows to add?