[R] How to connect .mdb file
Hi, I'm currently having some problem connect .mdb file into R.
I've installed the RODBC packages and I do the code this way:
channel <- odbcConnectAccess("C:/Users/Documents/XYZ")
channel
and it gave me this :
RODBC Connection 3
Details:
case=nochange
DBQ=C:\USers\JieYi\Documents\NYP\IPP\GCR
Driver={Microsoft Access Driver (*.mdb)}
DriverId=25
FIL=MS Access
MaxBufferSize=2048
PageTimeout=5
UID=admin
I have a total of 5 tables in the .mdb database. any one can help me with
how to get the tables in ?
--
View this message in context:
http://r.789695.n4.nabble.com/How-to-connect-mdb-file-tp4636083.html
Sent from the R help mailing list archive at Nabble.com.
__
R-help@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.
[R] plot only a same variable timing graph
hi all. for example : Table 1 variable: BERTH TIME A 9:52 D 7:43 C 8:33 A 10:13 I want to plot maybe only Berth 'A' timing. How can i do that? -- View this message in context: http://r.789695.n4.nabble.com/plot-only-a-same-variable-timing-graph-tp4636252.html Sent from the R help mailing list archive at Nabble.com. __ R-help@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.
[R] plot graph by first letter
Hi all, may i know is it possible to plot a graph by first letter? for example: Name: Age: Angel20 Amelia 20 Bernard 19 Stephanie 20 Vanessa 22 Angeline 23 Camel 21 If I want to plot the name started with letter 'A' and their Angel, how is it possible to plot it? Thanks. -- View this message in context: http://r.789695.n4.nabble.com/plot-graph-by-first-letter-tp4636266.html Sent from the R help mailing list archive at Nabble.com. __ R-help@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.
Re: [R] plot graph by first letter
Hi, for my dataset is actually retrieve from a access file not a textfile.thanks
Date: Thu, 12 Jul 2012 11:58:30 -0700
From: ml-node+s789695n4636343...@n4.nabble.com
To: jubil...@live.com.sg
Subject: Re: plot graph by first letter
Hi,
Try this:
dat1<-read.table(text="
Name Age
Angel20
Amelia 20
Bernard 19
Stephanie 20
Vanessa 22
Angeline 23
Camel 21
",sep="",header=TRUE)
dat2<-dat1[grepl("[A].*",dat1$Name),]
dat2
Name Age
1Angel 20
2 Amelia 20
6 Angeline 23
rownames(dat2)<-1:nrow(dat2)
#Now you might be okay to plot.
?plot()
A.K.
----- Original Message -
From: imnew <[hidden email]>
To: [hidden email]
Cc:
Sent: Thursday, July 12, 2012 4:15 AM
Subject: [R] plot graph by first letter
Hi all, may i know is it possible to plot a graph by first letter?
for example:
Name: Age:
Angel20
Amelia 20
Bernard 19
Stephanie 20
Vanessa 22
Angeline 23
Camel 21
If I want to plot the name started with letter 'A' and their Angel, how is
it possible to plot it?
Thanks.
--
View this message in context:
http://r.789695.n4.nabble.com/plot-graph-by-first-letter-tp4636266.html
Sent from the R help mailing list archive at Nabble.com.
__
[hidden email] 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.
__
[hidden email] 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.
If you reply to this email, your message will be added to the
discussion below:
http://r.789695.n4.nabble.com/plot-graph-by-first-letter-tp4636266p4636343.html
To unsubscribe from plot graph by first letter, click here.
NAML
--
View this message in context:
http://r.789695.n4.nabble.com/plot-graph-by-first-letter-tp4636266p4636383.html
Sent from the R help mailing list archive at Nabble.com.
[[alternative HTML version deleted]]
__
R-help@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.
