Programmatically creating a data frame and adding rows to it

Question

I have recently started using R and am still getting used to its data types etc. I am fetching data from a database, performing calculations on the data, and then storing some results back to the database.

The calculated data is to be stored in a specific table in the database. I want to create a data frame with columns matching that of the db table (i.e. same name and data type [near as]). In order to do that, I need to be able to do the following:

Programmatically create a data frame with specified 'columns' I know I can create this with data.frame() but its not clear how to create a data frame with only column headings, but no data (rows) yet.
Programmatically add rows to the empty data frame created in step 1 above

Travis Heeter · Accepted Answer · 2016-11-27 22:48:19Z

28

empty <- data.frame(a = numeric(), b = factor(), c = character())
filled <- rbind(empty, data.frame(a = 1, b = factor("abc"), c = "def"))

Here it is in action:

> empty <- data.frame(a = numeric(), b = factor(), c = character())
> empty
[1] a b c
<0 rows> (or 0-length row.names)
> empty$a
numeric(0)
> empty$b
factor(0)
Levels: 
> empty$c
character(0)
> filled <- rbind(empty, data.frame(a = 1, b = factor("abc"), c = "def"))
> summary(filled)
       a       b          c            
 Min.   :1   abc:1   Length:1          
 1st Qu.:1           Class :character  
 Median :1           Mode  :character  
 Mean   :1                             
 3rd Qu.:1                             
 Max.   :1

edited Nov 27, 2016 at 22:48

Travis Heeter

14.2k14 gold badges99 silver badges146 bronze badges

answered Jan 20, 2012 at 10:21

Thierry

18.5k5 gold badges51 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Homunculus Reticulli Over a year ago

BTW, is it ok for me to replace filled <- rbind(empty, data.frame(a = 1, b = factor("abc"), c = "def")) with: empty <- rbind(empty, data.frame(a = 1, b = factor("abc"), c = "def")) So that I am not creating a new data frame for each row added?

Thierry Over a year ago

You can do that. But anyway: you are in the second circle of the R inferno: burns-stat.com/pages/Tutor/R_inferno.pdf

Collectives™ on Stack Overflow

Programmatically creating a data frame and adding rows to it

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related