I have two data frames.
One contains a number of participants that have a score each. For instance:
participant score
Sally 2
Bill 2
Maria 5
Sophie 1
Jack 2
Now I have a second dataframe which tells me additional number to match with each score. Its first column contains every score possible. For instance:
Score number 1 number 2
1 365.85 738.94
2 64985.8 746.9
3 36.98 254.0
4 738.9 738.98
5 73.96 77.9
In reality the data is much larger. Now I want to match them. So each participant should get number 1 and number 2 BASED ON their score.
Can anybody help? Thank you!