[R] To import data to R from Excel

[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 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 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.
>>
>> ______________________________________________
>> 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.
>
> ______________________________________________
> 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.