[R] Retreiving correct data from combining two datasets

[John Kane]

Please do not send in HTML. The list strips out any HTML and as a result your message is close to unreadable. It will look fine in Nabble but many (most) R-help readers do not use nabble and some actively dislike it. It is usually better to send directly to the list.

Also we probably could use a bit more information. See https://github.com/hadley/devtools/wiki/Reproducibility and/or
 http://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example for some suggestions on crafting a question for the list.

John Kane
Kingston ON Canada


> -----Original Message-----
> From: info at software-solutions.nl
> Sent: Mon, 5 Aug 2013 00:26:35 -0700 (PDT)
> To: r-help at r-project.org
> Subject: [R] Retreiving correct data from combining two datasets
> 
> Hi all,I have two datasets:*Dataset 1 - List of Users:*ID Name C1 C2 C3
> ............C23 C24 C25*Dataset 2 - List of Codes*Code Description
> CategoryThe code fields in the user-dataset do not have to contain a
> value
> and if they have a value they dont have to correspond with the
> Codes-dataset.Now I need 2 things:- Per user-record the number of
> occurences
> in the Codes table, so if one user would have C1, C8, C12, C19 occuring
> in
> the Codes dataset that would be 4.- The top 20 of the most occuring codes
> with their descriptionI find this very challenging but I'm sure there are
> some R-guru's out there who can help me on this:)Thanks in advance
> 
> 
> 
> --
> View this message in context:
> http://r.789695.n4.nabble.com/Retreiving-correct-data-from-combining-two-datasets-tp4673098.html
> Sent from the R help mailing list archive at Nabble.com.
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help at 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.

____________________________________________________________
FREE ONLINE PHOTOSHARING - Share your photos online with your friends and family!
Visit http://www.inbox.com/photosharing to find out more!