Append row in data.frame using list of variable with same name of columns - R Language

Question

dears!

Summarizing my problem in a small example...

I want to append a row in data.frame using a list of variables with the same name of the data.frame columns, like this:

#createing a blank data.frame
df <- data.frame(matrix(ncol=3, nrow=0))
#naming the header    
head <- c("col1", "col2", "col3")
# assigning header to data.frame    
colnames(df) <- head
# creating three variables with the same name of header
col1 <- 1
col2 <- 2
col3 <- 3
#appending the row
rbind(df, list(col1, col2, col3))

The code runs, but the df continues blank. I would like a result like this for df:

col1    col2   col3
   1       2      3

Help me with this rbind.

Hi, you can try df <- data.frame(col1,col2,col3) instead.

Daisy Chang
– Daisy Chang

2020-06-13 21:00:15 +00:00
Commented Jun 13, 2020 at 21:00 — Daisy Chang
– Daisy Chang, Commented Jun 13, 2020 at 21:00

Daniel_j_iii · Accepted Answer · 2020-06-13 21:02:16Z

1

If you use the names() function, you can rename the columns in R

#createing a blank data.frame
df <- data.frame(matrix(ncol=3, nrow=0))
#naming the header    
head <- c("col1", "col2", "col3")
# assigning header to data.frame    
colnames(df) <- head
# creating three variables with the same name of header
col1 <- 1
col2 <- 2
col3 <- 3
#appending the row
df2 <- rbind(df, list(col1, col2, col3))

names(df2) <- c("col1", "col2", "col3")

df2

produces the output below

  col1 col2 col3
     1    2    3

answered Jun 13, 2020 at 21:02

Daniel_j_iii

3,2643 gold badges14 silver badges29 bronze badges

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

3 Comments

Beto Over a year ago

I've just tried. I came here to erase the question and I read your comment. My mind was very tired, and I didn't see this idiot mistake. By the way, THANK YOU!

Daniel_j_iii Over a year ago

If you feel I have answered your question, don't erase it and please feel free to grant me an answer credit

tnotstar Over a year ago

The reason behind the loss of column names has perhaps already been answered here

Collectives™ on Stack Overflow

Append row in data.frame using list of variable with same name of columns - R Language

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related