Re: [R] Re placing null values (#NULL!)

2009-07-22 Thread Michael Knudsen
On Wed, Jul 22, 2009 at 10:18 PM, Josh Roll wrote: > In `[<-.factor`(`*tmp*`, Props_$pct_vacant == "#NULL!", value = 0) : >   invalid factor level, NAs generated > > Thats what made me wonder if the "#NULL!" value was being treated > differently than a typical "NULL" value.  Thoughts? I would lik

Re: [R] Re placing null values (#NULL!)

2009-07-17 Thread Michael Knudsen
On Fri, Jul 17, 2009 at 10:37 PM, PDXRugger wrote: > So i need to replace the the #NULL! with 0.  I have tried: > > Props_pct_vacant<-Props_pct_vacant[Props_$pct_vacant !="#NULL!"] Try this instead: Props_$pct_vacant[which(Props_$pct_vacant=="#NULL!")] = 0 -- Michael Knudsen micknud...@gmail.c

[R] Re placing null values (#NULL!)

2009-07-17 Thread PDXRugger
I am stumped. I have a data set with multiple columns and about 65,000 case. Some of the cases have a "#NULL!" value so for dataframe "Props_": access_emp pct_vacant TAVAIL park PARKACRES totlandare 4538 52.15 #NULL! 01 22.9974,129.70400 4539 52.