R statistics, change ranked tables to paired
- by cousin_pete
I have data for many tables like:
event_id player finish
1 a 1
1 b 2
1 c 3
1 d 4
2 b 1
2 e 2
2 f 3
2 a 3
2 g 5
Many event_id's, each from 5 to 20 players, finish may be tied.
In order to use conditional logistic regression in R I would like to reformat the tables to be like:
event_id player1 player2 result
1 a b 1
1 a c 1
1 a d 1
1 b c 1
1 b d 1
1 c d 1
2 b e 1
2 b f 1
2 b a 1
2 b g 1
2 e f 1
2 e a 1
2 e g 1
2 f a 0.5
2 f g 1
2 a g 1
An event_id of 4 players will have 4*3/2 = 6 records
in the new table, 5 players will have 5*4/2 = 10 records
and so on.
If player "a" has "finish" less than player "b" the "result"
is 1. If "finish" is equal the "result" is 0.5.
If player "a" has finish greater than player "b" then
the "result" would be 0.
Any help appreciated!
