R help - Aug 2013 - 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]]

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!

Hi all, 

I have two datasets: 

Dataset 1 - List of Users, the layout looks like this: 
ID Name C1 C2 C3 ............C23 C24 C25 

Dataset 2 - List of Codes, the layout looks like this: 
Code Description Category 

The 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 description 

I find this very challenging but I'm sure there are some R-guru's out
there
who can help me on this:) 
I cannot give any sample data because it's classified

Thanks in advance 



--
View this message in context:
http://r.789695.n4.nabble.com/Retreiving-correct-data-from-combining-two-datasets-tp4673131.html
Sent from the R help mailing list archive at Nabble.com.