Basic question, looked through the forum and documentation but didnt see a
solution.
So consider
O<-c(1:20)
D<-c("1:","2:","3:","4:","5:","6:","7:","8:","9:","10:","11:","12:","13:","14:","15:","16:",
"17:","18:","19:","20:")
Time<-c(51:70)
AveTT<-data.frame(O,D,Time)
I would like to remove the colon from the "D" column's data. This
is how
the data is being given to me and its too big to put into excel to remove
the colons. I tried the below but neither returns what i want.
AveTT$D<-as.numeric(AveTT$D)
AveTT$D<-substr(AveTT$D,1,nchar(AveTT$D)-1)
so i want
O D Time
1 1 1: 51
2 2 2: 52
3 3 3: 53
4 4 4: 54
5 5 5: 55
6 6 6: 56
7 7 7: 57
8 8 8: 58
9 9 9: 59
10 10 10: 60
to become
O D Time
1 1 1 51
2 2 2 52
3 3 3 53
4 4 4 54
5 5 5 55
6 6 6 56
7 7 7 57
8 8 8 58
9 9 9 59
10 10 10 60
while maintaining the data's integrity. Thanks
JR
--
View this message in context:
http://n4.nabble.com/Removing-colon-from-numerical-data-tp1578397p1578397.html
Sent from the R help mailing list archive at Nabble.com.
On Mar 4, 2010, at 12:12 PM, LCOG1 wrote:> > Basic question, looked through the forum and documentation but didnt > see a > solution. > > So consider > > O<-c(1:20) > D<- > c > ("1 > :","2 > :","3 > :","4 > :","5:","6:","7:","8:","9:","10:","11:","12:","13:","14:","15:","16:", > "17:","18:","19:","20:") > Time<-c(51:70) > > AveTT<-data.frame(O,D,Time)> AveTT$D <- gsub(":", "", AveTT$D)> > > I would like to remove the colon from the "D" column's data. This > is how > the data is being given to me and its too big to put into excel to > remove > the colons. I tried the below but neither returns what i want. > > AveTT$D<-as.numeric(AveTT$D) > > AveTT$D<-substr(AveTT$D,1,nchar(AveTT$D)-1) > > so i want > O D Time > 1 1 1: 51 > 2 2 2: 52 > 3 3 3: 53 > 4 4 4: 54 > 5 5 5: 55 > 6 6 6: 56 > 7 7 7: 57 > 8 8 8: 58 > 9 9 9: 59 > 10 10 10: 60 > > to become > > O D Time > 1 1 1 51 > 2 2 2 52 > 3 3 3 53 > 4 4 4 54 > 5 5 5 55 > 6 6 6 56 > 7 7 7 57 > 8 8 8 58 > 9 9 9 59 > 10 10 10 60 > > while maintaining the data's integrity. Thanks > > JR > > -- > View this message in context: http://n4.nabble.com/Removing-colon-from-numerical-data-tp1578397p1578397.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help at 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 > and provide commented, minimal, self-contained, reproducible code.David Winsemius, MD Heritage Laboratories West Hartford, CT
Try this:
D <- as.numeric(gsub("[[:punct:]]", "", D))
On Thu, Mar 4, 2010 at 2:12 PM, LCOG1 <jroll at lcog.org>
wrote:>
> Basic question, looked through the forum and documentation but didnt see a
> solution.
>
> So consider
>
> O<-c(1:20)
>
D<-c("1:","2:","3:","4:","5:","6:","7:","8:","9:","10:","11:","12:","13:","14:","15:","16:",
> "17:","18:","19:","20:")
> Time<-c(51:70)
>
> AveTT<-data.frame(O,D,Time)
>
>
> I would like to remove the colon from the "D" column's data.
?This is how
> the data is being given to me and its too big to put into excel to remove
> the colons. ?I tried the below but neither returns what i want.
>
> AveTT$D<-as.numeric(AveTT$D)
>
> AveTT$D<-substr(AveTT$D,1,nchar(AveTT$D)-1)
>
> so i want
> ?O ? D Time
> 1 ? 1 ?1: ? 51
> 2 ? 2 ?2: ? 52
> 3 ? 3 ?3: ? 53
> 4 ? 4 ?4: ? 54
> 5 ? 5 ?5: ? 55
> 6 ? 6 ?6: ? 56
> 7 ? 7 ?7: ? 57
> 8 ? 8 ?8: ? 58
> 9 ? 9 ?9: ? 59
> 10 10 10: ? 60
>
> to become
>
> ?O ? D Time
> 1 ? 1 ?1 ? 51
> 2 ? 2 ?2 ? 52
> 3 ? 3 ?3 ? 53
> 4 ? 4 ?4 ? 54
> 5 ? 5 ?5 ? 55
> 6 ? 6 ?6 ? 56
> 7 ? 7 ?7 ? 57
> 8 ? 8 ?8 ? 58
> 9 ? 9 ?9 ? 59
> 10 10 10 ? 60
>
> while maintaining the data's integrity. ?Thanks
>
> JR
>
> --
> View this message in context:
http://n4.nabble.com/Removing-colon-from-numerical-data-tp1578397p1578397.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help at 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
> and provide commented, minimal, self-contained, reproducible code.
>
--
Henrique Dallazuanna
Curitiba-Paran?-Brasil
25? 25' 40" S 49? 16' 22" O