Or just read the R Data Import/Export manual that includes comments on
how to deal with Excel.
Best,
Uwe Ligges
On 11.08.2011 11:21, Petr PIKAL wrote:
Hi
In Excel, make sure that your data has a format that corresponds to an R
data frame (first row with column names, consistent column size and data
type).
Export your .XLS worksheet as .CSV file (mydata.csv).
In R, read it into a data frame with
read.csv( "mydata.csv" )
Another option is simple copy/paste way.
In Excel select the data area you want to transfer (preferably formatted
like stated above.
Press Ctrl-C
Change to R
In R command window write
my.data.frame<- read.delim("clipboard",...further options according to
your locale...)
Regards
Petr
> From here, you shold be able to reshapte the data in a way that you can
draw your boxplot.
Rgds,
Rainer
On Thursday 11 August 2011 11:29:23 Blessy chemmannur Francis wrote:
Sir,
I am a beginner in R language. I want to import data from
excel to
R. My data contains not only numeric values but also string values.I
want to
draw a boxplot graph . I can't import or write this string data. it is
essential for my graph.Please give me a suggestion for This.
Thanking You,
BLESSY.C.F.
[[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.
______________________________________________
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-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.
