Re: [R] To import data to R from Excel

2011-08-11 Thread Uwe Ligges
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

Re: [R] To import data to R from Excel

2011-08-11 Thread Petr PIKAL
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" ) Anot

Re: [R] To import data to R from Excel

2011-08-11 Thread Rainer Schuermann
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" ) >From here, you shold be

[R] To import data to R from Excel

2011-08-11 Thread Blessy chemmannur Francis
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.