Edit groupid of students based on their common interests

Question

0.00/5 (No votes)

See more:

I have a list of students with their subject of interests (separated by comma).

C#

List<Students> students = new List<Students>();	
						   
students.Add(new Students() { Name = "Krishna", GroupID= 0, Interests = "Physics,Maths" });

students.Add(new Students() { Name = "Ganesh", GroupID= 0, Interests = "History,Physics" });

students.Add(new Students() { Name = "Jayesh", GroupID= 0, Interests = "Tech,Humanity" });

students.Add(new Students() { Name = "Aditya", GroupID= 0, Interests = "Science"});

students.Add(new Students() { Name = "Ramesh", GroupID= 0, Interests = "Programming,Science"});

I want to use the Linq to edit the GroupID of students in the same list based on their common interests.

Expected Output:

GroupID: 1
Students: Krishna, Ganesh
(Reason: Common interest in Physics)

GroupID: 2
Students: Aditya, Ramesh
(Reason: Common interest in Science)

Any help is greatly appreciated.

Thank you so much!

What I have tried:

Unfortunately, I'm not sure how to do this as I'm new to programming.

Posted 16-Aug-22 7:29am

Cat Lover

Updated 16-Aug-22 13:21pm

PIEBALDconsult

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...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)

OriginalGriff · Answer 1 · 2022-08-16T08:13:00

If you are new to programming, then the best advice I can give you with the problem as it stands is this: don't do it. Don't even try.

The problem is that you have made a big mistake in your DB / data design, and it's going to be a nightmare to sort out without some serious work on your part. And the mistake is that you are trying to store multiple pieces of information in a single item because that's "easy to do": storing the interests as a single string is easy to insert data, but a real PITA to process when you want to do anything complicated.

What you need to do is redesign your data, so you have a separate Interest class which stores the interest description as a separate string and a collection in your Student class which references individual Interest instances (think about a List<t> as a good start).

Then when you want to find common interests, it becomes a whole load easier: you can group students together by Interest instances and pick up the separate Student instances from that.

Think about it and you'll see what I mean.