[R] how to combine unequal rows and columns in R

[Tammy Ma]

HI, 


I have the following list:

crosspries
$crosspries[[1]]
       Product         Year_Month   prod1
          A                  201208        1
          B                  201208        2
          C                  201208        1


$crosspries[[2]]
     Product       Year_Month    prod1   prod2
        A               201209         1          1
        B               201209         2          2
        D              201209          1          1
        F              201209          2          1

I want to get the following dataframe:


Product   Year_Month     prod1    prod2
   A         201208             1           NA
   B          201208             2           NA
  C          201208              1           NA
  D           201208             NA          NA
  F            201208             NA          NA
  A         201209             1             1
  B         201209             2             2
  C        201209             NA           NA
  D        201209             1              1
  F        201209             2              1



How can I get it in r?


Thanks.

Kind regards,
Tammy



 




                                          
        [[alternative HTML version deleted]]

______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.