Skip to Content
Practical Predictive Analytics
book

Practical Predictive Analytics

by Ralph Winters
June 2017
Beginner to intermediate content levelBeginner to intermediate
576 pages
15h 22m
English
Packt Publishing
Content preview from Practical Predictive Analytics

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Data Superstream: Analytics Engineering

Data Superstream: Analytics Engineering

Alistair Croll, Anna Filippova, Emilie Schario, Lewis Davies, Jacob Frackson, Benn Stancil, Nick Acosta, Elizabeth Caley
R: Predictive Analysis

R: Predictive Analysis

Tony Fischetti, Eric Mayor, Rui Miguel Forte
Python: Advanced Predictive Analytics

Python: Advanced Predictive Analytics

Ashish Kumar, Joseph Babcock

Publisher Resources

ISBN: 9781785886188Supplemental Content