Import Excel .xls files into R

 

What is R ? R is a programming language and software environment for statistical computing and graphics. It is developed by
statisticians around the world and is free software, released under the GNU General Public License.

In order to import .xls file into R, we must convert the file to csv first. One way to this is to open xls files in a speadsheet application and then export to csv format. Another way is to use a small convert program, handily available on … Google. An example: xls2csv:

xls2csv -x dataset.xls -c dataset.csv

After converting to csv, import data with

> dataset1 <- read.csv(file = "~/dataset.csv")

  • Digg
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • StumbleUpon
  • Ma.gnolia
  • Reddit

Related posts:

Post a Comment

Your email is never published nor shared. Required fields are marked *

blog comments powered by Disqus