EXCEL FILE

Hi!

Take a look at 'read.table' which will aloow you to import your excell 
file as a data frame. Then, you'll be able to easily construct your 
vectors.

Regards.

Hi gruop,

Pardon my question, but how could I import a excel file with 2 columns 
to R and then work with them as vecors.

Thanks in advance,

______________________________________________
R-help at stat.math.ethz.ch mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help

Ulises M. Alvarez
LAB. DE ONDAS DE CHOQUE
FISICA APLICADA Y TECNOLOGIA AVANZADA
UNAM
umalvarez at fata.unam.mx
Hi gruop,

Pardon my question, but how could I import a excel file with 2 columns 
to R and then work with them as vecors.

Thanks in advance,
Use 'save as' in excel to create 'foo.csv' and then

read.csv(file='foo.csv',sep',',header=T)

(use header=T only if first row has labels, and you may need to include 
a path with your filename)

cheers,
Joel
Hi gruop,

Pardon my question, but how could I import a excel file with 2 columns 
to R and then work with them as vecors.

Thanks in advance,

______________________________________________
R-help at stat.math.ethz.ch mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help

Your favorite stores, helpful shopping tools and great gift ideas.
Experience the convenience of buying online with Shop at Netscape!
http://shopnow.netscape.com/
Joel Kincaid <jfkincaidsu at netscape.net> writes:
Use 'save as' in excel to create 'foo.csv' and then

read.csv(file='foo.csv',sep',',header=T)
Those are the defaults... read.csv(file='foo.csv') should do. Use
header=FALSE if the header is absent. Notice also that in some
locales, CSV files have "," for decimal separator and ";" for the
value. That's where read.csv2 is relevant.
O__  ---- Peter Dalgaard             Blegdamsvej 3  
  c/ /'_ --- Dept. of Biostatistics     2200 Cph. N   
 (*) \(*) -- University of Copenhagen   Denmark      Ph: (+45) 35327918
~~~~~~~~~~ - (p.dalgaard at biostat.ku.dk)             FAX: (+45) 35327907
Those are the defaults... read.csv(file='foo.csv') should do. Use
header=FALSE if the header is absent. Notice also that in some
locales, CSV files have "," for decimal separator and ";" for the
value. That's where read.csv2 is relevant.

This will save me some typing...
and also I goofed with the orginal specification:
 > Joel Kincaid <jfkincaidsu at netscape.net> writes:
 >
 >
 >>Use 'save as' in excel to create 'foo.csv' and then
 >>
 >>read.csv(file='foo.csv',sep',',header=T)
                ^^^^^                       Should have (unnecessarily :) written "sep=','" rather 
than the
syntax error inducing "sep','"      

Cheers, Joel