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?