I have a data frame which reads as such....
| Player | Fixture | Minutes |
|---|---|---|
| Player 1 | 13 | 90 |
| Player 2 | 13 | 90 |
| Player 3 | 13 | 60 |
| Player 4 | 13 | 30 |
| Player 1 | 19 | 90 |
| Player 2 | 19 | 13 |
| Player 3 | 19 | 77 |
| Player 4 | 19 | 90 |
| Player 1 | 25 | 90 |
| Player 2 | 25 | 0 |
| Player 3 | 25 | 45 |
| Player 4 | 25 | 90 |
| Player 1 | 34 | 90 |
| Player 2 | 34 | 30 |
| Player 3 | 34 | 90 |
| Player 4 | 34 | 45 |
I'd like to be able to re-format it into a df which reads as follows, with each column being a fixture.
| / | 13 | 19 | 25 | 34 |
|---|---|---|---|---|
| Player 1 | 90 | 90 | 90 | 90 |
| Player 2 | 90 | 13 | 0 | 30 |
| Player 3 | 60 | 77 | 45 | 90 |
| Player 4 | 30 | 90 | 90 | 45 |
Thanks for you help :)