I have a huge dataset of 1600 rows and 13 columns, every three rows present data of a single person, while the columns are characteristics of this person. I want to get the median of all columns for every person (3 rows).
For example, from this:
C1 C2 C3 C4 C5...
R1 1 2 3 4 5
R2 6 7 8 9 1
R3 2 3 4 5 6
R4 7 6 9 8 3
R5 3 4 6 2 5
R6 9 7 4 3 2
R7 2 5 9 7 6
R8 3 5 8 3 2
R9 9 4 6 5 8
I would like to get the following:
C1 C2 C3 C4 C5
R1 2 3 4 5 5
R2 7 6 6 3 3
R3 3 5 8 5 6
. . .