May be you want something like:
FDLFDPdata0000[FDLFDPdata0000$ID==69912008,]$tempcalved2<-'2008-03-08'
FDLFDPdata0000$tempcalved2<-factor(FDLFDPdata0000$tempcalved2)
## the factor above just update the levels
Case this is what you want, you can also change
$ID==69912008
$ID %in% c(69912008,....)
Good luck,
milton
On Fri, Jul 24, 2009 at 10:33 PM, jlfmssm <jlfmssm@gmail.com> wrote:
> Hi, everyone,
>
> I want to use a new value to replace a column that is a factor. However
> this
> column is replaced by <NA>
> , which is not what I want. I know this is because the new value is not in
> the levels of that column, but
> I don't know how to fix it.
> Can someone help me to figure this out?
>
> The following is what I did
>
> thanks
>
> jlm
>
>
> > head(FDLFDPdata0000[FDLFDPdata0000$ID==69912008,])
> ID Target Actual Date Time tempcalved2 tempLact2 DIM
> 69912008 50 0.0 2008-01-16 14:42:00 2009-04-14 1
> -454
> 69912008 50 51.8 2008-01-17 05:23:00 2009-04-14 1
> -453
> 69912008 50 0.0 2008-01-17 14:01:00 2009-04-14 1
> -453
> 69912008 50 -53.8 2008-01-17 16:36:00 2009-04-14 1
> -453
> 69912008 0 -26.0 2008-01-18 06:38:00 2009-04-14 1
> -452
> 69912008 50 51.6 2008-01-18 07:11:00 2009-04-14 1
> -452
>
> > levels(FDLFDPdata0000[FDLFDPdata0000$ID==69912008,]$tempcalved2)
> [1] "2008-03-13" "2008-03-15" "2008-03-23"
"2008-03-27" "2008-03-28"
> "2008-03-30" "2008-04-03" "2008-04-05"
"2008-04-06" "2008-04-13"
> "2008-04-14"
> [12] "2008-04-16" "2008-04-17" "2008-04-18"
"2008-04-20" "2008-04-22"
> "2008-04-26" "2008-04-27" "2008-04-30"
"2008-05-01" "2008-05-04"
> "2008-05-08"
> [23] "2008-05-09" "2008-05-13" "2008-05-20"
"2008-05-21" "2008-05-25"
> "2008-05-31" "2008-06-04" "2008-06-05"
"2008-06-06" "2008-06-07"
> "2008-06-09"
> [34] "2008-06-10" "2008-06-11" "2008-06-12"
"2008-06-14" "2008-06-15"
> "2008-06-16" "2008-06-24" "2008-06-29"
"2008-07-03" "2008-07-04"
> "2008-07-05"
> [45] "2008-07-07" "2008-07-09" "2008-07-11"
"2008-07-13" "2008-07-14"
> "2008-07-17" "2008-07-18" "2008-07-19"
"2008-07-20" "2008-07-21"
> "2008-07-23"
> [56] "2008-07-24" "2008-07-25" "2008-07-26"
"2008-07-27" "2008-07-28"
> "2008-07-30" "2008-07-31" "2008-08-01"
"2008-08-03" "2008-08-04"
> "2008-08-08"
> [67] "2008-08-10" "2008-08-12" "2008-08-13"
"2008-08-16" "2008-08-23"
> "2008-08-24" "2008-08-25" "2008-08-31"
"2008-09-01" "2008-09-08"
> "2008-09-10"
> [78] "2008-09-12" "2008-09-14" "2008-09-24"
"2008-09-25" "2008-09-26"
> "2008-09-29" "2008-09-30" "2008-10-01"
"2008-10-02" "2008-10-03"
> "2008-10-04"
> [89] "2008-10-05" "2008-10-09" "2008-10-11"
"2008-10-13" "2008-10-14"
> "2008-10-17" "2008-10-18" "2008-10-20"
"2008-10-21" "2008-10-22"
> "2008-10-23"
> [100] "2008-10-25" "2008-10-27" "2008-10-28"
"2008-10-29" "2008-11-04"
> "2008-11-07" "2008-11-08" "2008-11-09"
"2008-11-10" "2008-11-12"
> "2008-11-14"
> [111] "2008-11-15" "2008-11-16" "2008-11-17"
"2008-11-18" "2008-11-19"
> "2008-11-21" "2008-11-22" "2008-11-24"
"2008-12-02" "2008-12-06"
> "2008-12-07"
> [122] "2008-12-11" "2008-12-17" "2008-12-18"
"2008-12-20" "2008-12-25"
> "2008-12-26" "2008-12-27" "2008-12-30"
"2008-12-31" "2009-01-07"
> "2009-01-09"
> [133] "2009-01-10" "2009-01-13" "2009-01-17"
"2009-01-18" "2009-01-19"
> "2009-01-20" "2009-01-22" "2009-01-23"
"2009-01-25" "2009-01-26"
> "2009-01-28"
> [144] "2009-01-29" "2009-01-31" "2009-02-01"
"2009-02-02" "2009-02-04"
> "2009-02-05" "2009-02-07" "2009-02-08"
"2009-02-09" "2009-02-11"
> "2009-02-12"
> [155] "2009-02-16" "2009-02-19" "2009-02-24"
"2009-02-25" "2009-02-27"
> "2009-02-28" "2009-03-01" "2009-03-04"
"2009-03-06" "2009-03-14"
> "2009-03-18"
> [166] "2009-03-19" "2009-03-20" "2009-03-21"
"2009-03-25" "2009-03-26"
> "2009-03-29" "2009-03-30" "2009-04-01"
"2009-04-04" "2009-04-05"
> "2009-04-08"
> [177] "2009-04-10" "2009-04-14" "2009-04-17"
"2009-04-19" "2009-04-20"
> "2009-04-22" "2009-04-24" "2009-04-25"
"2009-04-26" "2009-04-28"
> "2009-05-01"
> [188] "2009-05-02" "2009-05-03" "2009-05-04"
"2009-05-05" "2009-05-06"
> "2009-05-07" "2009-05-08" "2009-05-11"
"2009-05-15" "2009-05-17"
> "2009-05-18"
> [199] "2009-05-30" "2009-05-31" "2009-06-05"
"2009-06-06" "2009-06-07"
> "2009-06-08" "2009-06-10" "2009-06-12"
"2009-06-14" "2009-06-15"
> "2009-06-18"
> [210] "2009-06-23" "2009-06-24" "2009-06-25"
"2009-06-26" "2009-06-28"
> "2009-06-29" "2009-07-03" "2009-07-04"
"2009-07-05" "2009-07-06"
> "2009-07-08"
> [221] "2009-07-09" "2009-07-12" "2009-07-14"
"2009-07-15" "2009-07-18"
> >
>
>
levels(FDLFDPdata0000[FDLFDPdata0000$ID==69912008,]$tempcalved2)[FDLFDPdata0000[FDLFDPdata0000$ID==69912008,]$tempcalved2]<-'2008-03-08'
> Warning message:
> In `[<-.factor`(`*tmp*`, iseq, value = c(1L, 1L, 1L, 1L, 1L, 1L, :
> invalid factor level, NAs generated
> > FDLFDPdata0000[FDLFDPdata0000$ID==69912008,]
> ID Target Actual Date Time tempcalved2 tempLact2 DIM
> 69912008 50.0 0.0 2008-01-16 14:42:00 <NA>
1
> -454
> 69912008 50.0 51.8 2008-01-17 05:23:00 <NA>
1
> -453
> 69912008 50.0 0.0 2008-01-17 14:01:00 <NA>
1
> -453
> 69912008 50.0 -53.8 2008-01-17 16:36:00 <NA>
1
> -453
> 69912008 0.0 -26.0 2008-01-18 06:38:00 <NA>
1
> -452
> 69912008 50.0 51.6 2008-01-18 07:11:00 <NA>
1
> -452
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> 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<http://www.r-project.org/posting-guide.html>
> and provide commented, minimal, self-contained, reproducible code.
>
[[alternative HTML version deleted]]