How to combine two vectors into a data frame

Question

I have two vectors like this   x  lt -c 1 2 3   y  lt -c 100 200 300   x name  lt -  cond   y name  lt -  rating    I d like to output the dataframe like this    gt  print df        cond rating       1  x 1        2  x 2       3  x 3       4  y 100       5  y 200       6  y 300   What s the way to do it

User · Answer

This should do the trick  to produce the data frame you asked for  using only base R   df  lt - data frame cond c rep  x   times length x                             rep  y   times length y                       rating c x  y    df   cond rating 1    x      1 2    x      2 3    x      3 4    y    100 5    y    200 6    y    300   However  from your initial description  I d say that this is perhaps a more likely usecase   df2  lt - data frame x  y  colnames df2   lt - c x name  y name   df2   cond rating 1    1    100 2    2    200 3    3    300    edit  moved parentheses in example 1

User · Answer

While this does not answer the question asked  it answers a related question that many people have had   x  lt -c 1 2 3  y  lt -c 100 200 300  x name  lt -  cond  y name  lt -  rating   df  lt - data frame x y  names df   lt - c x name y name  print df     cond rating 1    1    100 2    2    200 3    3    300

User · Answer

Alt simplification of https   stackoverflow com users 1969435 gx1sptdtda above   cond  lt -c 1 2 3  rating  lt -c 100 200 300  df  lt - data frame cond  rating  df   cond rating 1    1    100 2    2    200 3    3    300

User · Answer

You can use expand grid    function   x  lt -c 1 2 3  y  lt -c 100 200 300  expand grid cond x rating y

User · Answer

Here s a simple function  It generates a data frame and automatically uses the names of the vectors as values for the first column   myfunc  lt - function a  b  names   NULL      setNames data frame c rep deparse substitute a    length a                             rep deparse substitute b    length b     c a  b    names      An example   x  lt -c 1 2 3  y  lt -c 100 200 300  x name  lt -  cond  y name  lt -  rating   myfunc x  y  c x name  y name      cond rating 1    x      1 2    x      2 3    x      3 4    y    100 5    y    200 6    y    300

User · Answer

x  lt -c 1 2 3  y  lt -c 100 200 300  x name  lt -  cond  y name  lt -  rating   require reshape2  df  lt - melt data frame x y   colnames df   lt - c x name  y name  print df    UPDATE  2017-02-07   As an answer to  cdaringe comment - there are multiple solutions possible  one of them is below   library dplyr  library magrittr   x  lt - c 1  2  3  y  lt - c 100  200  300  z  lt - c 1  2  3  4  5  x name  lt -  cond  y name  lt -  rating     Helper function to create data frame for the chunk of the data prepare  lt - function name  value  xname   x name  yname   y name      data frame rep name  length value    value    gt       set colnames c xname  yname      bind rows    prepare  x   x     prepare  y   y     prepare  z   z

User · Answer

df   data frame cond c rep  x  3  rep  y  3   rating c x y

[r] How to combine two vectors into a data frame

Examples related to r

Examples related to dataframe