O'Reilly logo

Practical Predictive Analytics by Ralph Winters

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Spreadsheet files

R provides direct interfaces to Excel tables via the XLConnect or xlsx packages. Excel is prevalent in the corporate world and can contain a lot of useful data and metadata. So, it pays to learn all about the tools which can access spreadsheets. It is also worth learning how to do analytics using spreadsheets, since that will give you valuable insight into the thought process that was used to create the data in the first place.

However, since Excel is a proprietary product, and has many versions on the market, it can still be tricky to use some of these packages. The most convenient way of importing Excel data is to first access it within Excel itself, and then save it as a delimited file using Excel commands, and then reading ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required