1282 search results for "excel"

Why R is Better Than Excel for Fantasy Football (and most other) Data Analysis

January 13, 2014
By

Many articles have been written on why R is better than Excel for data analysis.  In this post, I will summarize the reasons why R is advantageous in most data The post Why R is Better Than Excel for Fantasy Football (and most other) Data Analysis appeared first on Fantasy Football Analytics.

Read more »

Pivoting Data in R Excel-style

January 2, 2014
By
Pivoting Data in R Excel-style

(This article is referring to an initial proof-of-concept version of r-big-pivot) I have to admit that I very much enjoy pivoting through data using Excel. Its pivoting tool is great for getting a quick insight into a data set’s structure … Continue reading → The post Pivoting Data in R Excel-style appeared first on joy...

Read more »

Excel, fanaticism and R

December 16, 2013
By
Excel, fanaticism and R

This week I’ve been feeling tired of excessive fanaticism (or zealotry) of open source and R in general. I do use a fair amount of OSS and pushed for the adoption of R in our courses; in fact I do think OSS is a good thingTM. I do not like, however, constant yabbering on why

Read more »

Export R Results Tables to Excel – Please don’t kick me out of your club

August 19, 2013
By
Export R Results Tables to Excel – Please don’t kick me out of your club

This post is written as a result of finding the following exchange on one of the R mailing lists:Is-there-a-way-to-export-regression-output-to-an-excel-spreadsheetQuestion: Is there a way to export regression output to an excel spreadsheet?Translation:...

Read more »

Read Excel files from R

July 21, 2013
By

Many people still save their data into Microsoft Excel files. This is an unhappy choice for many reasons but many was already written about this topic. Furthermore, unfortunately Excel become a de facto standard in many business environment and this … Continue reading →

Read more »

An excellent introduction to MapReduce and Hadoop

July 19, 2013
By
An excellent introduction to MapReduce and Hadoop

by Yanchang Zhao, RDataMining.com The lectures in week 3 of a free online course Introduction to Data Science give an excellent introduction to MapReduce and Hadoop, and demonstrate with examples how to use MapReduce to do various tasks, such as, … Continue reading →

Read more »

Quickly read Excel (xlsx) worksheets into R on any platform

June 20, 2013
By

I wrote a couple days about about importing Excel files into R. There are lots of ways to do this, but all the ways that use only R have drawbacks (as I outlined in my last post), and all the other ways require installation of programs other than R. I’m not opposed to using programs

Read more »

Using the Windows Clipboard, or Passing Data Quickly From Excel to R and Back Again

June 19, 2013
By
Using the Windows Clipboard, or Passing Data Quickly From Excel to R and Back Again

Two of my favorite functions are copy.table() and paste.table(). I’m going to turn this story on its head and give you the ending first. The first allows you to copy a data frame to the clipboard in a format that … Continue reading →

Read more »

Quickly read Excel worksheets into R (Windows only…sorry)

June 18, 2013
By

I suppose most companies use the Microsoft Office suite of programs, and my office is no exception. It easy to import data from an API or a database into R, but importing data from an Excel workbook is a different story. There are a few R packages for reading Excel files, but I’ve had problems

Read more »

Writing from R to Excel with xlsx

May 1, 2013
By
Writing from R to Excel with xlsx

Paul Teetor, who is doing yeoman’s duty as one of the organizers of the Chicago R User Group (CRUG), asked recently if I would do a short presentation about a “favorite package”.  I picked xlsx, one of the many packages that provides a bridge between spreadsheets and R.  Here are the slides from my presentation

Read more »