Re: [R] Excel export into R

From: <Richard.Cotton_at_hsl.gov.uk>
Date: Thu, 06 Mar 2008 10:38:32 +0000


> 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. Received on Thu 06 Mar 2008 - 10:41:12 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