Re: [R] detecting null values in a CSV file

2008-09-19 Thread jim holtman
t;> Here's an example: >> >> data <- runif(100,0,10) >> data[runif(20,0,100)] <- NA >> file.contents <- matrix(data, ncol = 5, byrow = TRUE) >> for (i in 1:5) { >> print (length(na.omit(file.contents[,i]))) >> } >> >> >> -Or

Re: [R] detecting null values in a CSV file

2008-09-19 Thread Jason Thibodeau
> > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > On Behalf Of Jason Thibodeau > Sent: Thursday, September 18, 2008 10:12 AM > To: r-help@r-project.org > Subject: [R] detecting null values in a CSV file > > Hello all, > > I have a C

Re: [R] detecting null values in a CSV file

2008-09-18 Thread Hutchinson,David [PYR]
PROTECTED] On Behalf Of Jason Thibodeau Sent: Thursday, September 18, 2008 10:12 AM To: r-help@r-project.org Subject: [R] detecting null values in a CSV file Hello all, I have a CSV file, that is 2411 columns wide. There are certain instances in teh file, where null values are located. That

Re: [R] detecting null values in a CSV file

2008-09-18 Thread Jason Thibodeau
Phil's suggestion worked like a charm. My NA's were counted in the frequency table. Thanks for the help, all! On Thu, Sep 18, 2008 at 1:28 PM, Henrik Bengtsson <[EMAIL PROTECTED]>wrote: > What have you tried this far? Can't you parse them as missing values, > i.e. NAs? See ?read.csv and argum

Re: [R] detecting null values in a CSV file

2008-09-18 Thread Jason Thibodeau
I haven't given it a shot yet. To complicate matters further, this file I have already passed through a filter, which has already converted my null values to NA. your insight might be of assistance. On Thu, Sep 18, 2008 at 1:30 PM, Sebastian Weirich <[EMAIL PROTECTED]>wrote: Hello, maybe you lo

Re: [R] detecting null values in a CSV file

2008-09-18 Thread Henrik Bengtsson
What have you tried this far? Can't you parse them as missing values, i.e. NAs? See ?read.csv and arguments '...', i.e. the arguments '...' are passed to read.table() which takes argument 'na.strings' - a character *vector* of strings that you want to be interpreted as NAs. See ?read.table for m

[R] detecting null values in a CSV file

2008-09-18 Thread Jason Thibodeau
Hello all, I have a CSV file, that is 2411 columns wide. There are certain instances in teh file, where null values are located. That is: two commas together, without anything in the middle. In a certain section, the only possible values are NULL, 0,1,and 2. I need to be able to detect these NULL'