I have two dataframes which only slightly differ in column names: Call the first one df1:
ID   azC   deC   PdC
101  2     3      2
102  3     1      1
103  0     1      2
104  0     3      0
Call the second df2:
ID   azP  deP    PdP
203   3   2      1
204   2   2      3
266   0   3      0
277   3   3      1
So, ID is the same in both dataframes. The column names only differ by the ending. df1 has C at the end and df2 has P. The names are the same otherwise.
When I try this method:
df_all <- merge(df1, df2, by=c('ID'))
I get dropped values. I want to retain all the values such that the data endings of P come after the endings of C:
ID  azC   deC   PdC   azP   deP  azP
Is there a way to do this in R? Or is it easier to do it with completely raw data before organizing it in a df?
