Re: [R] Excel export into R

From: Keizer_71 <christophe.lo_at_gmail.com>
Date: Thu, 06 Mar 2008 03:05:11 -0800 (PST)

Hi Richie,

I apologize. I thought i deleted this thread since it is resolved by using scan() function.

thank you again,
Kei

Richard Cotton wrote:
>

>> I have this in excel
>> 
>> Control
>> 543_BU
>> 123_AT
>> 432_CU
>> 
>> 
>> I want to be able to import to R so that it will read like this
>> 
>> c<-c("543_BU","123_AT","432_CU")

>
> See the help page for read.csv
> ?read.csv
>
> ...and the R Data Import/Export manual
> http://cran.r-project.org/doc/manuals/R-data.html
>
> Two things to remember:
> 1. It will be much more straightforward if you save your excel spreadsheet
> as a CSV file, rather than the Excel native format.
> 2. read.csv will import the data as a data frame rather than a vector, and
> will by default coerce the strings to factors.
>
> Regards,
> Richie.
>
> Mathematical Sciences Unit
> HSL
>
>
> ------------------------------------------------------------------------
> ATTENTION:
>
> This message contains privileged and confidential inform...{{dropped:20}}
>
> ______________________________________________
> 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.
>
>
> -----
> Regards,
> Richie.
>
> Mathematical Sciences Unit
> HSL
>
-- 
View this message in context: http://www.nabble.com/Excel-export-into-R-tp15863252p15870982.html
Sent from the R help mailing list archive at Nabble.com.

______________________________________________
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.
Received on Thu 06 Mar 2008 - 11:09:39 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 06 Mar 2008 - 11:30:19 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive