我想计算医学上的某个指标,但它的定义有些复杂。首先“夜间”定义为血压监测时间在22:00-6:00;然后要产生两个新的变量,一个就是起床时间以后2小时内收缩压的平均值,另外一个就是包括“夜间”最低收缩压在内的前后三个收缩压的平均值。用前面的指标减去后面的指标就是我要计算的指标。我是新手,请大家多多帮忙,非常感谢!
编号 | 姓名 | 睡觉时间 | 起床时间 | 日期 | 血压监测时间 | 收缩压 | 舒张压 |
CPNBR | NAME | SleepT | WakeT | DATE | TIME | SYS | DIA |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 9:09 | 175 | 111 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 9:42 | 199 | 83 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 10:00 | 155 | 98 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 10:20 | 157 | 86 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 10:40 | 136 | 86 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 11:00 | 131 | 77 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 11:20 | 130 | 82 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 11:40 | 149 | 98 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 12:00 | 163 | 82 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 12:20 | 121 | 65 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 12:40 | 101 | 58 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 13:00 | 118 | 61 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 13:20 | 117 | 69 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 13:40 | 110 | 75 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 14:00 | 110 | 63 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 14:20 | 131 | 71 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 14:40 | 115 | 74 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 15:01 | 136 | 108 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 15:20 | 158 | 54 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 15:40 | 146 | 82 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 16:01 | 157 | 98 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 16:20 | 157 | 87 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 16:40 | 201 | 115 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 17:01 | 191 | 123 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 17:20 | 155 | 98 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 17:40 | 161 | 103 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 18:00 | 158 | 88 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 18:20 | 152 | 98 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 18:40 | 152 | 90 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 19:00 | 177 | 63 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 19:20 | 138 | 79 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 19:40 | 165 | 87 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 20:00 | 158 | 93 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 20:20 | 161 | 96 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 20:40 | 149 | 91 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 21:00 | 152 | 81 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 21:20 | 135 | 78 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 21:40 | 136 | 85 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 22:00 | 158 | 89 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 22:30 | 153 | 81 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 23:00 | 131 | 75 |
11 | QWM | 21:00 | 6:00 | 2012-4-16 | 23:30 | 139 | 76 |
11 | QWM | 21:00 | 6:00 | 2012-4-17 | 0:00 | 138 | 92 |
11 | QWM | 21:00 | 6:00 | 2012-4-17 | 0:30 | 141 | 81 |
11 | QWM | 21:00 | 6:00 | 2012-4-17 | 1:00 | 125 | 70 |
11 | QWM | 21:00 | 6:00 | 2012-4-17 | 1:30 | 121 | 63 |
11 | QWM | 21:00 | 6:00 | 2012-4-17 | 2:00 | 141 | 87 |
11 | QWM | 21:00 | 6:00 | 2012-4-17 | 2:30 | 140 | 84 |
11 | QWM | 21:00 | 6:00 | 2012-4-17 | 3:00 | 132 | 84 |
11 | QWM | 21:00 | 6:00 | 2012-4-17 | 3:30 | 123 | 72 |
11 | QWM | 21:00 | 6:00 | 2012-4-17 | 4:00 | 134 | 73 |
11 | QWM | 21:00 | 6:00 | 2012-4-17 | 4:30 | 141 | 77 |
11 | QWM | 21:00 | 6:00 | 2012-4-17 | 5:00 | 144 | 72 |
11 | QWM | 21:00 | 6:00 | 2012-4-17 | 5:30 | 143 | 83 |
11 | QWM | 21:00 | 6:00 | 2012-4-17 | 6:00 | 156 | 91 |
11 | QWM | 21:00 | 6:00 | 2012-4-17 | 6:20 | 157 | 91 |
11 | QWM | 21:00 | 6:00 | 2012-4-17 | 6:40 | 170 | 100 |
11 | QWM | 21:00 | 6:00 | 2012-4-17 | 7:00 | 165 | 92 |
11 | QWM | 21:00 | 6:00 | 2012-4-17 | 7:20 | 168 | 108 |
11 | QWM | 21:00 | 6:00 | 2012-4-17 | 7:40 | 162 | 102 |
11 | QWM | 21:00 | 6:00 | 2012-4-17 | 8:00 | 148 | 88 |
11 | QWM | 21:00 | 6:00 | 2012-4-17 | 8:20 | 160 | 90 |
11 | QWM | 21:00 | 6:00 | 2012-4-17 | 8:40 | 168 | 95 |
11 | QWM | 21:00 | 6:00 | 2012-4-17 | 9:01 | 155 | 114 |