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]]


