Create R data frame row-wise

Question

How to create a data frame in R providing the data row-wise? I am looking for a one statement solution.

This is the one statement solution for column-wise:

mydf = data.frame(
    fruit = c("apple", "orange", "banana"),
    pieces = c(3, 2, 5)
)

I find the row-wise approach more logical (imagine that we have hundreds of entries), therefore I am looking for such a solution.

I made some investigations. The simplest solution I found is this:

mymatrix <- rbind(
    c("apple", 3), 
    c("orange", 2), 
    c("banana", 5)
)
colnames(mymatrix) <- c("fruit", "pieces")
mydf = as.data.frame(mymatrix)
mydf = transform(mydf, pieces=as.numeric(pieces))

But as an extra variable and multiple step transformation is needed, I still find it too complicated. Is there a one statement solution to that, similar to the column-wise approach?

tribble()? tibble() %>% add_row(fruit="Orange", pieces=3)? — Limey
– Limey, Commented Mar 21, 2021 at 8:41

TarJae · Accepted Answer · 2021-03-21 08:40:14Z

1

You can use tribble from tibble package for Row-wise tibble creation

library(tibble)

mydf <- tribble(
~fruit, ~pieces, 
"apple", 3, 
"orange", 2,
"banana", 5
)

answered Mar 21, 2021 at 8:40

TarJae

80.2k6 gold badges30 silver badges94 bronze badges

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

Collectives™ on Stack Overflow

Create R data frame row-wise

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related