0

I got involved with a task to match two datasets that baffles me to no end. I have two sample datasets.

The first dataset has the courses that students enrolled during the term

DS1

enter image description here

The second dataset has the visits in tutoring centers. Here I do not have course title I have only reason for tutoring.

DS2 enter image description here

Using these two datasets I am trying to match courses with tutoring visits and end up with the following table:

enter image description here

The criteria for matching to have this table are:

a) if tutoring reason has similarity with the title of the course then tutored in course = yes

b) if a student visited a tutoring center regardless the matching of the title of the course then tutored in term = yes

c) If there is a same word in the cells (i.e. Course and Tutoring Reason) between then the two cells match

d) If there is a different but similar subject between the two cells and there is no other cell with similar word at the same term then the two cells (i.e. Course and Tutoring Reason) match

I am not sure even if that is possible through sql - How you would go to get to this table?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.