Para realiazar limpieza de datos en R, se recomienda usar el paquete tidyverse que contiene el paquete dyplr y este a su vez contiene la funcion select. Para mayor información dirijase a la pagina http://dyplr.tidyverse.org.
library(dplyr)
temperatura %>%select(valorobservado, departamento, longitud, latitud)## valorobservado departamento longitud latitud
## 1 34.30 META -72.56447 4.2603611
## 2 23.30 AMAZONAS -70.36300 -3.7800000
## 3 24.10 META -73.62500 4.1373889
## 4 4.10 CALDAS -75.37583 4.8298056
## 5 33.40 META -73.62500 4.1373889
## 6 20.40 CAUCA -77.22167 2.0327778
## 7 5.50 CUNDINAMARCA -73.52508 5.2360556
## 8 18.10 CALDAS -75.50714 5.0852500
## 9 29.90 ANTIOQUIA -74.79472 6.5716389
## 10 17.00 CUNDINAMARCA -73.85175 5.3038056
## 11 19.60 BOYACÁ -73.25669 4.8412500
## 12 7.40 CAUCA -76.40354 2.3568489
## 13 11.00 TOLIMA -75.17328 4.8705556
## 14 13.10 CALDAS -75.45111 4.9009167
## 15 27.80 PUTUMAYO -76.65183 1.1573333
## 16 13.00 CUNDINAMARCA -73.82733 4.6610000
## 17 25.10 ANTIOQUIA -75.58900 6.2210000
## 18 8.80 SANTANDER -72.86850 7.1870000
## 19 10.60 CUNDINAMARCA -73.85175 5.3038056
## 20 32.40 SUCRE -75.28925 9.3570833
## 21 22.20 PUTUMAYO -76.65183 1.1573333
## 22 12.60 SANTANDER -72.83560 6.1877944
## 23 34.60 SANTANDER -73.70489 6.9829722
## 24 20.40 CAUCA -76.58129 2.4748331
## 25 29.80 CESAR -73.52394 9.6406111
## 26 26.70 VALLE DEL CAUCA -77.34901 3.9251472
## 27 12.70 CALDAS -75.36161 4.8406667
## 28 34.40 SANTANDER -73.70489 6.9829722
## 29 14.20 BOGOTA -74.10267 4.6693333
## 30 27.20 NORTE DE SANTANDER -72.48717 7.8987778
## 31 36.60 MAGDALENA -74.18592 11.2230556
## 32 26.80 CÓRDOBA -75.55400 7.9310000
## 33 19.10 BOYACÁ -73.25669 4.8412500
## 34 25.50 SUCRE -75.66700 9.3830000
## 35 22.10 BOYACÁ -73.43600 5.0991944
## 36 25.20 ANTIOQUIA -74.79700 6.7740000
## 37 27.30 ANTIOQUIA -75.44222 7.1572778
## 38 18.60 TOLIMA -75.17328 4.8705556
## 39 27.30 SUCRE -75.14269 8.5968333
## 40 21.70 ANTIOQUIA -74.79472 6.5716389
## 41 23.90 HUILA -76.11433 2.0215833
## 42 17.20 TOLIMA -75.17328 4.8705556
## 43 25.30 NARIÑO -77.34361 1.6185000
## 44 25.70 ATLÁNTICO -74.91900 10.6370000
## 45 15.60 HUILA -76.10684 1.6758330
## 46 19.20 NARIÑO -78.09250 1.2483333
## 47 27.10 AMAZONAS -70.36300 -3.7800000
## 48 15.10 CUNDINAMARCA -73.85175 5.3038056
## 49 23.50 META -73.62500 4.1373889
## 50 10.50 CASANARE -71.41983 5.8161944
## 51 14.30 HUILA -76.11433 2.0215833
## 52 21.90 PUTUMAYO -76.66711 1.0828889
## 53 31.90 CASANARE -72.38800 5.3200000
## 54 19.00 RISARALDA -75.74492 4.7619167
## 55 17.90 ANTIOQUIA -75.61279 6.2863333
## 56 23.00 CASANARE -71.66600 5.4190000
## 57 14.60 HUILA -76.11433 2.0215833
## 58 11.30 BOYACÁ -72.99703 5.9854167
## 59 32.90 CUNDINAMARCA -74.80811 4.3053333
## 60 28.90 PUTUMAYO -76.65183 1.1573333
## 61 25.70 NARIÑO -77.34361 1.6185000
## 62 25.70 SAN ANDRÉS PROVIDENCIA -79.85200 15.7970000
## 63 8.40 ANTIOQUIA -75.64444 6.6320278
## 64 6.60 BOGOTA -74.15000 4.3500000
## 65 12.50 TOLIMA -75.70083 4.0758056
## 66 4.90 BOYACÁ -72.31417 6.5091111
## 67 30.00 HUILA -75.08153 3.1330556
## 68 17.20 ANTIOQUIA -74.79700 6.7740000
## 69 27.30 CHOCÓ -77.26600 5.7080000
## 70 21.30 ANTIOQUIA -74.79700 6.7740000
## 71 22.30 CAQUETA -75.64503 1.7330000
## 72 9.10 ANTIOQUIA -75.56089 6.7810833
## 73 22.00 BOYACÁ -73.35039 5.2192500
## 74 15.50 BOYACÁ -73.11636 5.7459167
## 75 13.00 BOGOTA -74.08908 4.6380833
## 76 19.60 SANTANDER -73.06600 7.1000000
## 77 19.80 CHOCÓ -76.23200 4.8980000
## 78 19.80 ANTIOQUIA -74.79700 6.7740000
## 79 13.60 BOYACÁ -72.91115 5.7533333
## 80 15.10 BOYACÁ -73.43600 5.0991944
## 81 6.80 CAUCA -76.40354 2.3568489
## 82 18.70 CESAR -73.39242 10.7321389
## 83 17.00 CAUCA -76.59500 2.6990000
## 84 23.60 META -73.62500 4.1373889
## 85 25.50 CÓRDOBA -75.84400 9.2530000
## 86 48.60 AMAZONAS -70.36300 -3.7800000
## 87 27.10 CORDOBA -75.91389 8.7469444
## 88 31.60 MAGDALENA -74.18592 11.2230556
## 89 24.80 CAUCA -78.17400 2.9630000
## 90 6.80 SANTANDER -72.69633 6.9453889
## 91 14.80 CESAR -73.04619 10.0290833
## 92 16.20 CALDAS -75.51389 5.0486667
## 93 15.50 BOYACÁ -73.35039 5.2192500
## 94 26.80 CUNDINAMARCA -74.30000 4.3670000
## 95 13.60 CALDAS -75.50714 5.0852500
## 96 14.20 HUILA -76.42756 1.9259167
## 97 25.60 CAUCA -78.17400 2.9630000
## 98 22.90 CUNDINAMARCA -73.85175 5.3038056
## 99 16.30 CUNDINAMARCA -73.89833 5.3472222
## 100 28.80 LA GUAJIRA -71.21094 12.0835278
## 101 26.10 TOLIMA -75.24867 4.4183889
## 102 20.50 VALLE DEL CAUCA -76.56931 3.1853611
## 103 10.60 CUNDINAMARCA -74.00119 4.9892222
## 104 15.30 RISARALDA -75.74492 4.7619167
## 105 8.30 CUNDINAMARCA -74.02217 5.0864444
## 106 21.30 RISARALDA -75.90294 5.2074722
## 107 20.60 CUNDINAMARCA -74.47097 5.0168611
## 108 21.60 ANTIOQUIA -75.44222 7.1572778
## 109 27.00 CHOCÓ -77.43300 6.2690000
## 110 19.10 ANTIOQUIA -75.42600 6.1690000
## 111 16.40 ANTIOQUIA -75.61279 6.2863333
## 112 19.90 CUNDINAMARCA -74.38400 4.4770000
## 113 22.50 BOLIVAR -75.10642 9.7157500
## 114 25.70 VALLE DEL CAUCA -77.34901 3.9251472
## 115 15.40 CAUCA -76.06394 2.5481944
## 116 6.20 CALDAS -75.37583 4.8298056
## 117 16.00 CAUCA -76.58129 2.4748331
## 118 28.70 SANTANDER -73.10731 7.1026111
## 119 20.40 NARIÑO -77.34361 1.6185000
## 120 19.60 BOYACÁ -73.16994 5.2949444
## 121 7.30 SANTANDER -72.69633 6.9453889
## 122 19.60 ANTIOQUIA -75.61279 6.2863333
## 123 1.90 CALDAS -75.37583 4.8298056
## 124 27.00 SUCRE -75.14269 8.5968333
## 125 9.40 CUNDINAMARCA -74.02217 5.0864444
## 126 14.20 NORTE DE SANTANDER -72.48536 7.5067222
## 127 22.20 CAQUETA -75.66100 1.4997222
## 128 18.50 QUINDÍO -75.69069 4.5315833
## 129 27.30 VALLE DEL CAUCA -77.34901 3.9251472
## 130 40.00 NORTE DE SANTANDER -72.80306 8.0766667
## 131 28.10 LA GUAJIRA -71.21094 12.0835278
## 132 25.50 CALDAS -75.50714 5.0852500
## 133 27.30 TOLIMA -74.83425 4.7607222
## 134 6.20 BOYACÁ -73.56278 5.3923889
## 135 4.90 NARIÑO -77.38881 0.8431111
## 136 25.00 TOLIMA -74.83425 4.7607222
## 137 6.00 CALDAS -75.37583 4.8298056
## 138 6.50 SANTANDER -72.69633 6.9453889
## 139 13.80 VALLE DEL CAUCA -76.65150 3.4160556
## 140 23.30 CHOCÓ -76.67700 5.0740000
## 141 29.60 CAUCA -78.17400 2.9630000
## 142 12.10 CUNDINAMARCA -73.85175 5.3038056
## 143 7.30 CALDAS -75.37583 4.8298056
## 144 18.50 QUINDÍO -75.69069 4.5315833
## 145 15.90 CAUCA -76.82800 2.4800000
## 146 21.80 CUNDINAMARCA -74.35458 5.4841667
## 147 24.20 LA GUAJIRA -71.21094 12.0835278
## 148 2.40 CÓRDOBA -75.16500 8.2950000
## 149 18.50 VALLE DEL CAUCA -76.18569 3.3140556
## 150 28.50 QUINDÍO -75.69069 4.5315833
## 151 26.20 HUILA -75.16800 3.2340000
## 152 17.40 HUILA -76.11889 2.2211111
## 153 8.10 CUNDINAMARCA -73.84664 4.6648889
## 154 23.30 META -73.62500 4.1373889
## 155 17.80 ANTIOQUIA -75.42600 6.1690000
## 156 15.70 VALLE DEL CAUCA -76.65150 3.4160556
## 157 16.50 CUNDINAMARCA -73.86308 4.6645000
## 158 29.50 CASANARE -72.38800 5.3200000
## 159 32.40 CHOCO -77.08786 8.0367222
## 160 19.90 TOLIMA -75.24867 4.4183889
## 161 12.80 SANTANDER -72.86850 7.1870000
## 162 28.50 VALLE DEL CAUCA -76.30001 3.8348056
## 163 31.90 CUNDINAMARCA -74.47097 5.0168611
## 164 23.20 CHOCÓ -76.60600 4.9560000
## 165 10.10 SANTANDER -72.69633 6.9453889
## 166 9.60 QUINDÍO -75.43096 4.6232500
## 167 26.20 CASANARE -72.38800 5.3200000
## 168 31.80 VALLE DEL CAUCA -75.92519 4.6897778
## 169 20.10 RISARALDA -75.73839 4.9295833
## 170 6.00 TOLIMA -74.96047 4.1881389
## 171 23.90 META -72.56447 4.2603611
## 172 8.70 BOYACÁ -72.45267 6.5067222
## 173 12.10 BOGOTA -74.09433 4.7822222
## 174 2.20 CALDAS -75.36161 4.8406667
## 175 31.20 CÓRDOBA -75.55400 7.9310000
## 176 12.70 BOGOTA D.C. -74.17700 4.5770000
## 177 24.00 VALLE DEL CAUCA -75.92519 4.6897778
## 178 29.50 META -73.46792 4.0573611
## 179 15.50 BOYACÁ -73.43600 5.0991944
## 180 25.20 SANTANDER -73.47206 6.8233889
## 181 13.00 NARIÑO -77.63689 1.0706111
## 182 23.70 CHOCÓ -76.78000 5.9950000
## 183 2.90 CALDAS -75.38047 4.8026111
## 184 18.40 CUNDINAMARCA -74.20900 4.6914167
## 185 21.80 CAQUETA -75.64503 1.7330000
## 186 16.00 ANTIOQUIA -75.78953 5.7991667
## 187 19.60 ANTIOQUIA -74.79472 6.5716389
## 188 26.80 PUTUMAYO -76.65183 1.1573333
## 189 17.00 QUINDÍO -75.59639 4.5283056
## 190 21.00 NARIÑO -77.28339 1.2251111
## 191 8.50 CALDAS -75.42897 4.8866111
## 192 25.80 AMAZONAS -69.94092 -4.1938611
## 193 38.40 CAUCA -77.12028 1.9627778
## 194 28.70 CHOCO -76.97317 5.5210833
## 195 6.70 BOYACÁ -73.56278 5.3923889
## 196 23.80 CASANARE -71.41983 5.8161944
## 197 22.30 MAGDALENA -74.50667 10.5100278
## 198 25.20 LA GUAJIRA -71.21094 12.0835278
## 199 33.40 META -73.58686 4.2738611
## 200 32.50 BOLIVAR -74.85222 10.0644444
## 201 26.80 BOYACÁ -73.25669 4.8412500
## 202 13.70 VALLE DEL CAUCA -76.56931 3.1853611
## 203 11.00 TOLIMA -75.33600 4.6002222
## 204 13.50 NARIÑO -77.27881 1.1600000
## 205 33.60 MAGDALENA -74.13333 10.8500000
## 206 23.40 CALDAS -75.51389 5.0486667
## 207 0.50 CALDAS -75.38047 4.8026111
## 208 15.60 CALDAS -75.51389 5.0486667
## 209 13.30 NARIÑO -77.28339 1.2251111
## 210 10.30 CUNDINAMARCA -74.39806 3.9936111
## 211 20.40 VALLE DEL CAUCA -76.53389 3.3780000
## 212 15.50 BOGOTA -74.08908 4.6380833
## 213 9.90 CUNDINAMARCA -74.02217 5.0864444
## 214 31.90 VALLE DEL CAUCA -76.30001 3.8348056
## 215 22.40 VALLE DEL CAUCA -76.18569 3.3140556
## 216 25.20 SANTANDER -72.96889 6.4700000
## 217 35.00 SUCRE -75.04500 9.1640000
## 218 28.40 VALLE DEL CAUCA -76.18569 3.3140556
## 219 21.10 NARIÑO -77.34361 1.6185000
## 220 24.50 MAGDALENA -74.13333 10.8500000
## 221 1.00 TOLIMA -75.32778 4.6707778
## 222 30.50 CASANARE -72.38800 5.3200000
## 223 12.10 TOLIMA -75.50036 4.4356667
## 224 18.80 QUINDÍO -75.59639 4.5283056
## 225 28.70 BOYACÁ -74.07131 5.6470278
## 226 27.50 VALLE DEL CAUCA -76.56931 3.1853611
## 227 33.50 TOLIMA -74.96047 4.1881389
## 228 10.20 BOYACÁ -73.11636 5.7459167
## 229 10.90 CUNDINAMARCA -73.52508 5.2360556
## 230 21.80 VALLE DEL CAUCA -76.56931 3.1853611
## 231 27.30 ATLÁNTICO -74.78000 10.9180000
## 232 15.50 CAUCA -76.75033 2.1938333
## 233 29.70 CHOCÓ -76.91700 4.7170000
## 234 26.10 MAGDALENA -74.18592 11.2230556
## 235 30.60 ATLANTICO -74.78500 11.0063889
## 236 25.80 VALLE DEL CAUCA -81.60900 4.0960000
## 237 26.30 CÓRDOBA -75.84400 9.2530000
## 238 14.30 HUILA -76.42756 1.9259167
## 239 21.40 TOLIMA -75.65420 3.2058000
## 240 17.90 HUILA -76.10684 1.6758330
## 241 34.70 CUNDINAMARCA -74.80811 4.3053333
## 242 28.30 CHOCÓ -77.11500 7.4390000
## 243 19.20 CESAR -73.04619 10.0290833
## 244 20.20 CAUCA -76.25278 3.1786111
## 245 30.60 CAUCA -77.12028 1.9627778
## 246 23.20 CESAR -73.39242 10.7321389
## 247 18.20 CUNDINAMARCA -74.31175 4.3101111
## 248 23.70 CAQUETA -74.76269 2.0630000
## 249 12.20 CUNDINAMARCA -74.39806 3.9936111
## 250 12.40 CUNDINAMARCA -73.87081 4.7842778
## 251 18.80 BOGOTA D.C. -74.17700 4.5770000
## 252 20.10 ANTIOQUIA -75.42600 6.1690000
## 253 36.50 ATLÁNTICO -74.91900 10.6370000
## 254 23.20 NARIÑO -77.34361 1.6185000
## 255 16.10 CUNDINAMARCA -74.20900 4.6914167
## 256 28.80 CHOCÓ -77.33100 8.6160000
## 257 21.40 VALLE DEL CAUCA -76.56061 3.4255000
## 258 25.70 SUCRE -75.38750 9.3163889
## 259 24.70 PUTUMAYO -76.66711 1.0828889
## 260 33.70 MAGDALENA -74.18592 11.2230556
## 261 19.60 QUINDÍO -75.63528 4.4816667
## 262 2.60 BOYACÁ -72.31417 6.5091111
## 263 28.60 LA GUAJIRA -71.98289 12.2243056
## 264 0.30 CALDAS -75.38047 4.8026111
## 265 31.10 BOLIVAR -75.27828 10.1425833
## 266 24.20 ANTIOQUIA -75.61279 6.2863333
## 267 33.00 META -73.46792 4.0573611
## 268 24.70 CHOCO -77.08786 8.0367222
## 269 20.60 ANTIOQUIA -75.44222 7.1572778
## 270 16.10 NORTE DE SANTANDER -72.48536 7.5067222
## 271 17.20 CAUCA -76.75033 2.1938333
## 272 9.50 CAUCA -76.40354 2.3568489
## 273 29.80 CHOCÓ -76.97700 7.1540000
## 274 16.60 RISARALDA -75.74492 4.7619167
## 275 20.90 BOGOTA -74.08908 4.6380833
## 276 26.10 CHOCO -76.97317 5.5210833
## 277 19.90 BOYACÁ -73.25669 4.8412500
## 278 27.20 META -72.56447 4.2603611
## 279 25.50 LA GUAJIRA -72.91800 11.5300000
## 280 8.30 ANTIOQUIA -75.64444 6.6320278
## 281 29.10 CESAR -73.52394 9.6406111
## 282 11.60 BOGOTA -74.15000 4.3500000
## 283 23.40 CUNDINAMARCA -74.20900 4.6914167
## 284 17.60 ANTIOQUIA -75.61279 6.2863333
## 285 31.50 LA GUAJIRA -71.21094 12.0835278
## 286 11.20 BOYACÁ -72.45267 6.5067222
## 287 16.50 CAUCA -76.59500 2.6990000
## 288 17.40 BOYACÁ -73.23492 5.7496611
## 289 20.50 CUNDINAMARCA -74.48125 5.1376111
## 290 29.10 VALLE DEL CAUCA -75.92519 4.6897778
## 291 37.40 CÓRDOBA -75.82500 8.8260000
## 292 18.60 CAUCA -76.43575 2.4480411
## 293 20.00 ANTIOQUIA -75.55628 5.8595833
## 294 20.70 ANTIOQUIA -75.58900 6.2210000
## 295 13.20 VALLE DEL CAUCA -76.56931 3.1853611
## 296 23.30 SUCRE -75.28925 9.3570833
## 297 12.10 BOGOTA -74.06667 4.6000000
## 298 14.20 QUINDÍO -75.59639 4.5283056
## 299 12.50 CUNDINAMARCA -73.87081 4.7842778
## 300 33.30 CORDOBA -75.91389 8.7469444
## 301 8.40 CUNDINAMARCA -74.02217 5.0864444
## 302 10.00 SANTANDER -72.86850 7.1870000
## 303 30.20 META -72.56447 4.2603611
## 304 18.30 NORTE DE SANTANDER -72.48536 7.5067222
## 305 14.40 NARIÑO -77.28339 1.2251111
## 306 10.80 CALDAS -75.42897 4.8866111
## 307 24.60 AMAZONAS -69.94092 -4.1938611
## 308 8.90 CALDAS -75.42897 4.8866111
## 309 26.30 CAUCA -78.17400 2.9630000
## 310 28.60 CUNDINAMARCA -74.30000 4.3670000
## 311 28.30 NORTE DE SANTANDER -72.51100 7.9320000
## 312 13.90 HUILA -75.07456 2.7591389
## 313 19.20 CUNDINAMARCA -73.86308 4.6645000
## 314 25.80 ANTIOQUIA -75.44222 7.1572778
## 315 18.30 QUINDÍO -75.69069 4.5315833
## 316 27.30 CHOCÓ -77.36200 4.9580000
## 317 12.60 SANTANDER -72.69633 6.9453889
## 318 22.00 TOLIMA -75.24867 4.4183889
## 319 17.00 HUILA -76.11433 2.0215833
## 320 19.40 CUNDINAMARCA -74.31175 4.3101111
## 321 30.50 MAGDALENA -74.18592 11.2230556
## 322 10.00 NARIÑO -77.63689 1.0706111
## 323 20.50 CUNDINAMARCA -73.85175 5.3038056
## 324 24.65 MAGDALENA -73.97300 10.4520000
## 325 31.30 CAUCA -78.17400 2.9630000
## 326 11.50 NORTE DE SANTANDER -72.66606 7.3609444
## 327 24.10 CÓRDOBA -75.84400 9.2530000
## 328 23.80 BOYACÁ -73.11636 5.7459167
## 329 16.10 BOYACÁ -73.43600 5.0991944
## 330 24.20 PUTUMAYO -76.65183 1.1573333
## 331 13.70 CESAR -73.04619 10.0290833
## 332 17.30 BOGOTA D.C. -74.15100 4.7060000
## 333 22.30 ANTIOQUIA -75.41456 6.1319167
## 334 15.60 BOYACÁ -73.43600 5.0991944
## 335 22.10 BOYACÁ -72.91115 5.7533333
## 336 27.50 BOLIVAR -74.85222 10.0644444
## 337 16.90 BOGOTA D.C. -74.17700 4.5770000
## 338 13.90 BOYACÁ -72.45267 6.5067222
## 339 26.10 CAUCA -76.59500 2.6990000
## 340 24.10 ANTIOQUIA -75.44222 7.1572778
## 341 15.00 VALLE DEL CAUCA -76.65150 3.4160556
## 342 25.40 ANTIOQUIA -75.61279 6.2863333
## 343 19.30 TOLIMA -75.24867 4.4183889
## 344 26.50 VALLE DEL CAUCA -76.49972 3.4545000
## 345 20.80 BOYACÁ -73.25669 4.8412500
## 346 11.20 CAUCA -76.43575 2.4480411
## 347 25.10 CÓRDOBA -75.55400 7.9310000
## 348 17.30 HUILA -76.11889 2.2211111
## 349 10.10 CUNDINAMARCA -73.52508 5.2360556
## 350 17.20 ANTIOQUIA -75.42600 6.1690000
## 351 12.40 CUNDINAMARCA -74.20900 4.6914167
## 352 32.20 BOLIVAR -75.27828 10.1425833
## 353 27.10 BOYACÁ -73.16994 5.2949444
## 354 24.80 NARIÑO -77.34361 1.6185000
## 355 29.30 CHOCÓ -77.33100 8.6160000
## 356 9.10 BOGOTA -74.15000 4.3500000
## 357 9.20 ANTIOQUIA -75.64444 6.6320278
## 358 33.60 META -73.62500 4.1373889
## 359 24.70 BOYACÁ -72.99703 5.9854167
## 360 12.90 BOGOTA D.C. -74.17700 4.5770000
## 361 16.50 QUINDÍO -75.69069 4.5315833
## 362 12.30 CUNDINAMARCA -74.39806 3.9936111
## 363 26.50 ATLÁNTICO -74.91900 10.6370000
## 364 22.20 SANTANDER -73.10731 7.1026111
## 365 10.30 TOLIMA -75.17328 4.8705556
## 366 24.30 AMAZONAS -69.94100 -4.1940000
## 367 17.10 BOYACÁ -73.16994 5.2949444
## 368 19.20 TOLIMA -75.24386 4.4703611
## 369 27.40 VALLE DEL CAUCA -76.56931 3.1853611
## 370 23.80 VALLE DEL CAUCA -76.38200 3.5330000
## 371 22.10 QUINDÍO -75.63528 4.4816667
## 372 13.20 CUNDINAMARCA -73.87081 4.7842778
## 373 11.30 CUNDINAMARCA -73.82733 4.6610000
## 374 29.70 BOLIVAR -75.10642 9.7157500
## 375 12.10 BOYACÁ -72.46633 6.1883333
## 376 5.70 CAUCA -76.48203 2.1917222
## 377 25.40 META -73.62500 4.1373889
## 378 4.90 SANTANDER -72.69633 6.9453889
## 379 10.00 CUNDINAMARCA -74.39806 3.9936111
## 380 24.80 ANTIOQUIA -75.55211 6.3297500
## 381 35.80 SANTANDER -73.70489 6.9829722
## 382 24.60 CAUCA -77.89475 2.5744167
## 383 18.80 MAGDALENA -73.92778 10.4653611
## 384 18.00 VALLE DEL CAUCA -76.14428 4.7755833
## 385 25.00 BOYACÁ -73.25669 4.8412500
## 386 28.50 SANTANDER -72.96889 6.4700000
## 387 12.20 TOLIMA -75.50036 4.4356667
## 388 24.60 CORDOBA -75.91389 8.7469444
## 389 35.20 SANTANDER -73.70489 6.9829722
## 390 21.40 CUNDINAMARCA -73.86308 4.6645000
## 391 26.50 MAGDALENA -74.18592 11.2230556
## 392 27.30 CASANARE -72.16700 5.8190000
## 393 26.10 ANTIOQUIA -75.41456 6.1319167
## 394 12.90 CUNDINAMARCA -73.86308 4.6645000
## 395 25.80 CORDOBA -75.91389 8.7469444
## 396 4.30 CUNDINAMARCA -73.80325 4.7136667
## 397 25.00 CUNDINAMARCA -74.65800 5.4928611
## 398 17.40 BOGOTA -74.10267 4.6693333
## 399 16.50 CESAR -73.04619 10.0290833
## 400 10.10 CUNDINAMARCA -73.86308 4.6645000
## 401 24.80 VALLE DEL CAUCA -77.34901 3.9251472
## 402 26.30 VALLE DEL CAUCA -76.53389 3.3780000
## 403 13.30 TOLIMA -75.50036 4.4356667
## 404 9.41 ARAUCA -72.28200 6.3620000
## 405 27.30 MAGDALENA -74.18592 11.2230556
## 406 11.80 BOYACÁ -72.99703 5.9854167
## 407 31.10 SUCRE -75.66700 9.3830000
## 408 7.50 BOYACÁ -72.31417 6.5091111
## 409 24.90 VALLE DEL CAUCA -76.30001 3.8348056
## 410 25.70 VALLE DEL CAUCA -76.53389 3.3780000
## 411 22.50 MAGDALENA -73.92778 10.4653611
## 412 1.90 CALDAS -75.36161 4.8406667
## 413 32.60 VALLE DEL CAUCA -76.30001 3.8348056
## 414 27.30 SANTANDER -72.98750 7.3658333
## 415 21.90 VALLE DEL CAUCA -76.38200 3.5330000
## 416 21.10 PUTUMAYO -76.65183 1.1573333
## 417 27.20 CAUCA -76.58129 2.4748331
## 418 15.10 CAUCA -76.06394 2.5481944
## 419 16.60 ANTIOQUIA -75.61279 6.2863333
## 420 19.80 BOYACÁ -73.16994 5.2949444
## 421 31.10 LA GUAJIRA -71.21094 12.0835278
## 422 19.80 ANTIOQUIA -75.55211 6.3297500
## 423 17.90 NORTE DE SANTANDER -72.48536 7.5067222
## 424 7.30 NARIÑO -77.38881 0.8431111
## 425 6.10 BOGOTA -74.15000 4.3500000
## 426 23.00 ANTIOQUIA -76.69617 7.9407500
## 427 15.30 HUILA -76.11889 2.2211111
## 428 26.10 VALLE DEL CAUCA -76.56931 3.1853611
## 429 21.70 VALLE DEL CAUCA -76.18569 3.3140556
## 430 25.00 ANTIOQUIA -75.55628 5.8595833
## 431 20.20 VALLE DEL CAUCA -76.18569 3.3140556
## 432 13.90 NORTE DE SANTANDER -72.48536 7.5067222
## 433 35.00 CESAR -73.52394 9.6406111
## 434 20.80 CAUCA -77.22167 2.0327778
## 435 26.80 SUCRE -75.04500 9.1640000
## 436 12.50 BOGOTA -74.08908 4.6380833
## 437 24.70 META -73.46792 4.0573611
## 438 33.30 MAGDALENA -74.13333 10.8500000
## 439 22.90 CUNDINAMARCA -73.85175 5.3038056
## 440 21.70 CESAR -73.04619 10.0290833
## 441 23.10 TOLIMA -74.83425 4.7607222
## 442 30.10 MAGDALENA -74.18592 11.2230556
## 443 17.40 HUILA -75.07456 2.7591389
## 444 18.80 HUILA -76.11433 2.0215833
## 445 21.80 ANTIOQUIA -75.55211 6.3297500
## 446 29.30 SAN ANDRÉS PROVIDENCIA -81.73100 12.5420000
## 447 16.40 RISARALDA -75.73839 4.9295833
## 448 14.80 NORTE DE SANTANDER -72.48536 7.5067222
## 449 9.50 ANTIOQUIA -75.64444 6.6320278
## 450 23.50 VALLE DEL CAUCA -76.14428 4.7755833
## 451 26.30 TOLIMA -74.96047 4.1881389
## 452 12.30 CALDAS -75.38242 4.8594444
## 453 13.10 CUNDINAMARCA -74.20900 4.6914167
## 454 28.00 SUCRE -75.14269 8.5968333
## 455 18.00 HUILA -74.70294 3.5897778
## 456 2.60 CALDAS -75.37583 4.8298056
## 457 19.90 BOYACÁ -73.43600 5.0991944
## 458 18.10 CAQUETA -75.64503 1.7330000
## 459 22.40 BOYACÁ -74.07131 5.6470278
## 460 24.10 PUTUMAYO -76.66711 1.0828889
## 461 21.90 META -72.56447 4.2603611
## 462 8.20 CUNDINAMARCA -73.82733 4.6610000
## 463 10.80 NARIÑO -77.63689 1.0706111
## 464 20.30 CAUCA -76.75033 2.1938333
## 465 26.40 CAQUETA -75.66100 1.4997222
## 466 19.60 QUINDÍO -75.69069 4.5315833
## 467 23.30 SANTANDER -73.47206 6.8233889
## 468 13.10 TOLIMA -75.17328 4.8705556
## 469 21.40 BOYACÁ -74.07131 5.6470278
## 470 8.90 CUNDINAMARCA -73.52508 5.2360556
## 471 25.70 BOYACÁ -73.25669 4.8412500
## 472 15.50 SANTANDER -72.86850 7.1870000
## 473 10.20 SANTANDER -73.06600 7.1000000
## 474 14.90 HUILA -76.42756 1.9259167
## 475 27.20 NARINO -78.69600 1.5500000
## 476 14.10 BOYACÁ -72.91115 5.7533333
## 477 22.70 ANTIOQUIA -75.55628 5.8595833
## 478 7.60 BOGOTA -74.15000 4.3500000
## 479 27.80 CESAR -73.52394 9.6406111
## 480 25.20 TOLIMA -74.83425 4.7607222
## 481 8.30 NARIÑO -77.27881 1.1600000
## 482 7.90 CALDAS -75.38242 4.8594444
## 483 27.10 CESAR -73.52394 9.6406111
## 484 20.40 MAGDALENA -73.92778 10.4653611
## 485 17.20 CUNDINAMARCA -74.01667 5.3333333
## 486 18.50 HUILA -76.11889 2.2211111
## 487 18.90 VALLE DEL CAUCA -76.18569 3.3140556
## 488 21.50 VALLE DEL CAUCA -76.10056 3.8791111
## 489 26.10 SUCRE -75.38750 9.3163889
## 490 22.20 BOYACÁ -73.11636 5.7459167
## 491 28.90 TOLIMA -74.83425 4.7607222
## 492 12.80 VALLE DEL CAUCA -76.10056 3.8791111
## 493 22.40 CAQUETA -75.66100 1.4997222
## 494 16.90 CALDAS -75.50714 5.0852500
## 495 10.80 BOYACÁ -73.11636 5.7459167
## 496 11.10 NARIÑO -77.63689 1.0706111
## 497 4.80 CUNDINAMARCA -73.80325 4.7136667
## 498 6.10 CAUCA -76.40354 2.3568489
## 499 24.00 AMAZONAS -70.36300 -3.7800000
## 500 11.10 TOLIMA -75.24867 4.4183889
## 501 7.20 BOGOTA -74.15000 4.3500000
## 502 17.40 TOLIMA -75.17328 4.8705556
## 503 10.60 CUNDINAMARCA -74.20900 4.6914167
## 504 13.60 CUNDINAMARCA -74.38400 4.4770000
## 505 22.20 CUNDINAMARCA -74.20900 4.6914167
## 506 15.40 CUNDINAMARCA -73.87081 4.7842778
## 507 15.30 NORTE DE SANTANDER -73.39750 8.2276944
## 508 27.90 BOLIVAR -75.27828 10.1425833
## 509 26.30 MAGDALENA -74.13333 10.8500000
## 510 13.30 ANTIOQUIA -75.64444 6.6320278
## 511 6.10 BOYACÁ -73.56278 5.3923889
## 512 9.40 CUNDINAMARCA -73.84664 4.6648889
## 513 22.50 VALLE DEL CAUCA -76.65150 3.4160556
## 514 26.90 BOLÍVAR -75.51600 10.4470000
## 515 31.00 MAGDALENA -74.50667 10.5100278
## 516 25.80 CHOCÓ -77.76400 7.1040000
## 517 32.50 CHOCÓ -77.11500 7.4390000
## 518 26.30 CHOCÓ -77.36200 4.9580000
## 519 0.60 BOYACÁ -72.31417 6.5091111
## 520 9.80 ANTIOQUIA -75.64444 6.6320278
## 521 29.60 SUCRE -75.04500 9.1640000
## 522 19.20 HUILA -75.07456 2.7591389
## 523 17.70 RISARALDA -75.74492 4.7619167
## 524 18.50 QUINDÍO -75.63528 4.4816667
## 525 23.10 BOYACÁ -72.91115 5.7533333
## 526 14.10 NARIÑO -77.28339 1.2251111
## 527 26.00 AMAZONAS -70.36300 -3.7800000
## 528 25.40 CAUCA -77.89475 2.5744167
## 529 16.70 CALDAS -75.51389 5.0486667
## 530 28.40 TOLIMA -75.24867 4.4183889
## 531 24.90 CAUCA -77.12028 1.9627778
## 532 13.40 BOGOTA D.C. -74.17700 4.5770000
## 533 1.70 CALDAS -75.37714 4.8203889
## 534 23.13 MAGDALENA -73.92778 10.4653611
## 535 15.50 CUNDINAMARCA -73.82733 4.6610000
## 536 20.30 BOYACÁ -73.11636 5.7459167
## 537 24.10 CAUCA -77.22167 2.0327778
## 538 32.90 MAGDALENA -74.18592 11.2230556
## 539 28.80 VALLE DEL CAUCA -76.53389 3.3780000
## 540 21.70 ANTIOQUIA -75.55628 5.8595833
## 541 21.90 PUTUMAYO -76.65183 1.1573333
## 542 16.50 CUNDINAMARCA -74.39614 4.3957778
## 543 15.40 NORTE DE SANTANDER -72.48536 7.5067222
## 544 16.50 NARIÑO -77.49119 0.9303056
## 545 19.00 RISARALDA -75.74492 4.7619167
## 546 0.10 CALDAS -75.38047 4.8026111
## 547 9.90 CUNDINAMARCA -74.01667 5.3333333
## 548 19.60 META -73.58686 4.2738611
## 549 22.80 RISARALDA -75.90294 5.2074722
## 550 14.60 RISARALDA -75.90294 5.2074722
## 551 17.50 BOYACÁ -73.16994 5.2949444
## 552 17.10 RISARALDA -75.90294 5.2074722
## 553 11.70 NARIÑO -77.27881 1.1600000
## 554 12.10 BOGOTA -74.09433 4.7822222
## 555 24.60 ANTIOQUIA -75.55211 6.3297500
## 556 30.80 NORTE DE SANTANDER -72.51100 7.9320000
## 557 16.40 SANTANDER -72.98750 7.3658333
## 558 25.00 BOYACÁ -74.07131 5.6470278
## 559 26.90 NARIÑO -77.34361 1.6185000
## 560 7.70 BOYACÁ -72.45267 6.5067222
## 561 12.20 ANTIOQUIA -75.56089 6.7810833
## 562 17.10 HUILA -76.11889 2.2211111
## 563 28.20 CUNDINAMARCA -74.30000 4.3670000
## 564 18.30 VALLE DEL CAUCA -76.18569 3.3140556
## 565 29.60 CAUCA -78.17400 2.9630000
## 566 16.70 BOYACÁ -72.88175 5.5566389
## 567 10.20 CUNDINAMARCA -73.84664 4.6648889
## 568 14.80 MAGDALENA -74.05469 11.1110833
## 569 6.80 ANTIOQUIA -75.64444 6.6320278
## 570 21.30 RISARALDA -75.74000 4.8130000
## 571 10.40 CAUCA -76.40354 2.3568489
## 572 1.50 BOYACÁ -72.31417 6.5091111
## 573 23.20 ANTIOQUIA -75.55211 6.3297500
## 574 12.20 CUNDINAMARCA -73.86308 4.6645000
## 575 25.80 CHOCÓ -76.62800 5.2850000
## 576 28.00 CHOCO -76.97317 5.5210833
## 577 23.00 CESAR -73.52394 9.6406111
## 578 20.80 VALLE DEL CAUCA -76.18569 3.3140556
## 579 13.60 BOGOTA -74.09433 4.7822222
## 580 17.00 BOYACÁ -73.16994 5.2949444
## 581 2.10 CALDAS -75.37583 4.8298056
## 582 19.40 NARIÑO -77.28339 1.2251111
## 583 22.30 META -73.46792 4.0573611
## 584 13.30 BOYACÁ -73.11636 5.7459167
## 585 23.30 SUCRE -75.14269 8.5968333
## 586 27.80 MAGDALENA -73.97083 9.0463333
## 587 25.10 VALLE DEL CAUCA -77.34901 3.9251472
## 588 29.40 GUAVIARE -72.64700 2.5530000
## 589 17.50 CUNDINAMARCA -73.85175 5.3038056
## 590 23.90 AMAZONAS -69.94100 -4.1940000
## 591 0.80 CHOCO -77.08786 8.0367222
## 592 23.50 VALLE DEL CAUCA -76.30001 3.8348056
## 593 25.70 BOYACÁ -73.43600 5.0991944
## 594 27.40 META -73.58686 4.2738611
## 595 22.20 SUCRE -75.28925 9.3570833
## 596 27.20 AMAZONAS -70.36300 -3.7800000
## 597 27.10 MAGDALENA -73.97083 9.0463333
## 598 26.30 ATLANTICO -74.78500 11.0063889
## 599 20.60 RISARALDA -75.74000 4.8130000
## 600 13.50 VALLE DEL CAUCA -76.10056 3.8791111
## 601 25.70 VALLE DEL CAUCA -76.53389 3.3780000
## 602 28.60 VALLE DEL CAUCA -76.30001 3.8348056
## 603 21.80 BOYACÁ -74.07131 5.6470278
## 604 26.90 ATLANTICO -75.12694 10.4900000
## 605 20.00 BOYACÁ -73.11636 5.7459167
## 606 20.20 VALLE DEL CAUCA -76.49972 3.4545000
## 607 26.80 NARINO -78.69600 1.5500000
## 608 25.10 ANTIOQUIA -75.41456 6.1319167
## 609 24.60 META -72.56447 4.2603611
## 610 16.70 CAUCA -77.25878 2.3114167
## 611 29.60 META -73.58686 4.2738611
## 612 27.10 LA GUAJIRA -72.32575 11.5949444
## 613 17.30 NARIÑO -77.27881 1.1600000
## 614 27.30 SUCRE -75.14269 8.5968333
## 615 23.40 CALDAS -75.51389 5.0486667
## 616 10.40 CALDAS -75.42897 4.8866111
## 617 23.30 MAGDALENA -74.50667 10.5100278
## 618 32.00 CHOCO -76.97317 5.5210833
## 619 25.50 ANTIOQUIA -76.69617 7.9407500
## 620 0.90 CALDAS -75.38047 4.8026111
## 621 23.40 VALLE DEL CAUCA -76.49972 3.4545000
## 622 18.70 RISARALDA -75.73839 4.9295833
## 623 28.80 CUNDINAMARCA -74.80811 4.3053333
## 624 17.80 CUNDINAMARCA -73.88125 5.0905000
## 625 16.40 SANTANDER -72.96889 6.4700000
## 626 35.10 MAGDALENA -74.27400 9.3040000
## 627 36.80 TOLIMA -74.96047 4.1881389
## 628 29.30 NORTE DE SANTANDER -72.48717 7.8987778
## 629 29.30 PUTUMAYO -76.65183 1.1573333
## 630 8.50 CUNDINAMARCA -73.87081 4.7842778
## 631 15.70 NORTE DE SANTANDER -72.48536 7.5067222
## 632 28.50 ATLANTICO -75.12694 10.4900000
## 633 33.10 CESAR -73.57986 8.1234167
## 634 28.40 CÓRDOBA -75.84400 9.2530000
## 635 19.70 NORTE DE SANTANDER -72.48536 7.5067222
## 636 26.40 CASANARE -72.38800 5.3200000
## 637 11.50 SANTANDER -73.06600 7.1000000
## 638 32.30 MAGDALENA -74.18592 11.2230556
## 639 28.40 CESAR -72.99764 10.3653333
## 640 22.20 PUTUMAYO -76.66711 1.0828889
## 641 23.90 VALLE DEL CAUCA -81.60900 4.0960000
## 642 0.00 CALDAS -75.37714 4.8203889
## 643 15.60 CAUCA -77.22167 2.0327778
## 644 27.40 CHOCÓ -76.97700 7.1540000
## 645 31.40 CUNDINAMARCA -74.80811 4.3053333
## 646 19.70 BOYACÁ -72.91115 5.7533333
## 647 27.20 CAQUETA -75.66100 1.4997222
## 648 22.10 PUTUMAYO -74.89800 -0.1740000
## 649 31.10 ANTIOQUIA -75.55000 6.2530000
## 650 15.50 CALDAS -75.50714 5.0852500
## 651 23.40 NORTE DE SANTANDER -72.66606 7.3609444
## 652 8.10 CALDAS -75.36161 4.8406667
## 653 17.10 CESAR -73.04619 10.0290833
## 654 18.40 ANTIOQUIA -75.58900 6.2210000
## 655 23.50 CUNDINAMARCA -74.65800 5.4928611
## 656 22.60 TOLIMA -75.24386 4.4703611
## 657 26.60 ATLÁNTICO -74.91900 10.6370000
## 658 12.90 ANTIOQUIA -75.64444 6.6320278
## 659 1.00 CALDAS -75.36161 4.8406667
## 660 32.70 CUNDINAMARCA -74.80811 4.3053333
## 661 36.30 MAGDALENA -74.27400 9.3040000
## 662 16.30 HUILA -75.07456 2.7591389
## 663 7.90 CUNDINAMARCA -73.52508 5.2360556
## 664 34.80 TOLIMA -74.83425 4.7607222
## 665 13.80 NORTE DE SANTANDER -73.39750 8.2276944
## 666 15.90 CUNDINAMARCA -73.85175 5.3038056
## 667 20.30 CAUCA -76.58129 2.4748331
## 668 25.90 CAUCA -77.12028 1.9627778
## 669 20.60 ANTIOQUIA -75.61279 6.2863333
## 670 21.00 NARIÑO -77.34361 1.6185000
## 671 20.60 SANTANDER -73.10731 7.1026111
## 672 19.70 CAUCA -76.58129 2.4748331
## 673 30.00 LA GUAJIRA -72.61594 11.1375833
## 674 8.50 BOYACÁ -72.88175 5.5566389
## 675 19.70 VALLE DEL CAUCA -76.49972 3.4545000
## 676 11.70 NARIÑO -77.49119 0.9303056
## 677 14.70 VALLE DEL CAUCA -76.10056 3.8791111
## 678 16.50 HUILA -76.10684 1.6758330
## 679 14.10 CUNDINAMARCA -74.39806 3.9936111
## 680 8.80 ANTIOQUIA -75.64444 6.6320278
## 681 13.50 BOGOTA -74.06667 4.6000000
## 682 23.40 VALLE DEL CAUCA -76.30001 3.8348056
## 683 12.20 BOYACÁ -72.91115 5.7533333
## 684 24.80 CAQUETA -74.76269 2.0630000
## 685 24.40 TOLIMA -75.24867 4.4183889
## 686 15.30 HUILA -76.10684 1.6758330
## 687 8.10 CUNDINAMARCA -73.82733 4.6610000
## 688 20.70 META -73.58686 4.2738611
## 689 9.10 CUNDINAMARCA -73.87081 4.7842778
## 690 23.00 BOYACÁ -72.91115 5.7533333
## 691 16.30 NORTE DE SANTANDER -72.48536 7.5067222
## 692 22.10 CAUCA -76.75033 2.1938333
## 693 22.30 SANTANDER -73.47206 6.8233889
## 694 25.00 CAQUETA -75.66100 1.4997222
## 695 19.60 RISARALDA -75.73839 4.9295833
## 696 25.80 TOLIMA -74.96047 4.1881389
## 697 29.70 VALLE DEL CAUCA -76.38200 3.5330000
## 698 11.10 CALDAS -75.38242 4.8594444
## 699 22.30 HUILA -75.07456 2.7591389
## 700 16.40 CALDAS -75.50714 5.0852500
## 701 17.10 RISARALDA -76.03164 5.2334444
## 702 10.00 CUNDINAMARCA -73.88125 5.0905000
## 703 15.10 CAUCA -76.82800 2.4800000
## 704 16.70 CAUCA -77.25878 2.3114167
## 705 14.70 NORTE DE SANTANDER -72.48536 7.5067222
## 706 23.80 CHOCÓ -76.67700 5.0740000
## 707 13.50 CAUCA -76.43575 2.4480411
## 708 23.80 SANTANDER -73.47206 6.8233889
## 709 19.50 CUNDINAMARCA -74.20900 4.6914167
## 710 14.60 CESAR -73.04619 10.0290833
## 711 18.70 BOYACÁ -73.35039 5.2192500
## 712 22.10 BOYACÁ -73.11636 5.7459167
## 713 19.60 ANTIOQUIA -74.79472 6.5716389
## 714 18.50 CALDAS -75.50714 5.0852500
## 715 31.50 MAGDALENA -74.13333 10.8500000
## 716 8.10 TOLIMA -75.70083 4.0758056
## 717 5.10 CUNDINAMARCA -73.80325 4.7136667
## 718 22.40 TOLIMA -75.24867 4.4183889
## 719 25.10 BOYACÁ -74.07131 5.6470278
## 720 12.00 BOGOTA D.C. -74.17700 4.5770000
## 721 16.80 NORTE DE SANTANDER -72.48536 7.5067222
## 722 15.30 VALLE DEL CAUCA -76.14428 4.7755833
## 723 0.10 CALDAS -75.38047 4.8026111
## 724 13.50 NARIÑO -77.67800 0.8570000
## 725 18.10 CALDAS -75.51389 5.0486667
## 726 8.70 ANTIOQUIA -75.64444 6.6320278
## 727 9.50 CUNDINAMARCA -73.82733 4.6610000
## 728 28.00 CAUCA -77.12028 1.9627778
## 729 19.50 ANTIOQUIA -75.61279 6.2863333
## 730 28.10 SUCRE -75.66700 9.3830000
## 731 10.00 CALDAS -75.31778 5.3500000
## 732 27.20 CHOCÓ -76.97700 7.1540000
## 733 20.70 CAUCA -77.22167 2.0327778
## 734 22.20 HUILA -76.11433 2.0215833
## 735 23.40 CÓRDOBA -75.55400 7.9310000
## 736 22.80 CASANARE -72.38800 5.3200000
## 737 32.40 MAGDALENA -74.27400 9.3040000
## 738 15.10 VALLE DEL CAUCA -76.14428 4.7755833
## 739 20.90 ANTIOQUIA -75.78953 5.7991667
## 740 25.80 CAUCA -78.17400 2.9630000
## 741 13.20 BOYACÁ -72.45267 6.5067222
## 742 16.40 CALDAS -75.14306 5.2650556
## 743 23.00 PUTUMAYO -76.65183 1.1573333
## 744 22.20 CAUCA -77.12028 1.9627778
## 745 12.00 ANTIOQUIA -75.41456 6.1319167
## 746 24.90 CAUCA -77.89475 2.5744167
## 747 12.20 CUNDINAMARCA -73.86308 4.6645000
## 748 16.50 CUNDINAMARCA -74.20900 4.6914167
## 749 11.60 BOYACÁ -72.88175 5.5566389
## 750 2.00 ARAUCA -72.28200 6.3620000
## 751 22.20 ANTIOQUIA -75.55000 6.2530000
## 752 32.10 CHOCÓ -76.61300 5.3750000
## 753 22.10 TOLIMA -75.24386 4.4703611
## 754 1.70 TOLIMA -75.32778 4.6707778
## 755 14.90 HUILA -76.10684 1.6758330
## 756 18.70 BOYACÁ -73.43600 5.0991944
## 757 9.20 ANTIOQUIA -75.56089 6.7810833
## 758 23.70 ATLANTICO -75.12694 10.4900000
## 759 22.60 BOYACÁ -74.07131 5.6470278
## 760 29.40 CUNDINAMARCA -74.80811 4.3053333
## 761 20.50 NARIÑO -78.28161 1.4086389
## 762 14.80 BOYACÁ -72.45267 6.5067222
## 763 18.00 BOYACÁ -73.43600 5.0991944
## 764 4.60 BOGOTA -74.15000 4.3500000
## 765 25.70 CAQUETA -75.66100 1.4997222
## 766 13.90 TOLIMA -75.17328 4.8705556
## 767 27.20 VALLE DEL CAUCA -77.34901 3.9251472
## 768 6.80 CUNDINAMARCA -74.20900 4.6914167
## 769 8.10 CAUCA -76.40354 2.3568489
## 770 28.60 NORTE DE SANTANDER -72.72667 8.6383333
## 771 13.50 CALDAS -75.31664 5.1399167
## 772 24.80 CHOCÓ -77.26600 5.7080000
## 773 14.30 TOLIMA -75.50036 4.4356667
## 774 25.70 SANTANDER -73.70489 6.9829722
## 775 26.60 ANTIOQUIA -75.55000 6.2530000
## 776 13.90 BOYACÁ -72.99703 5.9854167
## 777 23.40 CAQUETA -75.66100 1.4997222
## 778 28.50 CESAR -73.52394 9.6406111
## 779 27.30 CESAR -73.24806 10.4636111
## 780 18.90 CUNDINAMARCA -73.85175 5.3038056
## 781 11.20 BOYACÁ -72.88175 5.5566389
## 782 14.10 CUNDINAMARCA -74.31175 4.3101111
## 783 26.00 CÓRDOBA -75.84400 9.2530000
## 784 19.60 VALLE DEL CAUCA -76.30001 3.8348056
## 785 5.90 CALDAS -75.38047 4.8026111
## 786 16.00 SANTANDER -72.72972 6.7063889
## 787 30.60 QUINDÍO -75.69069 4.5315833
## 788 22.90 CUNDINAMARCA -73.88125 5.0905000
## 789 10.80 BOGOTA D.C. -74.15100 4.7060000
## 790 18.50 BOYACÁ -73.16994 5.2949444
## 791 23.50 GUAINÍA -67.93200 3.8680000
## 792 12.80 CALDAS -75.38242 4.8594444
## 793 34.30 META -72.56447 4.2603611
## 794 5.50 CAUCA -76.40354 2.3568489
## 795 29.20 ATLANTICO -74.78500 11.0063889
## 796 14.30 HUILA -76.42756 1.9259167
## 797 10.90 CUNDINAMARCA -74.01667 5.3333333
## 798 25.10 HUILA -75.08153 3.1330556
## 799 9.40 CUNDINAMARCA -74.02217 5.0864444
## 800 13.60 ANTIOQUIA -75.41456 6.1319167
## 801 24.80 ANTIOQUIA -74.79472 6.5716389
## 802 18.40 BOYACÁ -73.25669 4.8412500
## 803 9.80 SANTANDER -72.86850 7.1870000
## 804 13.90 BOGOTA D.C. -74.15100 4.7060000
## 805 20.40 SANTANDER -72.72972 6.7063889
## 806 16.70 VALLE DEL CAUCA -76.10056 3.8791111
## 807 27.60 HUILA -74.70294 3.5897778
## 808 24.70 SANTANDER -73.70489 6.9829722
## 809 22.10 ANTIOQUIA -74.79472 6.5716389
## 810 18.80 VALLE DEL CAUCA -76.18569 3.3140556
## 811 14.60 HUILA -75.07456 2.7591389
## 812 10.30 CUNDINAMARCA -73.84664 4.6648889
## 813 27.40 CUNDINAMARCA -74.65800 5.4928611
## 814 13.40 CALDAS -75.50714 5.0852500
## 815 21.60 HUILA -76.42756 1.9259167
## 816 20.50 BOYACÁ -73.25669 4.8412500
## 817 21.70 VALLE DEL CAUCA -76.18569 3.3140556
## 818 23.40 BOYACÁ -72.99703 5.9854167
## 819 17.50 NARIÑO -77.27881 1.1600000
## 820 19.80 NORTE DE SANTANDER -72.55027 7.4012167
## 821 17.80 RISARALDA -75.73839 4.9295833
## 822 17.40 CAUCA -76.43575 2.4480411
## 823 25.90 LA GUAJIRA -72.32575 11.5949444
## 824 16.80 BOYACÁ -73.43600 5.0991944
## 825 21.00 NARIÑO -77.34361 1.6185000
## 826 19.80 CUNDINAMARCA -74.47097 5.0168611
## 827 11.30 BOYACÁ -72.88175 5.5566389
## 828 20.70 SANTANDER -73.15100 6.2740000
## 829 29.60 AMAZONAS -70.36300 -3.7800000
## 830 23.90 HUILA -75.08153 3.1330556
## 831 13.50 SANTANDER -72.86850 7.1870000
## 832 29.30 CESAR -73.24806 10.4636111
## 833 25.20 AMAZONAS -70.36300 -3.7800000
## 834 18.50 BOYACÁ -73.43600 5.0991944
## 835 10.30 BOYACÁ -73.56278 5.3923889
## 836 14.70 BOYACÁ -72.99703 5.9854167
## 837 12.10 CUNDINAMARCA -74.39806 3.9936111
## 838 16.50 TOLIMA -75.50036 4.4356667
## 839 7.90 BOYACÁ -72.45267 6.5067222
## 840 25.30 META -72.56447 4.2603611
## 841 7.30 CUNDINAMARCA -73.87081 4.7842778
## 842 21.30 ANTIOQUIA -75.61279 6.2863333
## 843 25.90 CASANARE -72.38800 5.3200000
## 844 14.60 CAUCA -76.06394 2.5481944
## 845 23.00 MAGDALENA -74.27400 9.3040000
## 846 25.20 TOLIMA -75.24386 4.4703611
## 847 13.90 CUNDINAMARCA -74.20900 4.6914167
## 848 34.00 CUNDINAMARCA -74.48125 5.1376111
## 849 18.00 ANTIOQUIA -75.55628 5.8595833
## 850 25.20 NORTE DE SANTANDER -72.48717 7.8987778
## 851 14.90 HUILA -76.10684 1.6758330
## 852 27.60 CHOCÓ -77.33100 8.6160000
## 853 19.90 CALDAS -75.50714 5.0852500
## 854 25.30 NARIÑO -77.34361 1.6185000
## 855 20.20 ANTIOQUIA -75.55211 6.3297500
## 856 25.20 CESAR -73.24806 10.4636111
## 857 4.20 CUNDINAMARCA -73.85175 5.3038056
## 858 20.10 RISARALDA -75.90294 5.2074722
## 859 8.70 CUNDINAMARCA -74.39806 3.9936111
## 860 8.10 TOLIMA -75.17328 4.8705556
## 861 15.30 CUNDINAMARCA -74.31175 4.3101111
## 862 7.00 CUNDINAMARCA -73.88125 5.0905000
## 863 28.80 SUCRE -75.28925 9.3570833
## 864 16.60 HUILA -76.11433 2.0215833
## 865 24.60 TOLIMA -74.83425 4.7607222
## 866 17.00 BOGOTA D.C. -74.17700 4.5770000
## 867 17.40 HUILA -75.07456 2.7591389
## 868 12.10 CUNDINAMARCA -74.02217 5.0864444
## 869 5.50 BOYACÁ -73.11636 5.7459167
## 870 22.00 SANTANDER -73.47206 6.8233889
## 871 15.30 HUILA -75.07456 2.7591389
## 872 14.50 NORTE DE SANTANDER -72.48536 7.5067222
## 873 24.30 CAQUETA -75.66100 1.4997222
## 874 28.90 MAGDALENA -74.08581 9.9119722
## 875 23.90 BOYACÁ -74.07131 5.6470278
## 876 24.20 SANTANDER -73.47206 6.8233889
## 877 13.00 CUNDINAMARCA -74.20900 4.6914167
## 878 19.30 TOLIMA -75.24867 4.4183889
## 879 16.30 VALLE DEL CAUCA -76.14428 4.7755833
## 880 21.10 NARIÑO -77.27881 1.1600000
## 881 28.40 CAQUETA -75.66100 1.4997222
## 882 19.90 SANTANDER -73.47206 6.8233889
## 883 17.40 HUILA -76.10684 1.6758330
## 884 5.20 CALDAS -75.37583 4.8298056
## 885 28.10 CHOCÓ -76.67700 5.0740000
## 886 36.40 ANTIOQUIA -75.82733 6.5339167
## 887 27.90 VALLE DEL CAUCA -76.56931 3.1853611
## 888 18.70 HUILA -75.07456 2.7591389
## 889 30.80 HUILA -75.16800 3.2340000
## 890 17.30 CALDAS -75.42897 4.8866111
## 891 15.70 SANTANDER -72.96889 6.4700000
## 892 26.20 HUILA -75.16800 3.2340000
## 893 26.90 CAUCA -78.17400 2.9630000
## 894 16.90 TOLIMA -75.17328 4.8705556
## 895 8.00 TOLIMA -75.70083 4.0758056
## 896 16.50 NORTE DE SANTANDER -72.48536 7.5067222
## 897 18.80 BOYACÁ -73.25669 4.8412500
## 898 27.70 BOLIVAR -75.27828 10.1425833
## 899 22.70 PUTUMAYO -74.89800 -0.1740000
## 900 32.10 VALLE DEL CAUCA -76.30001 3.8348056
## 901 2.70 BOYACÁ -72.31417 6.5091111
## 902 18.50 BOYACÁ -73.25669 4.8412500
## 903 8.20 CUNDINAMARCA -73.87081 4.7842778
## 904 27.00 CASANARE -72.38800 5.3200000
## 905 24.80 LA GUAJIRA -72.82100 11.2270000
## 906 33.90 TOLIMA -74.83425 4.7607222
## 907 20.70 META -73.58686 4.2738611
## 908 24.30 RISARALDA -75.90294 5.2074722
## 909 19.40 ANTIOQUIA -75.55211 6.3297500
## 910 24.00 ANTIOQUIA -75.61279 6.2863333
## 911 25.00 CAUCA -78.17400 2.9630000
## 912 8.70 BOYACÁ -73.11636 5.7459167
## 913 13.30 CUNDINAMARCA -74.38400 4.4770000
## 914 22.60 TOLIMA -74.96047 4.1881389
## 915 14.90 RISARALDA -75.74492 4.7619167
## 916 6.70 TOLIMA -75.70083 4.0758056
## 917 4.40 CAUCA -76.06400 2.9780000
## 918 14.80 NORTE DE SANTANDER -72.66606 7.3609444
## 919 8.50 CALDAS -75.42897 4.8866111
## 920 20.00 CUNDINAMARCA -74.31175 4.3101111
## 921 37.00 CUNDINAMARCA -74.80811 4.3053333
## 922 26.80 META -73.46792 4.0573611
## 923 20.40 HUILA -76.11889 2.2211111
## 924 21.40 ANTIOQUIA -74.79472 6.5716389
## 925 24.10 CHOCO -76.97317 5.5210833
## 926 21.00 ANTIOQUIA -75.44222 7.1572778
## 927 23.40 CUNDINAMARCA -74.30000 4.3670000
## 928 15.20 TOLIMA -75.17328 4.8705556
## 929 8.80 BOYACÁ -72.88175 5.5566389
## 930 26.80 CORDOBA -75.91389 8.7469444
## 931 17.40 HUILA -75.07456 2.7591389
## 932 12.00 CUNDINAMARCA -73.86308 4.6645000
## 933 7.00 BOYACÁ -72.45267 6.5067222
## 934 11.20 BOGOTA D.C. -74.15100 4.7060000
## 935 26.20 HUILA -76.42756 1.9259167
## 936 8.50 SANTANDER -72.86850 7.1870000
## 937 10.30 CALDAS -75.42897 4.8866111
## 938 19.40 ANTIOQUIA -74.79472 6.5716389
## 939 23.10 ANTIOQUIA -75.55628 5.8595833
## 940 13.70 VALLE DEL CAUCA -76.65150 3.4160556
## 941 28.60 NORTE DE SANTANDER -72.51100 7.9320000
## 942 30.30 SAN ANDRÉS PROVIDENCIA -81.73100 12.5420000
## 943 31.60 MAGDALENA -74.18592 11.2230556
## 944 19.90 TOLIMA -75.24867 4.4183889
## 945 19.80 BOGOTA -74.08908 4.6380833
## 946 3.40 CALDAS -75.37583 4.8298056
## 947 21.20 VALLE DEL CAUCA -76.18569 3.3140556
## 948 17.70 ANTIOQUIA -75.55628 5.8595833
## 949 24.10 MAGDALENA -73.97083 9.0463333
## 950 21.90 HUILA -76.11889 2.2211111
## 951 20.80 HUILA -76.11889 2.2211111
## 952 9.60 CUNDINAMARCA -74.02217 5.0864444
## 953 33.00 CAQUETA -74.76269 2.0630000
## 954 22.90 SANTANDER -73.18500 7.1210000
## 955 30.90 PUTUMAYO -76.66711 1.0828889
## 956 20.70 BOLIVAR -74.24097 7.8854167
## 957 7.20 CALDAS -75.36161 4.8406667
## 958 25.00 SUCRE -75.38750 9.3163889
## 959 34.10 SUCRE -75.14269 8.5968333
## 960 13.90 CUNDINAMARCA -74.20900 4.6914167
## 961 24.10 VALLE DEL CAUCA -76.49972 3.4545000
## 962 37.10 CÓRDOBA -75.55400 7.9310000
## 963 23.10 HUILA -76.11889 2.2211111
## 964 1.70 CALDAS -75.36161 4.8406667
## 965 24.50 CHOCO -76.97317 5.5210833
## 966 13.90 BOYACÁ -72.88175 5.5566389
## 967 13.40 TOLIMA -75.50036 4.4356667
## 968 16.30 VALLE DEL CAUCA -76.14428 4.7755833
## 969 13.70 HUILA -75.07456 2.7591389
## 970 23.30 CHOCO -77.08786 8.0367222
## 971 22.00 VALLE DEL CAUCA -76.18569 3.3140556
## 972 34.30 BOLIVAR -75.10642 9.7157500
## 973 22.70 PUTUMAYO -76.66711 1.0828889
## 974 28.60 MAGDALENA -74.13333 10.8500000
## 975 28.30 LA GUAJIRA -72.82847 10.8981389
## 976 20.30 SANTANDER -73.47206 6.8233889
## 977 17.80 CALDAS -75.51389 5.0486667
## 978 10.10 ANTIOQUIA -75.64444 6.6320278
## 979 21.20 CAUCA -76.75033 2.1938333
## 980 8.40 CUNDINAMARCA -73.87081 4.7842778
## 981 27.50 CORDOBA -75.91389 8.7469444
## 982 6.30 ANTIOQUIA -75.56089 6.7810833
## 983 23.00 CAQUETA -75.66100 1.4997222
## 984 3.70 CUNDINAMARCA -73.88125 5.0905000
## 985 22.40 VALLE DEL CAUCA -76.53389 3.3780000
## 986 14.60 CESAR -73.04619 10.0290833
## 987 22.10 META -73.62500 4.1373889
## 988 6.80 CUNDINAMARCA -73.82733 4.6610000
## 989 17.60 BOYACÁ -73.16994 5.2949444
## 990 9.00 ANTIOQUIA -75.64444 6.6320278
## 991 7.80 CUNDINAMARCA -73.52508 5.2360556
## 992 32.40 AMAZONAS -69.94100 -4.1940000
## 993 34.40 ATLÁNTICO -74.78000 10.9180000
## 994 16.80 CAUCA -76.58129 2.4748331
## 995 23.30 QUINDÍO -75.76600 4.4550000
## 996 24.90 CHOCÓ -76.61300 5.3750000
## 997 7.40 CUNDINAMARCA -73.82733 4.6610000
## 998 24.60 ANTIOQUIA -75.58900 6.2210000
## 999 18.60 BOYACÁ -73.25669 4.8412500
## 1000 28.40 GUAINÍA -67.93200 3.8680000t2=temperatura %>%select(valorobservado, departamento, longitud, latitud)library(dplyr)
temperatura %>%select(valorobservado, departamento, longitud, latitud
)%>%filter(departamento == "CAUCA")## valorobservado departamento longitud latitud
## 1 20.4 CAUCA -77.22167 2.032778
## 2 7.4 CAUCA -76.40354 2.356849
## 3 20.4 CAUCA -76.58129 2.474833
## 4 6.8 CAUCA -76.40354 2.356849
## 5 17.0 CAUCA -76.59500 2.699000
## 6 24.8 CAUCA -78.17400 2.963000
## 7 25.6 CAUCA -78.17400 2.963000
## 8 15.4 CAUCA -76.06394 2.548194
## 9 16.0 CAUCA -76.58129 2.474833
## 10 29.6 CAUCA -78.17400 2.963000
## 11 15.9 CAUCA -76.82800 2.480000
## 12 38.4 CAUCA -77.12028 1.962778
## 13 15.5 CAUCA -76.75033 2.193833
## 14 20.2 CAUCA -76.25278 3.178611
## 15 30.6 CAUCA -77.12028 1.962778
## 16 17.2 CAUCA -76.75033 2.193833
## 17 9.5 CAUCA -76.40354 2.356849
## 18 16.5 CAUCA -76.59500 2.699000
## 19 18.6 CAUCA -76.43575 2.448041
## 20 26.3 CAUCA -78.17400 2.963000
## 21 31.3 CAUCA -78.17400 2.963000
## 22 26.1 CAUCA -76.59500 2.699000
## 23 11.2 CAUCA -76.43575 2.448041
## 24 5.7 CAUCA -76.48203 2.191722
## 25 24.6 CAUCA -77.89475 2.574417
## 26 27.2 CAUCA -76.58129 2.474833
## 27 15.1 CAUCA -76.06394 2.548194
## 28 20.8 CAUCA -77.22167 2.032778
## 29 20.3 CAUCA -76.75033 2.193833
## 30 6.1 CAUCA -76.40354 2.356849
## 31 25.4 CAUCA -77.89475 2.574417
## 32 24.9 CAUCA -77.12028 1.962778
## 33 24.1 CAUCA -77.22167 2.032778
## 34 29.6 CAUCA -78.17400 2.963000
## 35 10.4 CAUCA -76.40354 2.356849
## 36 16.7 CAUCA -77.25878 2.311417
## 37 15.6 CAUCA -77.22167 2.032778
## 38 20.3 CAUCA -76.58129 2.474833
## 39 25.9 CAUCA -77.12028 1.962778
## 40 19.7 CAUCA -76.58129 2.474833
## 41 22.1 CAUCA -76.75033 2.193833
## 42 15.1 CAUCA -76.82800 2.480000
## 43 16.7 CAUCA -77.25878 2.311417
## 44 13.5 CAUCA -76.43575 2.448041
## 45 28.0 CAUCA -77.12028 1.962778
## 46 20.7 CAUCA -77.22167 2.032778
## 47 25.8 CAUCA -78.17400 2.963000
## 48 22.2 CAUCA -77.12028 1.962778
## 49 24.9 CAUCA -77.89475 2.574417
## 50 8.1 CAUCA -76.40354 2.356849
## 51 5.5 CAUCA -76.40354 2.356849
## 52 17.4 CAUCA -76.43575 2.448041
## 53 14.6 CAUCA -76.06394 2.548194
## 54 26.9 CAUCA -78.17400 2.963000
## 55 25.0 CAUCA -78.17400 2.963000
## 56 4.4 CAUCA -76.06400 2.978000
## 57 21.2 CAUCA -76.75033 2.193833
## 58 16.8 CAUCA -76.58129 2.474833library(dplyr)
temp1 <- temperatura %>%
select(valorobservado, departamento, latitud, longitud) %>%
filter(departamento == "CAUCA") %>%
mutate(diferencia_valorobservado_longitud = valorobservado - longitud)
head(temp1)## valorobservado departamento latitud longitud
## 1 20.4 CAUCA 2.032778 -77.22167
## 2 7.4 CAUCA 2.356849 -76.40354
## 3 20.4 CAUCA 2.474833 -76.58129
## 4 6.8 CAUCA 2.356849 -76.40354
## 5 17.0 CAUCA 2.699000 -76.59500
## 6 24.8 CAUCA 2.963000 -78.17400
## diferencia_valorobservado_longitud
## 1 97.62167
## 2 83.80354
## 3 96.98129
## 4 83.20354
## 5 93.59500
## 6 102.97400library(dplyr)
temperatura %>% select(departamento, valorobservado,latitud, longitud
) %>%group_by(departamento)%>%
summarise(media=median(valorobservado), mediana=median(longitud))## # A tibble: 37 × 3
## departamento media mediana
## <chr> <dbl> <dbl>
## 1 AMAZONAS 25.8 -70.4
## 2 ANTIOQUIA 20.2 -75.6
## 3 ARAUCA 5.70 -72.3
## 4 ATLANTICO 27.7 -75.0
## 5 ATLÁNTICO 27.0 -74.9
## 6 BOGOTA 12.1 -74.1
## 7 BOGOTA D.C. 13.4 -74.2
## 8 BOLIVAR 28.8 -75.1
## 9 BOLÍVAR 26.9 -75.5
## 10 BOYACÁ 17.1 -73.2
## # ℹ 27 more rows