Thank you Arun Kirshna. That worked perfectly!


On Mon, Mar 24, 2014 at 2:49 PM, arun kirshna [via R] <
ml-node+s789695n4687459h71@n4.nabble.com> wrote:

> Hi,
> Try ?merge() or ?join from library(plyr)
> If `dat1` and `dat2` are the datasets:
> res <- merge(dat1,dat2,by="Code",all=TRUE)
>  res[is.na(res)] <- 0
>  res
> #  Code Cap04 Cap08
> #1    2   120   120
> #2    6    75     0
> #3    7   220   112
> #4    9     0   190
> #5   17     4     4
> A.K.
>
>
>
> Hello,
>
> I need to combine two data sets into one. For example:
>
> Dataset1:
> Code   Cap04
> 2        120
> 6          75
> 7        220
> 17         4
>
> Dataset2:
> Code   Cap08
> 2        120
> 7        112
> 9        190
> 17         4
>
>
> I need the dataset to look like the following where it keeps
>  every unique 'code' from both datasets and fills the blanks in both
> rows with 0:
>
> FinalDataSet:
> Code   Cap04   Cap08
> 2         120       120
> 6          75          0
> 7         220       112
> 9            0       190
> 17          4          4
>
> Can anyone help me with this please?
>
> Thank you very much!
> Johnson
>
> ______________________________________________
> [hidden email] <http://user/SendEmail.jtp?type=node&node=4687459&i=0>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.
>
>
> ------------------------------
>  If you reply to this email, your message will be added to the discussion
> below:
>
> http://r.789695.n4.nabble.com/How-to-join-data-frames-with-different-row-lengths-tp4687457p4687459.html
>  To unsubscribe from How to join data.frames with different row lengths, click
> here<http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4687457&code=bXc1d2Fnc0BnbWFpbC5jb218NDY4NzQ1N3wxNzA5ODM5Njkw>
> .
> NAML<http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>



-- 
Megan Weigel
(865)924-2124
mw5wags@gmail.com




--
View this message in context: http://r.789695.n4.nabble.com/How-to-join-data-frames-with-different-row-lengths-tp4687457p4687471.html
Sent from the R help mailing list archive at Nabble.com.
	[[alternative HTML version deleted]]


