[R] read.table()
Muhuri, Pradip (SAMHSA/CBHSQ)
Pradip.Muhuri at samhsa.hhs.gov
Sat Dec 8 20:10:58 CET 2012
Hi List,
I have spent more than 30 minutes, but failed to read in this file using the read.table() function. I could not figure out how to fix the following error.
Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings, : line 1 did not have 6 elements
Any help would be be appreciated.
Thanks,
Pradip Muhuri
####### below is the reproducible example
xd1 <- "race age percent sepercent flag_var
Mexican 12-17 5.7926 0.64195 any
Puerto Rican 12-17 5.1975 0.24929 any
Cuban 12-17 3.7977 1.00487 any
C-S American 12-17 4.3665 0.55329 any
Dominican 12-17 1.8149 0.46677 any
Spanish (Spain) 12-17 6.1971 0.98386 any
Multi Hisp Eth 12-17 6.7006 1.12464 any
NH White 12-17 4.8442 0.08660 any
NH Black 12-17 3.6943 0.16045 any
NH AM-AK 12-17 9.6325 1.06100 any
NH HI-OPI 12-17 3.9189 1.08047 any
NH Asian 12-17 1.9115 0.28432 any
NH Multiracial 12-17 6.4255 0.51434 any
Mexican 18-25 8.9284 0.73022 any
Puerto Rican 18-25 6.1364 0.28394 any
Cuban 18-25 8.6782 1.45543 any
C-S American 18-25 5.9360 0.59899 any
Dominican 18-25 7.7642 1.64553 any
Spanish (Spain) 18-25 9.2632 1.15652 any
Multi Hisp Eth 18-25 11.3566 1.79282 any
NH White 18-25 8.6484 0.11866 any
NH Black 18-25 7.5972 0.24926 any
NH AM-AK 18-25 13.5041 1.57275 any
NH HI-OPI 18-25 8.0227 1.41348 any
NH Asian 18-25 3.2701 0.32414 any
NH Multiracial 18-25 10.6489 0.85105 any
Mexican 26+ 3.2110 0.51683 any
Puerto Rican 26+ 1.6273 0.15033 any
Cuban 26+ 1.4419 0.44118 any
C-S American 26+ 1.0187 0.26594 any
Dominican 26+ 0.9554 0.50275 any
Spanish (Spain) 26+ 2.5976 0.86230 any
Multi Hisp Eth 26+ 1.1345 0.66375 any
NH White 26+ 1.5510 0.04156 any
NH Black 26+ 2.8763 0.15133 any
NH AM-AK 26+ 3.9674 0.76611 any
NH HI-OPI 26+ 1.2919 0.66205 any
NH Asian 26+ 0.7207 0.13870 any
NH Multiracial 26+ 3.0668 0.52334 any
Mexican 12-17 4.3152 0.53235 mrj
Puerto Rican 12-17 3.7237 0.20969 mrj
Cuban 12-17 2.0616 0.67248 mrj
C-S American 12-17 3.3282 0.47392 mrj
Dominican 12-17 1.3797 0.40435 mrj
Spanish (Spain) 12-17 5.1810 0.93979 mrj
Multi Hisp Eth 12-17 4.8915 0.94816 mrj
NH White 12-17 3.6190 0.07379 mrj
NH Black 12-17 2.8196 0.14042 mrj
NH AM-AK 12-17 6.5091 0.85124 mrj
NH HI-OPI 12-17 3.6267 1.06724 mrj
NH Asian 12-17 1.3162 0.23575 mrj
NH Multiracial 12-17 5.0657 0.49614 mrj
Mexican 18-25 7.3802 0.67992 mrj
Puerto Rican 18-25 4.3260 0.24191 mrj
Cuban 18-25 6.1433 1.19242 mrj
C-S American 18-25 3.9166 0.51272 mrj
Dominican 18-25 5.8000 1.24097 mrj
Spanish (Spain) 18-25 6.8646 1.01387 mrj
Multi Hisp Eth 18-25 10.1134 1.75013 mrj
NH White 18-25 5.8656 0.10100 mrj
NH Black 18-25 6.6869 0.23643 mrj
NH AM-AK 18-25 11.2989 1.51687 mrj
NH HI-OPI 18-25 5.6302 1.14561 mrj
NH Asian 18-25 2.3418 0.28309 mrj
NH Multiracial 18-25 8.2696 0.77139 mrj
Mexican 26+ 1.1658 0.33967 mrj
Puerto Rican 26+ 0.6757 0.09329 mrj
Cuban 26+ 0.6653 0.31239 mrj
C-S American 26+ 0.3177 0.17604 mrj
Dominican 26+ 0.5616 0.39780 mrj
Spanish (Spain) 26+ 1.8078 0.82590 mrj
Multi Hisp Eth 26+ 0.8468 0.63529 mrj
NH White 26+ 0.6915 0.02791 mrj
NH Black 26+ 1.5675 0.12031 mrj
NH AM-AK 26+ 1.7273 0.37673 mrj
NH HI-OPI 26+ 0.0356 0.03535 mrj
NH Asian 26+ 0.2687 0.07564 mrj
NH Multiracial 26+ 1.3419 0.30074 mrj
Mexican 12-17 1.2074 0.36082 anl
Puerto Rican 12-17 1.0772 0.11547 anl
Cuban 12-17 1.2569 0.67109 anl
C-S American 12-17 0.6213 0.22726 anl
Dominican 12-17 0.1412 0.08552 anl
Spanish (Spain) 12-17 0.9625 0.25453 anl
Multi Hisp Eth 12-17 1.2863 0.43909 anl
NH White 12-17 1.1490 0.04289 anl
NH Black 12-17 0.5932 0.06220 anl
NH AM-AK 12-17 1.9117 0.50122 anl
NH HI-OPI 12-17 0.3833 0.20240 anl
NH Asian 12-17 0.4782 0.14706 anl
NH Multiracial 12-17 1.5369 0.25321 anl
Mexican 18-25 1.1836 0.24209 anl
Puerto Rican 18-25 1.0337 0.11015 anl
Cuban 18-25 1.2738 0.45891 anl
C-S American 18-25 0.5598 0.15047 anl
Dominican 18-25 0.4720 0.31559 anl
Spanish (Spain) 18-25 1.7871 0.64048 anl
Multi Hisp Eth 18-25 1.2764 0.48779 anl
NH White 18-25 2.0818 0.05831 anl
NH Black 18-25 0.7851 0.07803 anl
NH AM-AK 18-25 1.8964 0.46240 anl
NH HI-OPI 18-25 1.9397 0.73301 anl
NH Asian 18-25 0.4858 0.13528 anl
NH Multiracial 18-25 1.7864 0.30651 anl
Mexican 26+ 0.4014 0.08306 anl
Puerto Rican 26+ 0.4536 0.07721 anl
Cuban 26+ 0.2164 0.17096 anl
C-S American 26+ 0.2233 0.09101 anl
Dominican 26+ 0.0000 0.00000 anl
Spanish (Spain) 26+ 1.1527 0.74125 anl
Multi Hisp Eth 26+ 0.0303 0.03045 anl
NH White 26+ 0.4970 0.02275 anl
NH Black 26+ 0.3748 0.06124 anl
NH AM-AK 26+ 1.4842 0.52284 anl
NH HI-OPI 26+ 0.3898 0.34827 anl
NH Asian 26+ 0.2536 0.07643 anl
NH Multiracial 26+ 0.5120 0.18326 anl
Mexican 12-17 0.2453 0.15761 coc
Puerto Rican 12-17 0.4351 0.06999 coc
Cuban 12-17 0.2472 0.24698 coc
C-S American 12-17 0.2399 0.15804 coc
Dominican 12-17 0.0000 0.00000 coc
Spanish (Spain) 12-17 0.5315 0.30907 coc
Multi Hisp Eth 12-17 0.9797 0.53981 coc
NH White 12-17 0.3559 0.02305 coc
NH Black 12-17 0.0220 0.01235 coc
NH AM-AK 12-17 0.3588 0.23956 coc
NH HI-OPI 12-17 0.0000 0.00000 coc
NH Asian 12-17 0.1171 0.07887 coc
NH Multiracial 12-17 0.4702 0.14823 coc
Mexican 18-25 1.1540 0.26424 coc
Puerto Rican 18-25 1.3422 0.12707 coc
Cuban 18-25 1.6312 0.69363 coc
C-S American 18-25 0.8669 0.23394 coc
Dominican 18-25 0.6003 0.43959 coc
Spanish (Spain) 18-25 1.9886 0.59004 coc
Multi Hisp Eth 18-25 1.8588 0.86984 coc
NH White 18-25 1.3990 0.04700 coc
NH Black 18-25 0.3640 0.04961 coc
NH AM-AK 18-25 2.2718 0.77117 coc
NH HI-OPI 18-25 0.8386 0.47913 coc
NH Asian 18-25 0.1947 0.05994 coc
NH Multiracial 18-25 1.5209 0.30649 coc
Mexican 26+ 1.4155 0.39542 coc
Puerto Rican 26+ 0.5618 0.09323 coc
Cuban 26+ 0.7766 0.31905 coc
C-S American 26+ 0.3364 0.15414 coc
Dominican 26+ 0.2632 0.26477 coc
Spanish (Spain) 26+ 0.1596 0.07740 coc
Multi Hisp Eth 26+ 0.2521 0.18020 coc
NH White 26+ 0.3928 0.02073 coc
NH Black 26+ 1.1867 0.09546 coc
NH AM-AK 26+ 0.6865 0.24570 coc
NH HI-OPI 26+ 0.5155 0.49176 coc
NH Asian 26+ 0.0787 0.04558 coc
NH Multiracial 26+ 1.1320 0.37928 coc
Mexican 12-17 0.6556 0.23195 inh
Puerto Rican 12-17 0.6060 0.08943 inh
Cuban 12-17 0.4765 0.36661 inh
C-S American 12-17 0.3629 0.12994 inh
Dominican 12-17 0.0300 0.03006 inh
Spanish (Spain) 12-17 0.2020 0.11445 inh
Multi Hisp Eth 12-17 0.7095 0.32063 inh
NH White 12-17 0.4161 0.02587 inh
NH Black 12-17 0.2608 0.04218 inh
NH AM-AK 12-17 1.3372 0.40763 inh
NH HI-OPI 12-17 0.1116 0.06566 inh
NH Asian 12-17 0.1580 0.08034 inh
NH Multiracial 12-17 0.5472 0.13080 inh
Mexican 18-25 0.0160 0.01601 inh
Puerto Rican 18-25 0.2163 0.06270 inh
Cuban 18-25 0.3252 0.32468 inh
C-S American 18-25 0.2238 0.12254 inh
Dominican 18-25 0.9445 0.94734 inh
Spanish (Spain) 18-25 0.0443 0.03141 inh
Multi Hisp Eth 18-25 0.6523 0.57082 inh
NH White 18-25 0.1016 0.01257 inh
NH Black 18-25 0.0617 0.02371 inh
NH AM-AK 18-25 0.2387 0.14246 inh
NH HI-OPI 18-25 0.0000 0.00000 inh
NH Asian 18-25 0.1894 0.06962 inh
NH Multiracial 18-25 0.0562 0.03261 inh
Mexican 26+ 0.0160 0.01600 inh
Puerto Rican 26+ 0.0185 0.01276 inh
Cuban 26+ 0.0000 0.00000 inh
C-S American 26+ 0.0696 0.06954 inh
Dominican 26+ 0.0000 0.00000 inh
Spanish (Spain) 26+ 0.1571 0.11467 inh
Multi Hisp Eth 26+ 0.0000 0.00000 inh
NH White 26+ 0.0174 0.00456 inh
NH Black 26+ 0.0131 0.00757 inh
NH AM-AK 26+ 0.2587 0.24381 inh
NH HI-OPI 26+ 0.0000 0.00000 inh
NH Asian 26+ 0.0607 0.03372 inh
NH Multiracial 26+ 0.0433 0.02960 inh"
agerace <- read.table(textConnection(xd1), header=TRUE, as.is=TRUE)
More information about the R-help
mailing list