Re: [R] Specify Path of an Excel file in R

2008-02-17 Thread Charles Annis, P.E.
One way that works for lazy people like me is to use file.choose().

1) Type in "file.choose()" without the quotes and hit 
2) Navigate to the folder and file that you want and click on it.
3) R will show you the complete path to your file.

An even easier way is to do something like this:

my.stuff <- read.csv(file.choose(), ...

and then navigate to your file.

Charles Annis, P.E.

[EMAIL PROTECTED]
phone: 561-352-9699
eFax:  614-455-3265
http://www.StatisticalEngineering.com
 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of savanna3000
Sent: Sunday, February 17, 2008 10:53 AM
To: r-help@r-project.org
Subject: [R] Specify Path of an Excel file in R


Hello Helpers,


   I have an Excel file on my desktop (.csv) which I want to use in my R
worksheet, how can I specify the path while using read.csv() ?


   Savanna
-- 
View this message in context:
http://www.nabble.com/Specify-Path-of-an-Excel-file-in-R-tp15530586p15530586
.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-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] Specify Path of an Excel file in R

2008-02-17 Thread My Coyne
Try:
X<- read.csv ("") or
Y<- read.delim("", sep=",", header=T)

Example, if your file is in C-directory, file name is my_file, and the file
has a header.
X<- read.csv("c:\\my_file") or
Y<- read.delim("c:\\my_file", sep=",", header=T)



My D. Coyne



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of savanna3000
Sent: Sunday, February 17, 2008 10:53 AM
To: r-help@r-project.org
Subject: [R] Specify Path of an Excel file in R


Hello Helpers,


   I have an Excel file on my desktop (.csv) which I want to use in my R
worksheet, how can I specify the path while using read.csv() ?


   Savanna
-- 
View this message in context:
http://www.nabble.com/Specify-Path-of-an-Excel-file-in-R-tp15530586p15530586
.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-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] Specify Path of an Excel file in R

2008-02-17 Thread savanna3000

Hello Helpers,


   I have an Excel file on my desktop (.csv) which I want to use in my R
worksheet, how can I specify the path while using read.csv() ?


   Savanna
-- 
View this message in context: 
http://www.nabble.com/Specify-Path-of-an-Excel-file-in-R-tp15530586p15530586.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.