R help - May 2010 - Creating Crosstabs using a sparse table

Hi all

I am trying to read in a table from a survey
and get the error below


 gr12 <- read.table("gr12.csv", header=TRUE)
Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings, 
: 
  line 1 did not have 249 elements

how would I go about reading in a table of this data, I am trying to
generate a series of crostabs after I get it in
ie Gender vs q1 q2 q3 q4...
   Religion vs q1 q2 q3...


any help would be appreciated

-- 
View this message in context:
http://r.789695.n4.nabble.com/Creating-Crosstabs-using-a-sparse-table-tp2130247p2130247.html
Sent from the R help mailing list archive at Nabble.com.

On May 4, 2010, at 7:57 PM, merrittr wrote:
>
> Hi all
>
> I am trying to read in a table from a survey
> and get the error below
>
>
> gr12 <- read.table("gr12.csv", header=TRUE)
> Error in scan(file, what, nmax, sep, dec, quote, skip, nlines,  
> na.strings,
> :
>  line 1 did not have 249 elements
You need to split this problem in sections, the first of which is  
getting your data into R. A very useful function to look at files is  
count.fields(). See what it produces with your file and also read:

http://cran.r-project.org/doc/manuals/R-data.html

... If you have missing data elements at the ends of input lines then  
perhaps fill=TRUE will be helpful.
>
> how would I go about reading in a table of this data, I am trying to
> generate a series of crostabs after I get it in
> ie Gender vs q1 q2 q3 q4...
>   Religion vs q1 q2 q3...
Solve the input problem first then table() or xtabs() as approapriate.
>
>
> any help would be appreciated
>
> -- 
David Winsemius, MD
West Hartford, CT

Thanks David I will do that


-----Original Message-----
From: David Winsemius <dwinsemius at comcast.net>
To: merrittr <rob at merrittnet.org>
Cc: r-help at r-project.org
Subject: Re: [R] Creating Crosstabs using a sparse table
Date: Wed, 5 May 2010 10:18:32 -0400
Mailer: Apple Mail (2.936)

On May 4, 2010, at 7:57 PM, merrittr wrote:
>
> Hi all
>
> I am trying to read in a table from a survey
> and get the error below
>
>
> gr12 <- read.table("gr12.csv", header=TRUE)
> Error in scan(file, what, nmax, sep, dec, quote, skip, nlines,  
> na.strings,
> :
>  line 1 did not have 249 elements
You need to split this problem in sections, the first of which is  
getting your data into R. A very useful function to look at files is  
count.fields(). See what it produces with your file and also read:

http://cran.r-project.org/doc/manuals/R-data.html

... If you have missing data elements at the ends of input lines then  
perhaps fill=TRUE will be helpful.
>
> how would I go about reading in a table of this data, I am trying to
> generate a series of crostabs after I get it in
> ie Gender vs q1 q2 q3 q4...
>   Religion vs q1 q2 q3...
Solve the input problem first then table() or xtabs() as approapriate.
>
>
> any help would be appreciated
>
> -- 
David Winsemius, MD
West Hartford, CT