Práctica 10

Objetivo: Importar archivo excel y generar un nuevo data frame para hacer análisis

Importar archivo CSV

library(readr)
resultados<-read.csv("resultados_ageb_urbana_10_cpv2010.csv")

#View("resultados_ageb_urbana_10_cpv2010.csv")

¿Cuántas observaciones y cuántas variables tiene el conjunto de datos?

str(resultados)
## 'data.frame':    30876 obs. of  198 variables:
##  $ ï..entidad: int  10 10 10 10 10 10 10 10 10 10 ...
##  $ nom_ent   : Factor w/ 1 level "Durango": 1 1 1 1 1 1 1 1 1 1 ...
##  $ mun       : int  0 1 1 1 1 1 1 1 1 1 ...
##  $ nom_mun   : Factor w/ 40 levels "Canatlán","Canelas",..: 39 1 1 1 1 1 1 1 1 1 ...
##  $ loc       : int  0 0 1 1 1 1 1 1 1 1 ...
##  $ nom_loc   : Factor w/ 65 levels "Antonio Amaro (Saucillo)",..: 55 57 56 54 3 3 3 3 3 3 ...
##  $ ageb      : Factor w/ 1367 levels "0000","0013",..: 1 1 1 15 15 15 15 15 15 15 ...
##  $ mza       : int  0 0 0 0 1 2 3 4 5 6 ...
##  $ pobtot    : int  1632934 31401 11495 658 37 16 27 38 32 19 ...
##  $ pobmas    : Factor w/ 835 levels "*","0","10","100",..: 737 206 596 413 241 626 84 293 211 626 ...
##  $ pobfem    : Factor w/ 829 levels "*","0","10","100",..: 750 217 639 461 309 3 197 273 225 124 ...
##  $ p_0a2     : Factor w/ 282 levels "*","0","10","100",..: 276 83 228 182 207 2 160 1 1 1 ...
##  $ p_0a2_m   : Factor w/ 185 levels "*","0","10","100",..: 118 167 87 56 1 2 1 2 2 2 ...
##  $ p_0a2_f   : Factor w/ 187 levels "*","0","10","100",..: 116 169 90 56 84 2 1 1 1 1 ...
##  $ p_3ymas   : Factor w/ 1035 levels "*","0","10","100",..: 192 577 46 850 614 228 463 672 602 258 ...
##  $ p_3ymas_m : Factor w/ 794 levels "*","0","10","100",..: 666 162 535 357 170 586 3 259 194 586 ...
##  $ p_3ymas_f : Factor w/ 811 levels "*","0","10","100",..: 695 189 598 420 244 3 162 226 192 50 ...
##  $ p_5ymas   : Factor w/ 1024 levels "*","0","10","100",..: 168 561 28 823 619 192 465 656 569 252 ...
##  $ p_5ymas_m : Factor w/ 788 levels "*","0","10","100",..: 635 152 511 341 176 514 3 242 176 568 ...
##  $ p_5ymas_f : Factor w/ 801 levels "*","0","10","100",..: 663 161 566 395 229 3 150 208 150 43 ...
##  $ p_12ymas  : Factor w/ 957 levels "*","0","10","100",..: 81 458 902 706 564 150 381 553 475 150 ...
##  $ p_12ymas_m: Factor w/ 725 levels "*","0","10","100",..: 507 72 400 239 134 457 675 171 70 457 ...
##  $ p_12ymas_f: Factor w/ 759 levels "*","0","10","100",..: 560 87 464 313 177 712 80 113 113 712 ...
##  $ p_15ymas  : Factor w/ 927 levels "*","0","10","100",..: 49 405 843 650 530 87 325 514 418 87 ...
##  $ p_15ymas_m: Factor w/ 677 levels "*","0","10","100",..: 450 42 340 197 122 356 542 155 41 356 ...
##  $ p_15ymas_f: Factor w/ 734 levels "*","0","10","100",..: 514 53 424 273 168 630 74 101 74 630 ...
##  $ p_18ymas  : Factor w/ 883 levels "*","0","10","100",..: 9 348 762 572 480 42 256 480 361 3 ...
##  $ p_18ymas_m: Factor w/ 662 levels "*","0","10","100",..: 405 5 299 158 97 344 529 136 626 258 ...
##  $ p_18ymas_f: Factor w/ 690 levels "*","0","10","100",..: 446 18 364 221 128 543 3 63 63 543 ...
##  $ p_3a5     : Factor w/ 283 levels "*","0","10","100",..: 281 83 233 180 2 1 2 1 1 2 ...
##  $ p_3a5_m   : Factor w/ 192 levels "*","0","10","100",..: 128 179 91 57 2 1 2 1 1 2 ...
##  $ p_3a5_f   : Factor w/ 191 levels "*","0","10","100",..: 122 175 100 65 2 2 2 2 1 2 ...
##  $ p_6a11    : Factor w/ 433 levels "*","0","10","100",..: 131 272 68 407 1 1 221 333 289 221 ...
##  $ p_6a11_m  : Factor w/ 287 levels "*","0","10","100",..: 7 102 253 197 2 2 1 1 163 1 ...
##  $ p_6a11_f  : Factor w/ 291 levels "*","0","10","100",..: 290 96 253 193 1 1 1 169 1 1 ...
##  $ p_8a14    : Factor w/ 463 levels "*","0","10","100",..: 160 321 87 446 1 1 348 1 348 348 ...
##  $ p_8a14_m  : Factor w/ 314 levels "*","0","10","100",..: 26 134 295 233 2 1 182 2 182 1 ...
##  $ p_8a14_f  : Factor w/ 309 levels "*","0","10","100",..: 24 129 284 215 1 1 1 1 1 178 ...
##  $ p_12a14   : Factor w/ 290 levels "*","0","10","100",..: 289 106 247 185 2 1 1 2 1 1 ...
##  $ p_12a14_m : Factor w/ 192 levels "*","0","10","100",..: 127 190 103 55 2 1 1 2 1 1 ...
##  $ p_12a14_f : Factor w/ 189 levels "*","0","10","100",..: 120 178 92 52 2 1 2 2 1 1 ...
##  $ p_15a17   : Factor w/ 293 levels "*","0","10","100",..: 6 111 256 217 1 1 1 1 1 1 ...
##  $ p_15a17_m : Factor w/ 197 levels "*","0","10","100",..: 130 193 105 80 1 2 2 2 1 1 ...
##  $ p_15a17_f : Factor w/ 189 levels "*","0","10","100",..: 121 181 97 63 1 1 1 1 2 1 ...
##  $ p_18a24   : Factor w/ 447 levels "*","0","10","100",..: 125 297 68 393 286 1 1 210 210 1 ...
##  $ p_18a24_m : Factor w/ 304 levels "*","0","10","100",..: 9 130 272 195 181 1 2 1 1 2 ...
##  $ p_18a24_f : Factor w/ 306 levels "*","0","10","100",..: 10 117 276 200 1 1 1 1 1 1 ...
##  $ p_15a49_f : Factor w/ 638 levels "*","0","10","100",..: 351 570 269 134 3 396 514 568 607 460 ...
##  $ p_60ymas  : Factor w/ 380 levels "*","0","10","100",..: 67 263 25 362 321 207 337 367 264 1 ...
##  $ p_60ymas_m: Factor w/ 240 levels "*","0","10","100",..: 200 92 170 155 1 1 130 149 1 1 ...
##  $ p_60ymas_f: Factor w/ 271 levels "*","0","10","100",..: 238 102 218 181 177 1 177 194 1 1 ...
##  $ rel_h_m   : Factor w/ 2225 levels "*","0","100",..: 2056 2192 1714 1564 1433 943 1273 397 3 864 ...
##  $ pob0_14   : Factor w/ 668 levels "*","0","10","100",..: 435 636 312 159 494 361 593 593 634 551 ...
##  $ pob15_64  : Factor w/ 923 levels "*","0","10","100",..: 7 341 797 602 461 3 87 400 325 3 ...
##  $ pob65_mas : Factor w/ 309 levels "*","0","10","100",..: 12 172 287 257 236 1 266 281 213 1 ...
##  $ prom_hnv  : Factor w/ 460 levels "*","0","0.33",..: 185 218 182 178 176 151 218 218 134 193 ...
##  $ pnacent   : Factor w/ 1004 levels "*","0","10","100",..: 165 554 47 815 618 130 448 651 544 254 ...
##  $ pnacent_m : Factor w/ 772 levels "*","0","10","100",..: 612 146 502 320 126 417 3 236 149 491 ...
##  $ pnacent_f : Factor w/ 775 levels "*","0","10","100",..: 623 161 544 387 251 716 141 205 141 70 ...
##  $ pnacoe    : Factor w/ 435 levels "*","0","10","100",..: 117 11 317 196 1 1 2 1 204 1 ...
##  $ pnacoe_m  : Factor w/ 305 levels "*","0","10","100",..: 297 229 140 79 1 1 2 2 1 1 ...
##  $ pnacoe_f  : Factor w/ 317 levels "*","0","10","1006",..: 313 239 137 25 2 1 2 1 1 1 ...
##  $ pres2005  : Factor w/ 1005 levels "*","0","10","100",..: 144 521 1001 784 573 156 434 616 557 156 ...
##  $ pres2005_m: Factor w/ 752 levels "*","0","10","100",..: 586 121 464 307 136 488 713 198 162 488 ...
##  $ pres2005_f: Factor w/ 793 levels "*","0","10","100",..: 645 152 547 376 210 740 156 210 156 740 ...
##  $ presoe05  : Factor w/ 189 levels "*","0","10","100",..: 110 122 64 50 1 2 2 2 2 90 ...
##  $ presoe05_m: Factor w/ 131 levels "*","0","10","100",..: 42 50 5 118 1 2 2 2 2 1 ...
##  $ presoe05_f: Factor w/ 134 levels "*","0","10","100",..: 42 51 8 129 1 2 2 2 2 1 ...
##  $ p3ym_hli  : Factor w/ 71 levels "*","0","10","102",..: 41 66 27 37 1 2 2 2 2 2 ...
##  $ p3ym_hli_m: Factor w/ 52 levels "*","0","10","11",..: 14 34 47 28 1 2 2 2 2 2 ...
##  $ p3ym_hli_f: Factor w/ 50 levels "*","0","10","11",..: 13 34 11 2 2 2 2 2 2 2 ...
##  $ p3hlinhe  : Factor w/ 11 levels "*","0","22","3",..: 10 2 2 2 2 2 2 2 2 2 ...
##  $ p3hlinhe_m: Factor w/ 9 levels "*","0","12","13",..: 6 2 2 2 2 2 2 2 2 2 ...
##  $ p3hlinhe_f: Factor w/ 11 levels "*","0","17","20",..: 9 2 2 2 2 2 2 2 2 2 ...
##  $ p3hli_he  : Factor w/ 62 levels "*","0","10","102",..: 30 47 5 1 1 2 2 2 2 2 ...
##  $ p3hli_he_m: Factor w/ 46 levels "*","0","10","100",..: 9 19 30 1 1 2 2 2 2 2 ...
##  $ p3hli_he_f: Factor w/ 45 levels "*","0","10","11",..: 5 19 37 2 2 2 2 2 2 2 ...
##  $ p5_hli    : Factor w/ 69 levels "*","0","10","100",..: 36 64 24 35 1 2 2 2 2 2 ...
##  $ p5_hli_nhe: Factor w/ 10 levels "*","0","12","14",..: 9 2 2 2 2 2 2 2 2 2 ...
##  $ p5_hli_he : Factor w/ 58 levels "*","0","10","109",..: 27 43 5 1 1 2 2 2 2 2 ...
##  $ phog_ind  : Factor w/ 100 levels "*","0","10","102",..: 60 19 82 15 1 2 2 2 2 2 ...
##  $ pcon_lim  : Factor w/ 265 levels "*","0","10","100",..: 243 76 196 173 1 2 194 175 1 1 ...
##  $ pclim_mot : Factor w/ 197 levels "*","0","10","100",..: 124 193 85 47 2 2 125 109 1 2 ...
##  $ pclim_vis : Factor w/ 142 levels "*","0","10","101",..: 45 83 16 3 1 2 2 2 1 2 ...
##  $ pclim_leng: Factor w/ 72 levels "*","0","10","100",..: 57 4 42 1 2 2 2 2 2 2 ...
##  $ pclim_aud : Factor w/ 88 levels "*","0","10","100",..: 84 25 56 1 2 2 2 2 1 2 ...
##  $ pclim_mot2: Factor w/ 65 levels "*","0","10","102",..: 41 64 33 2 2 2 2 2 2 2 ...
##  $ pclim_men : Factor w/ 53 levels "*","0","10","105",..: 33 45 24 28 2 2 2 2 2 2 ...
##  $ pclim_men2: Factor w/ 75 levels "*","0","10","102",..: 64 21 69 5 2 2 2 2 2 1 ...
##  $ psin_lim  : Factor w/ 1041 levels "*","0","10","100",..: 199 577 46 858 677 232 409 658 587 293 ...
##  $ p3a5_noa  : Factor w/ 181 levels "*","0","10","102",..: 114 159 77 11 2 2 2 1 2 2 ...
##  $ p3a5_noa_m: Factor w/ 126 levels "*","0","10","105",..: 40 65 12 80 2 2 2 1 2 2 ...
##  $ p3a5_noa_f: Factor w/ 126 levels "*","0","10","104",..: 40 69 21 94 2 2 2 2 2 2 ...
##  $ p6a11_noa : Factor w/ 63 levels "*","0","10","11",..: 51 57 18 2 2 2 2 2 2 2 ...
##  $ p6a11_noam: Factor w/ 48 levels "*","0","10","101",..: 29 31 5 2 2 2 2 2 2 2 ...
##  $ p6a11_noaf: Factor w/ 43 levels "*","0","10","107",..: 22 28 41 2 2 2 2 2 2 2 ...
##  $ p12a14noa : Factor w/ 79 levels "*","0","10","101",..: 76 4 35 2 2 2 2 2 2 2 ...
##  $ p12a14noam: Factor w/ 61 levels "*","0","10","103",..: 42 45 18 2 2 2 2 2 2 2 ...
##  $ p12a14noaf: Factor w/ 54 levels "*","0","10","11",..: 32 38 51 2 2 2 2 2 2 2 ...
##   [list output truncated]

Crear un nuevo DATA.FRAME

#Determinar un nuevo data frame (conjunto de datos) solo con los municipios de Canatlán, Durango, Gomez Palacio, Guadalupe Victoria, Lerdo,  Pueblo Nuevo, Santiago Papasquiaro, Tepehuanes, Vicente Guerrero y Nuevo Ideal,. Incluir todas las columnas

mis_resultados<-resultados[which(resultados$mun=='1'|resultados$mun=='5'|resultados$mun=='7'|resultados$mun=='8'|resultados$mun=='12'|resultados$mun=='23'|resultados$mun=='32'|resultados$mun=='35'|resultados$mun=='38'|resultados$mun=='39'),]

#mis_resultados

Mostrar los primeros 6 registros

head(mis_resultados)
##   ï..entidad nom_ent mun   nom_mun loc                      nom_loc ageb
## 2         10 Durango   1 Canatlán   0          Total del municipio 0000
## 3         10 Durango   1 Canatlán   1 Total de la localidad urbana 0000
## 4         10 Durango   1 Canatlán   1            Total AGEB urbana 0054
## 5         10 Durango   1 Canatlán   1                    Canatlán 0054
## 6         10 Durango   1 Canatlán   1                    Canatlán 0054
## 7         10 Durango   1 Canatlán   1                    Canatlán 0054
##   mza pobtot pobmas pobfem p_0a2 p_0a2_m p_0a2_f p_3ymas p_3ymas_m
## 2   0  31401  15633  15768  1702     869     833   29661     14745
## 3   0  11495   5482   6013   616     306     310   10870      5171
## 4   0    658    308    350    36      18      18     622       290
## 5   1     37     17     20     5       *       3      32        15
## 6   2     16      6     10     0       0       0      16         6
## 7   3     27     12     15     3       *       *      24        10
##   p_3ymas_f p_5ymas p_5ymas_m p_5ymas_f p_12ymas p_12ymas_m p_12ymas_f
## 2     14916   28497     14164     14333    24256      12003      12253
## 3      5699   10444      4975      5469     8782       4141       4641
## 4       332     598       280       318      505        232        273
## 5        17      32        15        17       31         15         16
## 6        10      15         5        10       14          5          9
## 7        14      24        10        14       21          9         12
##   p_15ymas p_15ymas_m p_15ymas_f p_18ymas p_18ymas_m p_18ymas_f p_3a5
## 2    22345      11013      11332    20441      10052      10389  1745
## 3     8090       3780       4310     7385       3426       3959   647
## 4      470        215        255      423        190        233    37
## 5       31         15         16       29         14         15     0
## 6       12          4          8       11          4          7     *
## 7       19          7         12       17          7         10     0
##   p_3a5_m p_3a5_f p_6a11 p_6a11_m p_6a11_f p_8a14 p_8a14_m p_8a14_f
## 2     878     867   3660     1864     1796   4358     2250     2108
## 3     296     351   1441      734      707   1646      853      793
## 4      17      20     80       41       39     89       47       42
## 5       0       0      *        0        *      *        0        *
## 6       *       0      *        0        *      *        *        *
## 7       0       0      3        *        *      5        3        *
##   p_12a14 p_12a14_m p_12a14_f p_15a17 p_15a17_m p_15a17_f p_18a24
## 2    1911       990       921    1904       961       943    4100
## 3     692       361       331     705       354       351    1480
## 4      35        17        18      47        25        22      67
## 5       0         0         0       *         *         *       4
## 6       *         *         *       *         0         *       *
## 7       *         *         0       *         0         *       *
##   p_18a24_m p_18a24_f p_15a49_f p_60ymas p_60ymas_m p_60ymas_f rel_h_m
## 2      2120      1980      8008     3963       1974       1989   99.14
## 3       722       758      3166     1167        522        645   91.17
## 4        33        34       180       85         43         42      88
## 5         3         *        10        6          *          4      85
## 6         *         *         5        3          *          *      60
## 7         0         *         7        7          3          4      80
##   pob0_14 pob15_64 pob65_mas prom_hnv pnacent pnacent_m pnacent_f pnacoe
## 2    9018    19481      2864     2.92   29879     14872     15007   1059
## 3    3396     7266       824     2.56   10821      5139      5682    511
## 4     188      408        62     2.52     617       283       334     29
## 5       6       26         5     2.50      34        14        20      *
## 6       4       10         *     2.25      13         4         9      *
## 7       8       12         7     2.92      24        10        14      0
##   pnacoe_m pnacoe_f pres2005 pres2005_m pres2005_f presoe05 presoe05_m
## 2      530      529    27269      13418      13851      458        238
## 3      260      251     9920       4673       5247      209        101
## 4       17       12      563        262        301       17          8
## 5        *        0       30         14         16        *          *
## 6        *        *       14          5          9        0          0
## 7        0        0       23          9         14        0          0
##   presoe05_f p3ym_hli p3ym_hli_m p3ym_hli_f p3hlinhe p3hlinhe_m p3hlinhe_f
## 2        220       77         36         41        0          0          0
## 3        108       23          8         15        0          0          0
## 4          9        3          3          0        0          0          0
## 5          *        *          *          0        0          0          0
## 6          0        0          0          0        0          0          0
## 7          0        0          0          0        0          0          0
##   p3hli_he p3hli_he_m p3hli_he_f p5_hli p5_hli_nhe p5_hli_he phog_ind
## 2       47         21         26     75          0        46      147
## 3       11          4          7     22          0        11       63
## 4        *          *          0      3          0         *       13
## 5        *          *          0      *          0         *        *
## 6        0          0          0      0          0         0        0
## 7        0          0          0      0          0         0        0
##   pcon_lim pclim_mot pclim_vis pclim_leng pclim_aud pclim_mot2 pclim_men
## 2     1635       945       457        100       171         94        55
## 3      504       275       125         36        38         34        25
## 4       38        17        10          *         *          0         3
## 5        *         0         *          0         0          0         0
## 6        0         0         0          0         0          0         0
## 7        5         5         0          0         0          0         0
##   pclim_men2 psin_lim p3a5_noa p3a5_noa_m p3a5_noa_f p6a11_noa p6a11_noam
## 2        184    29533      819        407        412        72         37
## 3         80    10868      283        128        155        19         11
## 4         11      618       11          5          6         0          0
## 5          0       36        0          0          0         0          0
## 6          0       16        0          0          0         0          0
## 7          0       22        0          0          0         0          0
##   p6a11_noaf p12a14noa p12a14noam p12a14noaf p15a17a p15a17a_m p15a17a_f
## 2         35       101         53         48    1298       648       650
## 3          8        27         18          9     574       281       293
## 4          0         0          0          0      34        17        17
## 5          0         0          0          0       *         *         *
## 6          0         0          0          0       *         0         *
## 7          0         0          0          0       *         0         *
##   p18a24a p18a24a_m p18a24a_f p8a14an p8a14an_m p8a14an_f p15ym_an
## 2    1162       707       455      48        28        20      778
## 3     533       285       248      21        13         8      203
## 4      28        18        10       *         0         *       14
## 5       *         *         0       0         0         0        0
## 6       *         *         0       0         0         0        0
## 7       0         0         0       0         0         0        0
##   p15ym_an_m p15ym_an_f p15ym_se p15ym_se_m p15ym_se_f p15pri_in
## 2        422        356      809        446        363      4185
## 3        106         97      239        125        114       977
## 4          6          8       12          6          6        77
## 5          0          0        0          0          0         6
## 6          0          0        0          0          0         *
## 7          0          0        0          0          0         4
##   p15pri_inm p15pri_inf p15pri_co p15pri_com p15pri_cof p15sec_in
## 2       2137       2048      4376       2157       2219       997
## 3        463        514      1211        552        659       330
## 4         34         43        66         36         30        16
## 5          *          4         4          *          *         0
## 6          *          0         *          0          *         0
## 7          *          *         3          *          *         *
##   p15sec_inm p15sec_inf p15sec_co p15sec_com p15sec_cof p18ym_pb
## 2        538        459      5765       2698       3067     5305
## 3        168        162      1736        792        944     3110
## 4          6         10       106         46         60      157
## 5          0          0         6          4          *       13
## 6          0          0         4          0          4        5
## 7          0          *         5          *          4        4
##   p18ym_pb_m p18ym_pb_f graproes graproes_m graproes_f   pea pea_m pea_f
## 2       2653       2652        8       7.99       8.01 10836  8527  2309
## 3       1482       1628     9.34       9.47       9.23  4285  2814  1471
## 4         74         83     8.87       8.89       8.85   246   155    91
## 5          6          7     9.20       9.36       9.06    16    12     4
## 6          3          *     9.92      10.25       9.75     6     3     3
## 7          3          *     8.39       9.57       7.64     9     6     3
##   pe_inac pe_inac_m pe_inac_f pocupada pocupada_m pocupada_f pdesocup
## 2   13261      3361      9900    10401       8134       2267      435
## 3    4465      1312      3153     4100       2660       1440      185
## 4     255        76       179      232        142         90       14
## 5      14         3        11       15         11          4        *
## 6       8         *         6        6          3          3        0
## 7      12         3         9        9          6          3        0
##   pdesocup_m pdesocup_f psinder pder_ss pder_imss pder_iste pder_istee
## 2        393         42    9757   21569      5749      3855         12
## 3        154         31    2881    8592      2964      2296          *
## 4         13          *     198     459       173       116          0
## 5          *          0       6      31        18         8          0
## 6          0          0       4      12         *         9          0
## 7          0          0      18       9         4         6          0
##   pder_segp p12ym_solt p12ym_casa p12ym_sepa pcatolica pncatolica
## 2     11758       8353      13566       2299     29573       1174
## 3      3457       3267       4569        925     10769        386
## 4       178        199        235         70       614         30
## 5         6         12         16          3        35          0
## 6         *          6          4          4        16          0
## 7         0          5         12          4        27          0
##   potras_rel psin_relig tothog hogjef_m hogjef_f pobhog phogjef_m
## 2          0        335   7871     5945     1926  31084     24449
## 3          0        134   2932     1961      971  11410      7967
## 4          0          3    175      104       71    658       386
## 5          0          *     11        7        4     37        28
## 6          0          0      6        3        3     16         6
## 7          0          0      7        5        *     27        22
##   phogjef_f vivtot tvivhab tvivpar vivpar_hab tvivparhab vivpar_des
## 2      6635  10500    7888   10483       7871       7882       2012
## 3      3443   3673    2940    3665       2932       2935        518
## 4       272    217     175     217        175        175         30
## 5         9     12       *       *          *          *          *
## 6        10      6       *       *          *          *          *
## 7         5      9       *       *          *          *          *
##   vivpar_ut ocupvivpar prom_ocup pro_ocup_c vph_pisodt vph_pisoti vph_1dor
## 2       600      31084      3.95       0.94       7389        464     1953
## 3       215      11410      3.89       0.93       2783        142      608
## 4        12        658      3.76       0.90        167          7       53
## 5         *         37      3.36       0.86         11          0        4
## 6         *         16      2.67       0.70          5          *        3
## 7         *         27      3.86       0.84          7          0        *
##   vph_2ymasd vph_1cuart vph_2cuart vph_3ymasc vph_c_elec vph_s_elec
## 2       5896        133        699       7009       7690        155
## 3       2317         57        271       2594       2908         16
## 4        122          6         17        151        175          0
## 5          7          0          *          9         11          0
## 6          3          0          0          5          6          0
## 7          5          0          0          7          7          0
##   vph_aguadv vph_aguafv vph_excsa vph_drenaj vph_nodren vph_c_serv
## 2       7397        442      6835       6549       1265       6205
## 3       2780        139      2864       2858         67       2713
## 4        172          *       171        171          4        169
## 5         11          0        11         11          0         11
## 6          6          0         6          6          0          6
## 7          7          0         7          7          0          7
##   vph_snbien vph_radio vph_tv vph_refri vph_lavad vph_autom vph_pc
## 2        132      6305   7329      6581      4969      4188   1335
## 3         19      2267   2829      2631      2112      1641    888
## 4          *       133    165       157       119        95     42
## 5          0        11     11         9         7         3      *
## 6          0         6      6         6         5         4      *
## 7          0         7      7         7         6         5      *
##   vph_telef vph_cel vph_inter
## 2      3323    3958       608
## 3      1456    1856       538
## 4        82      99        26
## 5         5       9         *
## 6         5       3         *
## 7         4       6         0

Mostrar los últimos 6 registros

tail(mis_resultados)
##       ï..entidad nom_ent mun     nom_mun loc     nom_loc ageb mza pobtot
## 30871         10 Durango  39 Nuevo Ideal   1 Nuevo Ideal 0475   1      0
## 30872         10 Durango  39 Nuevo Ideal   1 Nuevo Ideal 0475   2      0
## 30873         10 Durango  39 Nuevo Ideal   1 Nuevo Ideal 0475   3      0
## 30874         10 Durango  39 Nuevo Ideal   1 Nuevo Ideal 0475   4      2
## 30875         10 Durango  39 Nuevo Ideal   1 Nuevo Ideal 0475   5      0
## 30876         10 Durango  39 Nuevo Ideal   1 Nuevo Ideal 0475   6      3
##       pobmas pobfem p_0a2 p_0a2_m p_0a2_f p_3ymas p_3ymas_m p_3ymas_f
## 30871      0      0     0       0       0       0         0         0
## 30872      0      0     0       0       0       0         0         0
## 30873      0      0     0       0       0       0         0         0
## 30874      *      *     *       *       *       *         *         *
## 30875      0      0     0       0       0       0         0         0
## 30876      *      *     *       *       *       *         *         *
##       p_5ymas p_5ymas_m p_5ymas_f p_12ymas p_12ymas_m p_12ymas_f p_15ymas
## 30871       0         0         0        0          0          0        0
## 30872       0         0         0        0          0          0        0
## 30873       0         0         0        0          0          0        0
## 30874       *         *         *        *          *          *        *
## 30875       0         0         0        0          0          0        0
## 30876       *         *         *        *          *          *        *
##       p_15ymas_m p_15ymas_f p_18ymas p_18ymas_m p_18ymas_f p_3a5 p_3a5_m
## 30871          0          0        0          0          0     0       0
## 30872          0          0        0          0          0     0       0
## 30873          0          0        0          0          0     0       0
## 30874          *          *        *          *          *     *       *
## 30875          0          0        0          0          0     0       0
## 30876          *          *        *          *          *     *       *
##       p_3a5_f p_6a11 p_6a11_m p_6a11_f p_8a14 p_8a14_m p_8a14_f p_12a14
## 30871       0      0        0        0      0        0        0       0
## 30872       0      0        0        0      0        0        0       0
## 30873       0      0        0        0      0        0        0       0
## 30874       *      *        *        *      *        *        *       *
## 30875       0      0        0        0      0        0        0       0
## 30876       *      *        *        *      *        *        *       *
##       p_12a14_m p_12a14_f p_15a17 p_15a17_m p_15a17_f p_18a24 p_18a24_m
## 30871         0         0       0         0         0       0         0
## 30872         0         0       0         0         0       0         0
## 30873         0         0       0         0         0       0         0
## 30874         *         *       *         *         *       *         *
## 30875         0         0       0         0         0       0         0
## 30876         *         *       *         *         *       *         *
##       p_18a24_f p_15a49_f p_60ymas p_60ymas_m p_60ymas_f rel_h_m pob0_14
## 30871         0         0        0          0          0       0       0
## 30872         0         0        0          0          0       0       0
## 30873         0         0        0          0          0       0       0
## 30874         *         *        *          *          *       *       *
## 30875         0         0        0          0          0       0       0
## 30876         *         *        *          *          *       *       *
##       pob15_64 pob65_mas prom_hnv pnacent pnacent_m pnacent_f pnacoe
## 30871        0         0        0       0         0         0      0
## 30872        0         0        0       0         0         0      0
## 30873        0         0        0       0         0         0      0
## 30874        *         *        *       *         *         *      *
## 30875        0         0        0       0         0         0      0
## 30876        *         *        *       *         *         *      *
##       pnacoe_m pnacoe_f pres2005 pres2005_m pres2005_f presoe05 presoe05_m
## 30871        0        0        0          0          0        0          0
## 30872        0        0        0          0          0        0          0
## 30873        0        0        0          0          0        0          0
## 30874        *        *        *          *          *        *          *
## 30875        0        0        0          0          0        0          0
## 30876        *        *        *          *          *        *          *
##       presoe05_f p3ym_hli p3ym_hli_m p3ym_hli_f p3hlinhe p3hlinhe_m
## 30871          0        0          0          0        0          0
## 30872          0        0          0          0        0          0
## 30873          0        0          0          0        0          0
## 30874          *        *          *          *        *          *
## 30875          0        0          0          0        0          0
## 30876          *        *          *          *        *          *
##       p3hlinhe_f p3hli_he p3hli_he_m p3hli_he_f p5_hli p5_hli_nhe
## 30871          0        0          0          0      0          0
## 30872          0        0          0          0      0          0
## 30873          0        0          0          0      0          0
## 30874          *        *          *          *      *          *
## 30875          0        0          0          0      0          0
## 30876          *        *          *          *      *          *
##       p5_hli_he phog_ind pcon_lim pclim_mot pclim_vis pclim_leng pclim_aud
## 30871         0        0        0         0         0          0         0
## 30872         0        0        0         0         0          0         0
## 30873         0        0        0         0         0          0         0
## 30874         *        *        *         *         *          *         *
## 30875         0        0        0         0         0          0         0
## 30876         *        *        *         *         *          *         *
##       pclim_mot2 pclim_men pclim_men2 psin_lim p3a5_noa p3a5_noa_m
## 30871          0         0          0        0        0          0
## 30872          0         0          0        0        0          0
## 30873          0         0          0        0        0          0
## 30874          *         *          *        *        *          *
## 30875          0         0          0        0        0          0
## 30876          *         *          *        *        *          *
##       p3a5_noa_f p6a11_noa p6a11_noam p6a11_noaf p12a14noa p12a14noam
## 30871          0         0          0          0         0          0
## 30872          0         0          0          0         0          0
## 30873          0         0          0          0         0          0
## 30874          *         *          *          *         *          *
## 30875          0         0          0          0         0          0
## 30876          *         *          *          *         *          *
##       p12a14noaf p15a17a p15a17a_m p15a17a_f p18a24a p18a24a_m p18a24a_f
## 30871          0       0         0         0       0         0         0
## 30872          0       0         0         0       0         0         0
## 30873          0       0         0         0       0         0         0
## 30874          *       *         *         *       *         *         *
## 30875          0       0         0         0       0         0         0
## 30876          *       *         *         *       *         *         *
##       p8a14an p8a14an_m p8a14an_f p15ym_an p15ym_an_m p15ym_an_f p15ym_se
## 30871       0         0         0        0          0          0        0
## 30872       0         0         0        0          0          0        0
## 30873       0         0         0        0          0          0        0
## 30874       *         *         *        *          *          *        *
## 30875       0         0         0        0          0          0        0
## 30876       *         *         *        *          *          *        *
##       p15ym_se_m p15ym_se_f p15pri_in p15pri_inm p15pri_inf p15pri_co
## 30871          0          0         0          0          0         0
## 30872          0          0         0          0          0         0
## 30873          0          0         0          0          0         0
## 30874          *          *         *          *          *         *
## 30875          0          0         0          0          0         0
## 30876          *          *         *          *          *         *
##       p15pri_com p15pri_cof p15sec_in p15sec_inm p15sec_inf p15sec_co
## 30871          0          0         0          0          0         0
## 30872          0          0         0          0          0         0
## 30873          0          0         0          0          0         0
## 30874          *          *         *          *          *         *
## 30875          0          0         0          0          0         0
## 30876          *          *         *          *          *         *
##       p15sec_com p15sec_cof p18ym_pb p18ym_pb_m p18ym_pb_f graproes
## 30871          0          0        0          0          0        0
## 30872          0          0        0          0          0        0
## 30873          0          0        0          0          0        0
## 30874          *          *        *          *          *        *
## 30875          0          0        0          0          0        0
## 30876          *          *        *          *          *        *
##       graproes_m graproes_f pea pea_m pea_f pe_inac pe_inac_m pe_inac_f
## 30871          0          0   0     0     0       0         0         0
## 30872          0          0   0     0     0       0         0         0
## 30873          0          0   0     0     0       0         0         0
## 30874          *          *   *     *     *       *         *         *
## 30875          0          0   0     0     0       0         0         0
## 30876          *          *   *     *     *       *         *         *
##       pocupada pocupada_m pocupada_f pdesocup pdesocup_m pdesocup_f
## 30871        0          0          0        0          0          0
## 30872        0          0          0        0          0          0
## 30873        0          0          0        0          0          0
## 30874        *          *          *        *          *          *
## 30875        0          0          0        0          0          0
## 30876        *          *          *        *          *          *
##       psinder pder_ss pder_imss pder_iste pder_istee pder_segp p12ym_solt
## 30871       0       0         0         0          0         0          0
## 30872       0       0         0         0          0         0          0
## 30873       0       0         0         0          0         0          0
## 30874       *       *         *         *          *         *          *
## 30875       0       0         0         0          0         0          0
## 30876       *       *         *         *          *         *          *
##       p12ym_casa p12ym_sepa pcatolica pncatolica potras_rel psin_relig
## 30871          0          0         0          0          0          0
## 30872          0          0         0          0          0          0
## 30873          0          0         0          0          0          0
## 30874          *          *         *          *          *          *
## 30875          0          0         0          0          0          0
## 30876          *          *         *          *          *          *
##       tothog hogjef_m hogjef_f pobhog phogjef_m phogjef_f vivtot tvivhab
## 30871      0        0        0      0         0         0      1       *
## 30872      0        0        0      0         0         0      2       *
## 30873      0        0        0      0         0         0      0       0
## 30874      *        *        *      *         *         *      1       *
## 30875      0        0        0      0         0         0      1       *
## 30876      *        *        *      *         *         *      1       *
##       tvivpar vivpar_hab tvivparhab vivpar_des vivpar_ut ocupvivpar
## 30871       *          *          *          *         *          0
## 30872       *          *          *          *         *          0
## 30873       0          0          0          0         0          0
## 30874       *          *          *          *         *          *
## 30875       *          *          *          *         *          0
## 30876       *          *          *          *         *          *
##       prom_ocup pro_ocup_c vph_pisodt vph_pisoti vph_1dor vph_2ymasd
## 30871         0          0          0          0        0          0
## 30872         0          0          0          0        0          0
## 30873         0          0          0          0        0          0
## 30874         *          *          *          *        *          *
## 30875         0          0          0          0        0          0
## 30876         *          *          *          *        *          *
##       vph_1cuart vph_2cuart vph_3ymasc vph_c_elec vph_s_elec vph_aguadv
## 30871          0          0          0          0          0          0
## 30872          0          0          0          0          0          0
## 30873          0          0          0          0          0          0
## 30874          *          *          *          *          *          *
## 30875          0          0          0          0          0          0
## 30876          *          *          *          *          *          *
##       vph_aguafv vph_excsa vph_drenaj vph_nodren vph_c_serv vph_snbien
## 30871          0         0          0          0          0          0
## 30872          0         0          0          0          0          0
## 30873          0         0          0          0          0          0
## 30874          *         *          *          *          *          *
## 30875          0         0          0          0          0          0
## 30876          *         *          *          *          *          *
##       vph_radio vph_tv vph_refri vph_lavad vph_autom vph_pc vph_telef
## 30871         0      0         0         0         0      0         0
## 30872         0      0         0         0         0      0         0
## 30873         0      0         0         0         0      0         0
## 30874         *      *         *         *         *      *         *
## 30875         0      0         0         0         0      0         0
## 30876         *      *         *         *         *      *         *
##       vph_cel vph_inter
## 30871       0         0
## 30872       0         0
## 30873       0         0
## 30874       *         *
## 30875       0         0
## 30876       *         *