Hi all, I am trying in vain to create a new object "Year" in my data frame from existing Date data. I have tried many different approaches, but can't seem to get it to work. Here is an example of some code I tried.
date1<- as.Date(wells$Date,"%m/%d/%Y") wells$year<-as.numeric(format(date1, "%Y")) I am starting with data that looks like this. ID Date DepthtoWater_bgs test test2 1 BC-0004 41163 260.60 3 1 2 BC-0004 41255 261.65 4 2 3 BC-0003 41345 166.58 5 3 4 BC-0002 41351 317.85 6 4 5 BC-0004 41355 262.15 7 5 6 BC-0003 41438 167.55 8 6 7 BC-0004 41438 265.45 9 7 8 BC-0002 41443 317.25 10 8 9 BC-0002 41521 321.25 11 9 10 BC-0003 41522 168.65 12 10 11 BC-0004 41522 266.15 13 11 12 BC-0003 41627 168.95 14 12 13 BC-0004 41627 265.25 15 13 14 BC-0002 41634 312.31 16 14 15 BC-0003 41703 169.25 17 15 16 BC-0004 41703 265.05 18 16 17 BC-0002 41710 313.01 19 17 18 BC-0003 41795 168.85 20 18 19 BC-0004 41795 266.95 21 19 20 BC-0002 41801 330.41 22 20 21 BC-0003 41905 169.75 23 21 22 BC-0004 41905 267.75 24 22 23 BC-0002 41906 321.01 25 23 Any help would be greatly appreciated! -Steve Sent from my iPhone ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.