I have a data frame in R which looks like this with two columns:
ID phone_number
Mark 866458
Paul 986564
Jack 987543
Mary 523422
I would like to have this kind of output where I only have one single column
Mark
866458
Paul
986564
Jack
987543
Mary
523422
Anybody knows which R code could I use to obtain the output?
Data for reproducibility:
structure(list(ID = c("Mark", "Paul", "Jack", "Mary"), phone_number = c(866458,
986564, 987543, 523422)), row.names = c(NA, -4L), class = c("tbl_df", "data.frame"))
We can transpose the dataframe and then create one vector of values
data.frame(new_col = c(t(df)))
# new_col
#1 Mark
#2 866458
#3 Paul
#4 986564
#5 Jack
#6 987543
#7 Mary
#8 523422
Another base R option using mapply
data.frame(new_col = c(mapply(c, df$ID, df$phone_number)))
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With