How to add multiple columns to a data.frame in one go?

by

This will get you there:

ddf[xx] <- NA

#   a b  c  d  e  f
#1  1 2 NA NA NA NA
#2  1 2 NA NA NA NA
#3  1 2 NA NA NA NA
#...

You can’t directly use something like ddf$xx because this will try to assign to a column called xx rather than interpreting xx. You need to use [ and [<- functions, using the square brackets when you are dealing with a character string/vector – like ddf["columnname"] or ddf[c("col1","col2")], or a stored vector like your ddf[xx].

The reason why it selects columns is because data.frames are lists essentially:

is.list(ddf)
#[1] TRUE

as.list(ddf)
#$a
# [1] 1 1 1 1 1 1 1 1 1 1
# 
#$b
# [1] 2 2 2 2 2 2 2 2 2 2

…with each column corresponding to a list entry. So if you don’t use a comma to specify a row, like ddf["name",] or a column like ddf[,"name"], you get the column by default.

In the case that you are working with a 0-row dataset, you can not use a value like NA as the replacement. Instead, replace with list(character(0)) where character(0) can be substituted for numeric(0), integer(0), logical(0) etc, depending on the class you want for your new columns.

ddf <- data.frame(a=character())
xx <- c("c", "d", "e", "f")
ddf[xx] <- list(character(0))
ddf
#[1] a c d e f
#<0 rows> (or 0-length row.names)

More Related Contents:

  1. Subset data frame based on number of rows per group
  2. Drop data frame columns by name
  3. Convert data.frame columns from factors to characters
  4. Compare two data.frames to find the rows in data.frame 1 that are not present in data.frame 2
  5. Sum rows in data.frame or matrix
  6. Select the first row by group
  7. Calculate the mean of every 13 rows in data frame
  8. Calculate row means on subset of columns
  9. How does one reorder columns in a data frame?
  10. R spreading multiple columns with tidyr [duplicate]
  11. Unlist data frame column preserving information from other column
  12. How to quickly form groups (quartiles, deciles, etc) by ordering column(s) in a data frame
  13. Take random sample by group
  14. Split dataframe into multiple output files
  15. Replacing values from a column using a condition in R
  16. Split data.frame by value
  17. How to use a string variable to select a data frame column using $ notation [duplicate]
  18. Remove columns from dataframe where some of values are NA
  19. Check whether values in one data frame column exist in a second data frame
  20. How do you remove columns from a data.frame?
  21. Splitting a large data frame into smaller segments
  22. How to add a factor column to dataframe based on a conditional statement from another column?
  23. Remove all rows where length of string is more than n
  24. Replace in a factor column
  25. write.csv for large data.table
  26. Selecting columns in R data frame based on those *not* in a vector
  27. How can I change XTS to data.frame and keep Index?
  28. Return pmin or pmax of data.frame with multiple columns
  29. How to divide a number of columns by one column?
  30. Split a column by group [duplicate]

Leave a Comment