Add Empty Row to Data Frame in R (Example)


In this tutorial, I’ll explain how to append an empty row to the bottom of a data frame in the R programming language.

Table of contents:

It’s time to dive into the example:


Example Data

At the start, we’ll need to construct some example data:

data <- data.frame(x1 = 1:4,            # Create example data frame
                   x2 = 4:1,
                   x3 = letters[1:4])
data                                    # Print example data frame


table 1 data frame add empty row data frame


Have a look at the previously shown table. It shows that the example data frame is made up of four rows and three columns.


Example: Append Empty Row to Data Frame Using nrow() Function

This example shows how to bind a new empty row that contains only NA values (i.e. missing values) to the bottom of a data frame object.

To accomplish this task, we can use the nrow function as shown in the following R programming syntax:

data_new <- data                        # Create duplicate of example data frame
data_new[nrow(data_new) + 1, ] <- NA    # Add empty row containing only NA values
data_new                                # Print new data frame


table 2 data frame add empty row data frame


The output of the previous R syntax is shown in Table 2 – We have created a new data frame object called data_new that contains an additional line at the very bottom of the data frame. This new row contains only NA values.


Video & Further Resources

Have a look at the following video on my YouTube channel. In the video, I’m illustrating the topics of this page.


Please accept YouTube cookies to play this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.

YouTube Content Consent Button Thumbnail

YouTube privacy policy

If you accept this notice, your choice will be saved and the page will refresh.


In addition to the video, you might want to have a look at the related R articles on this website:


In this tutorial you have learned how to add an empty row with only NA values to the bottom of a data frame in the R programming language. In case you have additional questions, please let me know in the comments.


Subscribe to the Statistics Globe Newsletter

Get regular updates on the latest tutorials, offers & news at Statistics Globe.
I hate spam & you may opt out anytime: Privacy Policy.

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.