Conditional columns to row

Question

I have the following table with more than 30,000 lines

1
1   ne  A
1   en  B
1   hi  C
2
2   ne  D
2   ew  E
2   en  F
2   hi  G
3
3   en  H
3   ne  I
3   ew  J

The result I'm trying to get is:

    en  ew  hi  ne
1   B       C   A
2   F   E   G   D
3   H   J       I

Can any body help me?

I fixed your formatting (and removed the arbitrary-seeming "arrays" tag). Please check. Can you show what you have tried in order to solve your problem? — zdim, Jun 27 '19 at 17:25
what you are trying to achieve is called normalization. what tools/technology you are using to achive this? — yoga, Jun 27 '19 at 17:32

score 0 · Accepted Answer · answered Jun 27 '19 at 21:07

0

Assuming that your table is called df and the columns of your table are named X1, X2, X3 try the following:

library(dplyr)
library(tidyr)

df %>% 
  spread(X2, X3)

answered Jun 27 '19 at 21:07

eastclintw00d

1 Answers1