dfLong=pivot_longer(dfWide2,cols=-ID_Subject) %>% separate(col="name",sep="_",into=c("Exercise","RPM","Measure")) %>% mutate(RPM=str_replace(RPM,"RPM","") %>% as.integer()) %>% arrange(ID_Subject,Exercise,RPM)dfLong2=dfLong %>% pivot_wider(names_from = Measure,values_from = value)
#openxlsx::write.xlsx(list(Wide=dfWide2,Long1=dfLong,Long2=dfLong2),file="datosConvertidos.xlsx")table1( ~ . | Exercise*RPM ,data=dfLong2 %>% select(-ID_Subject))## Warning in table1.formula(~. | Exercise * RPM, data = dfLong2 %>% select(-
## ID_Subject)): Terms to the right of '|' in formula 'x' define table columns
## and are expected to be factors with meaningful labels.## Warning in .table1.internal(x = x, labels = labels, groupspan =
## groupspan, : Table has 14 columns. Are you sure this is what you want?CON |
ECC |
ECCFc30 |
ECCFc60 |
Reposo |
Overall |
|||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15 (n=30) |
30 (n=30) |
60 (n=30) |
15 (n=30) |
30 (n=30) |
15 (n=30) |
30 (n=30) |
15 (n=30) |
30 (n=30) |
0 (n=30) |
0 (n=30) |
15 (n=120) |
30 (n=120) |
60 (n=30) |
|
| Exercise | ||||||||||||||
| CON | 30 (100%) | 30 (100%) | 30 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 30 (25.0%) | 30 (25.0%) | 30 (100%) |
| ECC | 0 (0%) | 0 (0%) | 0 (0%) | 30 (100%) | 30 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 30 (25.0%) | 30 (25.0%) | 0 (0%) |
| ECCFc30 | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 30 (100%) | 30 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 30 (25.0%) | 30 (25.0%) | 0 (0%) |
| ECCFc60 | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 30 (100%) | 30 (100%) | 0 (0%) | 0 (0%) | 30 (25.0%) | 30 (25.0%) | 0 (0%) |
| Reposo | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 30 (100%) | 30 (100%) | 0 (0%) | 0 (0%) | 0 (0%) |
| RPM | ||||||||||||||
| Mean (SD) | 15.0 (0.00) | 30.0 (0.00) | 60.0 (0.00) | 15.0 (0.00) | 30.0 (0.00) | 15.0 (0.00) | 30.0 (0.00) | 15.0 (0.00) | 30.0 (0.00) | 0.00 (0.00) | 0.00 (0.00) | 15.0 (0.00) | 30.0 (0.00) | 60.0 (0.00) |
| Median [Min, Max] | 15.0 [15.0, 15.0] | 30.0 [30.0, 30.0] | 60.0 [60.0, 60.0] | 15.0 [15.0, 15.0] | 30.0 [30.0, 30.0] | 15.0 [15.0, 15.0] | 30.0 [30.0, 30.0] | 15.0 [15.0, 15.0] | 30.0 [30.0, 30.0] | 0.00 [0.00, 0.00] | 0.00 [0.00, 0.00] | 15.0 [15.0, 15.0] | 30.0 [30.0, 30.0] | 60.0 [60.0, 60.0] |
| T1O2Hb | ||||||||||||||
| Mean (SD) | NA (NA) | NA (NA) | NA (NA) | NA (NA) | NA (NA) | NA (NA) | NA (NA) | NA (NA) | NA (NA) | 5.88 (18.0) | 5.88 (18.0) | NA (NA) | NA (NA) | NA (NA) |
| Median [Min, Max] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | 1.15 [-9.63, 76.6] | 1.15 [-9.63, 76.6] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] |
| Missing | 30 (100%) | 30 (100%) | 30 (100%) | 30 (100%) | 30 (100%) | 30 (100%) | 30 (100%) | 30 (100%) | 30 (100%) | 5 (16.7%) | 5 (16.7%) | 120 (100%) | 120 (100%) | 30 (100%) |
| T1HHb | ||||||||||||||
| Mean (SD) | NA (NA) | NA (NA) | NA (NA) | NA (NA) | NA (NA) | NA (NA) | NA (NA) | NA (NA) | NA (NA) | 8.57 (16.0) | 8.57 (16.0) | NA (NA) | NA (NA) | NA (NA) |
| Median [Min, Max] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | 1.06 [-3.05, 69.5] | 1.06 [-3.05, 69.5] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] |
| Missing | 30 (100%) | 30 (100%) | 30 (100%) | 30 (100%) | 30 (100%) | 30 (100%) | 30 (100%) | 30 (100%) | 30 (100%) | 5 (16.7%) | 5 (16.7%) | 120 (100%) | 120 (100%) | 30 (100%) |
| T1tHb | ||||||||||||||
| Mean (SD) | NA (NA) | NA (NA) | NA (NA) | NA (NA) | NA (NA) | NA (NA) | NA (NA) | NA (NA) | NA (NA) | 14.5 (33.2) | 14.5 (33.2) | NA (NA) | NA (NA) | NA (NA) |
| Median [Min, Max] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | 1.79 [-7.05, 146] | 1.79 [-7.05, 146] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] |
| Missing | 30 (100%) | 30 (100%) | 30 (100%) | 30 (100%) | 30 (100%) | 30 (100%) | 30 (100%) | 30 (100%) | 30 (100%) | 5 (16.7%) | 5 (16.7%) | 120 (100%) | 120 (100%) | 30 (100%) |
| T1HbDiff | ||||||||||||||
| Mean (SD) | NA (NA) | NA (NA) | NA (NA) | NA (NA) | NA (NA) | NA (NA) | NA (NA) | NA (NA) | NA (NA) | -2.69 (7.81) | -2.69 (7.81) | NA (NA) | NA (NA) | NA (NA) |
| Median [Min, Max] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] | -0.656 [-20.4, 8.03] | -0.656 [-20.4, 8.03] | NA [NA, NA] | NA [NA, NA] | NA [NA, NA] |
| Missing | 30 (100%) | 30 (100%) | 30 (100%) | 30 (100%) | 30 (100%) | 30 (100%) | 30 (100%) | 30 (100%) | 30 (100%) | 5 (16.7%) | 5 (16.7%) | 120 (100%) | 120 (100%) | 30 (100%) |
| VO2 | ||||||||||||||
| Mean (SD) | NA (NA) | 10.1 (2.40) | 17.1 (3.84) | 8.35 (2.12) | 10.0 (3.40) | 8.55 (1.79) | 9.09 (2.06) | 11.1 (2.47) | 12.3 (2.53) | 5.79 (1.52) | 5.79 (1.52) | 9.33 (2.47) | 10.4 (2.86) | 17.1 (3.84) |
| Median [Min, Max] | NA [NA, NA] | 10.2 [4.57, 14.7] | 16.9 [8.87, 24.2] | 8.09 [4.52, 12.8] | 9.28 [4.66, 22.2] | 8.43 [4.88, 11.8] | 8.92 [5.42, 13.6] | 10.9 [7.37, 16.0] | 12.0 [7.73, 17.3] | 5.51 [3.48, 8.16] | 5.51 [3.48, 8.16] | 8.97 [4.52, 16.0] | 10.1 [4.57, 22.2] | 16.9 [8.87, 24.2] |
| Missing | 30 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 30 (25.0%) | 0 (0%) | 0 (0%) |
| TSI | ||||||||||||||
| Mean (SD) | NA (NA) | 67.2 (11.4) | 66.9 (8.79) | 66.2 (12.7) | 67.9 (11.7) | 67.7 (13.0) | 67.4 (11.7) | 67.5 (12.7) | 67.1 (11.9) | 66.0 (7.66) | 66.0 (7.66) | 67.1 (12.7) | 67.4 (11.5) | 66.9 (8.79) |
| Median [Min, Max] | NA [NA, NA] | 68.6 [47.3, 99.9] | 67.1 [47.3, 79.6] | 65.8 [40.8, 88.4] | 67.6 [44.3, 86.8] | 70.0 [40.7, 86.9] | 68.0 [42.9, 83.6] | 70.2 [42.8, 84.9] | 68.9 [45.5, 84.3] | 66.5 [47.5, 79.1] | 66.5 [47.5, 79.1] | 69.4 [40.7, 88.4] | 68.2 [42.9, 99.9] | 67.1 [47.3, 79.6] |
| Missing | 30 (100%) | 5 (16.7%) | 3 (10.0%) | 2 (6.7%) | 3 (10.0%) | 3 (10.0%) | 2 (6.7%) | 3 (10.0%) | 2 (6.7%) | 4 (13.3%) | 4 (13.3%) | 38 (31.7%) | 12 (10.0%) | 3 (10.0%) |
| SBP | ||||||||||||||
| Mean (SD) | NA (NA) | 148 (31.1) | 164 (38.8) | 154 (22.7) | 155 (26.9) | 159 (24.1) | 155 (26.4) | 164 (28.6) | 165 (27.8) | 145 (31.6) | 145 (31.6) | 159 (25.3) | 156 (28.4) | 164 (38.8) |
| Median [Min, Max] | NA [NA, NA] | 147 [68.3, 207] | 161 [75.7, 258] | 151 [118, 200] | 148 [110, 214] | 152 [123, 212] | 150 [112, 220] | 162 [113, 217] | 164 [118, 237] | 141 [77.7, 214] | 141 [77.7, 214] | 154 [113, 217] | 153 [68.3, 237] | 161 [75.7, 258] |
| Missing | 30 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 1 (3.3%) | 1 (3.3%) | 30 (25.0%) | 0 (0%) | 0 (0%) |
| DBP | ||||||||||||||
| Mean (SD) | NA (NA) | 79.6 (17.9) | 85.5 (21.7) | 87.3 (12.3) | 87.7 (15.7) | 90.6 (14.2) | 89.1 (16.1) | 91.1 (17.8) | 93.6 (17.0) | 83.1 (21.1) | 83.1 (21.1) | 89.7 (14.9) | 87.5 (17.3) | 85.5 (21.7) |
| Median [Min, Max] | NA [NA, NA] | 80.1 [30.7, 102] | 85.9 [25.4, 152] | 85.0 [69.9, 121] | 84.9 [65.3, 126] | 85.9 [71.2, 123] | 85.9 [63.6, 121] | 88.2 [69.6, 130] | 92.7 [56.0, 127] | 83.0 [34.3, 132] | 83.0 [34.3, 132] | 85.9 [69.6, 130] | 86.4 [30.7, 127] | 85.9 [25.4, 152] |
| Missing | 30 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 1 (3.3%) | 1 (3.3%) | 30 (25.0%) | 0 (0%) | 0 (0%) |
| CO | ||||||||||||||
| Mean (SD) | NA (NA) | 4.88 (2.66) | 5.73 (1.70) | 4.24 (0.937) | 4.52 (1.13) | 4.28 (1.20) | 4.28 (1.25) | 4.85 (1.71) | 5.05 (2.24) | 3.60 (1.16) | 3.60 (1.16) | 4.46 (1.34) | 4.68 (1.93) | 5.73 (1.70) |
| Median [Min, Max] | NA [NA, NA] | 4.44 [2.68, 18.3] | 5.50 [2.76, 9.12] | 4.19 [2.88, 6.32] | 4.39 [2.86, 6.80] | 4.27 [2.03, 8.48] | 4.31 [2.17, 7.17] | 4.67 [2.11, 10.1] | 4.40 [2.69, 14.6] | 3.36 [1.91, 7.09] | 3.36 [1.91, 7.09] | 4.39 [2.03, 10.1] | 4.35 [2.17, 18.3] | 5.50 [2.76, 9.12] |
| Missing | 30 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 1 (3.3%) | 1 (3.3%) | 30 (25.0%) | 0 (0%) | 0 (0%) |
| RPE | ||||||||||||||
| Mean (SD) | NA (NA) | 13.4 (5.80) | 19.2 (8.21) | 14.7 (7.40) | 18.7 (10.4) | 16.4 (8.18) | 18.3 (8.62) | 24.1 (11.9) | 25.3 (11.8) | 0.00 (0.00) | 0.00 (0.00) | 18.4 (10.1) | 18.9 (10.2) | 19.2 (8.21) |
| Median [Min, Max] | NA [NA, NA] | 13.5 [2.00, 25.0] | 20.0 [6.00, 40.0] | 14.0 [2.00, 35.0] | 20.0 [5.00, 65.0] | 15.5 [3.00, 40.0] | 19.0 [5.00, 40.0] | 25.0 [7.00, 65.0] | 25.0 [10.0, 65.0] | 0.00 [0.00, 0.00] | 0.00 [0.00, 0.00] | 17.5 [2.00, 65.0] | 18.5 [2.00, 65.0] | 20.0 [6.00, 40.0] |
| Missing | 30 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 30 (25.0%) | 0 (0%) | 0 (0%) |
| DOMS | ||||||||||||||
| Mean (SD) | NA (NA) | 7.70 (6.89) | 16.2 (13.0) | 13.7 (8.66) | 18.0 (11.4) | 17.2 (10.1) | 17.4 (9.54) | 25.9 (16.7) | 24.3 (12.8) | 0.00 (0.00) | 0.00 (0.00) | 18.9 (13.2) | 16.9 (11.9) | 16.2 (13.0) |
| Median [Min, Max] | NA [NA, NA] | 7.00 [0.00, 25.0] | 15.0 [0.00, 70.0] | 14.0 [0.00, 35.0] | 19.0 [0.00, 60.0] | 20.0 [0.00, 35.0] | 20.0 [0.00, 37.0] | 25.0 [0.00, 85.0] | 24.0 [0.00, 50.0] | 0.00 [0.00, 0.00] | 0.00 [0.00, 0.00] | 18.5 [0.00, 85.0] | 17.5 [0.00, 60.0] | 15.0 [0.00, 70.0] |
| Missing | 30 (100%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | 30 (25.0%) | 0 (0%) | 0 (0%) |
| POWER | ||||||||||||||
| Mean (SD) | NA (NA) | 25.4 (12.0) | 58.4 (21.1) | 51.3 (21.0) | 102 (40.8) | 65.6 (37.7) | 107 (43.4) | 85.0 (24.0) | 163 (54.4) | 0.00 (0.00) | 0.00 (0.00) | 67.1 (31.4) | 98.5 (64.3) | 58.4 (21.1) |
| Median [Min, Max] | NA [NA, NA] | 22.1 [9.98, 51.1] | 55.1 [23.6, 105] | 51.8 [13.9, 89.9] | 98.9 [35.4, 209] | 59.2 [6.16, 201] | 104 [47.3, 224] | 85.2 [41.4, 144] | 173 [57.6, 277] | 0.00 [0.00, 0.00] | 0.00 [0.00, 0.00] | 66.8 [6.16, 201] | 95.1 [9.98, 277] | 55.1 [23.6, 105] |
| Missing | 30 (100%) | 0 (0%) | 0 (0%) | 1 (3.3%) | 4 (13.3%) | 1 (3.3%) | 2 (6.7%) | 2 (6.7%) | 1 (3.3%) | 0 (0%) | 0 (0%) | 34 (28.3%) | 7 (5.8%) | 0 (0%) |