I read a table from Microsoft Access using RODBC. Some of the variables had a name with a space in it. R has no problem with it but I do. I cannot find out how to specify the space names(alltime) [1] "ID" "LVL7" "Ref Pv No" "Ref Pv Name" "DOS" "Pt Last Name" "Pt First Name" "MRN" "CPT" "CPT Desc" "DxCd1" "DxCd2" "DxCd3" "DxCd4" [15] "DOE" But what do I do if I want to do something such as this> alltime[grep("MIDDLE EAR EXPLORE",alltime$CPT Desc,]Error: unexpected symbol in "alltime[grep("MIDDLE EAR EXPLORE",alltime$CPT Desc" Farrel Buchinsky Sent from Pittsburgh, Pennsylvania, United States [[alternative HTML version deleted]]
Farrel Buchinsky-3 wrote:> > I read a table from Microsoft Access using RODBC. Some of the variables > had > a name with a space in it. > R has no problem with it but I do. > I cannot find out how to specify the space > > names(alltime) > [1] "ID" "LVL7" "Ref Pv No" "Ref Pv Name" "DOS" > "Pt Last Name" "Pt First Name" "MRN" "CPT" > "CPT > Desc" "DxCd1" "DxCd2" "DxCd3" "DxCd4" > [15] "DOE" > > But what do I do if I want to do something such as this >> alltime[grep("MIDDLE EAR EXPLORE",alltime$CPT Desc,] > Error: unexpected symbol in "alltime[grep("MIDDLE EAR EXPLORE",alltime$CPT > Desc" > > > Farrel Buchinsky > >The following might work: alltime[grep("MIDDLE EAR EXPLORE",alltime[[ "CPT Desc ]] ] -Charlie ----- Charlie Sharpsteen Undergraduate Environmental Resources Engineering Humboldt State University -- View this message in context: http://www.nabble.com/space-in-column-name-tp24559626p24559726.html Sent from the R help mailing list archive at Nabble.com.
cls59 wrote:> >The following might work: alltime[grep("MIDDLE EAR EXPLORE",alltime[[ "CPT Desc ]] ] -Charlie ACK! Terribly sorry about the double post- but I forgot to close the quote. It should be: alltime[grep("MIDDLE EAR EXPLORE",alltime[[ "CPT Desc" ]] ] Maybe I should wait until AFTER my morning coffee to browse R-help... ----- Charlie Sharpsteen Undergraduate Environmental Resources Engineering Humboldt State University -- View this message in context: http://www.nabble.com/space-in-column-name-tp24559626p24559754.html Sent from the R help mailing list archive at Nabble.com.
I sifted some more and read about a workaround for the problem. I could simply rename the columns so that there were no more spaces names(alltime) <-gsub(" ",".", names(alltime))> names(alltime)[1] "ID" "LVL7" "Ref.Pv.No" "Ref.Pv.Name" "DOS" "Pt.Last.Name" "Pt.First.Name" "MRN" "CPT" "CPT.Desc" "DxCd1" "DxCd2" "DxCd3" "DxCd4" [15] "DOE" Farrel Buchinsky Google Voice Tel: (412) 567-7870 Sent from Pittsburgh, Pennsylvania, United States On Sun, Jul 19, 2009 at 14:32, Farrel Buchinsky <fjbuch@gmail.com> wrote:> I read a table from Microsoft Access using RODBC. Some of the variables had > a name with a space in it. > R has no problem with it but I do. > I cannot find out how to specify the space > > names(alltime) > [1] "ID" "LVL7" "Ref Pv No" "Ref Pv Name" "DOS" > "Pt Last Name" "Pt First Name" "MRN" "CPT" > "CPT Desc" "DxCd1" "DxCd2" "DxCd3" "DxCd4" > > [15] "DOE" > > But what do I do if I want to do something such as this > > alltime[grep("MIDDLE EAR EXPLORE",alltime$CPT Desc,] > Error: unexpected symbol in "alltime[grep("MIDDLE EAR EXPLORE",alltime$CPT > Desc" > > > Farrel Buchinsky > > > Sent from Pittsburgh, Pennsylvania, United States >[[alternative HTML version deleted]]
use 'make.names'> make.names("MIDDLE EAR EXPLORE")[1] "MIDDLE.EAR.EXPLORE" On Sun, Jul 19, 2009 at 2:32 PM, Farrel Buchinsky<fjbuch at gmail.com> wrote:> I read a table from Microsoft Access using RODBC. Some of the variables had > a name with a space in it. > R has no problem with it but I do. > I cannot find out how to specify the space > > names(alltime) > ?[1] "ID" ? ? ? ? ? ?"LVL7" ? ? ? ? ?"Ref Pv No" ? ? "Ref Pv Name" ? "DOS" > ? ? ? ?"Pt Last Name" ?"Pt First Name" "MRN" ? ? ? ? ? "CPT" ? ? ? ? ? "CPT > Desc" ? ? ?"DxCd1" ? ? ? ? "DxCd2" ? ? ? ? "DxCd3" ? ? ? ? "DxCd4" > [15] "DOE" > > But what do I do if I want to do something such as this >> alltime[grep("MIDDLE EAR EXPLORE",alltime$CPT Desc,] > Error: unexpected symbol in "alltime[grep("MIDDLE EAR EXPLORE",alltime$CPT > Desc" > > > Farrel Buchinsky > > > Sent from Pittsburgh, Pennsylvania, United States > > ? ? ? ?[[alternative HTML version deleted]] > > ______________________________________________ > 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. >-- Jim Holtman Cincinnati, OH +1 513 646 9390 What is the problem that you are trying to solve?