Add a vector to a column of a dataframe

Question

Sorry about this one but I can't find an easy solution to this.

I have a data frame:

>bla<-c(1)
>df<-data.frame(bla)
>df

bla
1   1

I want to append values to the bottom of the column (hence not create a new one, as explained here). For instance, get:

I tried:

df[2,1]<-c(2,3,4,5)
df[,1]<-c(2,3,4,5)

but I get:

Error in `[<-.data.frame`(`*tmp*`, 2, 1, value = c(2, 3, 4, 5)) : 
  replacement has 4 rows, data has 1

Maybe dataframes are not appropriate and I should try with matrixes instead? Any suggestion would be much appreciated! :)

`rbind(df, data.frame(bla = c(2,3,4,5)))`? – A5C1D2H2I1M1N2O1R2T1 Jul 08 '15 at 16:14 — A5C1D2H2I1M1N2O1R2T1, Jul 08 '15 at 16:14
`df <- data.frame(bla = c(df$bla, 2:5))` would also work – talat Jul 08 '15 at 16:19 — talat, Jul 08 '15 at 16:19
@AnandaMahto thanks so much! Works perfectly! :) – tlorin Jul 08 '15 at 16:22 — tlorin, Jul 08 '15 at 16:22

score 4 · Answer 1 · answered Jul 08 '15 at 16:19

4

You need to convert c(2,3,4,5) to a data frame then use rbind to join the rows as @Ananda Mahto did in his comment

df <- rbind(df, data.frame(bla = c(2,3,4,5)))

Where 'bla' is the name of the column in df

answered Jul 08 '15 at 16:19

HasaniH

score 1 · Answer 2 · answered Jul 08 '15 at 16:40

Another option if you know the final dimensions in advance is just to create an empty dataframe of the given size and then append rowwise:

blah <- data.frame(matrix(NA, nrow=N, ncol=M))
    for (i in 1:N) {
      yourResults <- yourFunction()
      blah[i,] <- yourResults
    }

2 Answers2