I have two data sets, each contains ID collum and a grade collum. Each has same number of values and same ID's. Im trying to calculate a Pearson between them, but i cant figure out how to sort the data so it matches two grades for each ID.
The ID's are not sorted in the same order, and by using "group by" or "sort" i cant seem to crack this one down.
thank you for usefull suggestions