How to calculate multiple correlation matrices by looping through subset (based on feature values)

12345671234567 Member Posts: 1 Contributor I
edited November 2018 in Help

Dear community,

 

I have a data set that contains student names, their marks in different courses and the number of times they showed up for classes, like e.g.:

 

Max Mustermann | Database Technology | 2.3 | 10

Max Mustermann | Computer Science Intro | 1.3 | 12

Maria Musterfrau | Computer Science Intro | 2.0 | 13

...

 

So Max showed up 10 times at DB and got a 2.3 (mark) in the end.

 

Now, for each student in the data set, I want to calculate the correlation coefficient between mark and number of times attended.

 

The output should look like this:

 

Student name | Correlationcoefficient between mark and number of times attended (considering all courses the respective student took)

Max Mustermann | 0,711

Maria Musterfrau | -0,312

...

 

Everything works fine, except that I don't know how to best do the looping and producing the final table (e.g. using "correlation matrix").

 

I would appreciate your help. Thanks in advance and kind regards.

Answers

  • Thomas_OttThomas_Ott RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,761 Unicorn

    So your loop calculates the average and # of attendance for each student?  Then take the resulting exampleset and connect a correlation matrix operator to it.Out put the MAT port

Sign In or Register to comment.