Hi! I think you have problem with "flag_var". I suggest to put just "flagvar". Do not use "_" in variable names. I would suggest not to use both "_" or "-" anywhere in data file. I am just a beginner with R but think that is the problem... Cheers! Tanja.
On Sat, Dec 8, 2012 at 8:29 PM, Prof Brian Ripley <rip...@stats.ox.ac.uk> wrote: > On 08/12/2012 19:10, Muhuri, Pradip (SAMHSA/CBHSQ) wrote: >> >> >> 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. > > > Well, we have a whole manual on this, mentioned on ?read.table (see See > Also) Have you read it? fortunes::fortune(14) applies. > > The issue is what the separator is. You have specified whitespace, and that > is not correct. The original might have had tabs (see ?read.delim) but as > pasted into this email only a human can disentangle this file. > > >> 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) >> ______________________________________________ >> R-help@r-project.org mailing list >> https://stat.ethz.ch/mailman/listinfo/r-help >> PLEASE do read the posting guide >> http://www.R-project.org/posting-guide.html >> and provide commented, minimal, self-contained, reproducible code. >> > > > -- > Brian D. Ripley, rip...@stats.ox.ac.uk > Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ > University of Oxford, Tel: +44 1865 272861 (self) > 1 South Parks Road, +44 1865 272866 (PA) > Oxford OX1 3TG, UK Fax: +44 1865 272595 > > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
