What code to use in R 3.5.1 to count numbers of unique v2 for each unique v1?

0.00/5 (No votes)

See more:

I have a data with 2 columns. Var1 - school classes, Var2 - names of students in the class. What command can I use to make a new matrix that will show how many times are repeated unique names in var2 for each unique var1?

Var1 Var2
9 Sarah
9 John
12 Sarah
11 Veronica
10 John
10 John
11 Veronica
12 John
12 Veronica
11 Veronica
10 Sarah
9 Veronica
9 John

What command can I use to make a new matrix that will show how many times are repeated unique names in var2 for each unique var1?

_____Sarah____Veronica__John
9______1_______1___________2
10_____1_______0___________1
11_____0_______3___________0
12_____1_______1___________1

Thank you in advance!

What I have tried:

I don't know which command to use, please help

Posted 6-Aug-18 6:27am

Member 13939747

Add a Solution

Comments

Richard MacCutchan 6-Aug-18 13:10pm

I don't think you would use a single command. You would need to write the code to sort the data and create the lists you are interested in.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Last 24hrs

This month

Richard MacCutchan	80
Rick York	20
KarstenK	10
Pete O'Hanlon	10
Wonde Tadesse	5

Pete O'Hanlon	1,940
OriginalGriff	1,415
Graeme_Grant	895
Richard Deeming	853
Dave Kreskowiak	694