The best tool for Fantasy Football analytics: Excel or R?

In the early days, I used Excel for basic stuff, but I’ve been playing with R for some fun and funky data crunching. It’s a nice tool to know how to use.

It can be hard, though, to keep up with all the extensions that are being written and released almost daily. But that’s a good problem to have. And for the stuff I do, I definitely prefer R to Excel or an Excel-related application.

For anaylzing Fantasy Football data, somebody who obviously takes Fantasy Football seriously and knows a thing or two about R, seems to agree with me and has written up a good number of reasons why R is the best tool for Fantasy Football data analysis.

Here are a few of his reasons:

1. Data Manipulation. R allows you to manipulate (e.g., subset, recode, merge) data quickly. Some R packages have been designed specifically for these purposes, e.g., plyr. Typically, a majority of the time spent on an analysis project is spent before the analysis—preparing the data. R is much more adept and efficient in data preparation than Excel. Fantasy data scraped from websites often require many steps in data processing to be ready for analysis, so R is ideal.

2. It Supports Larger Data Sets. Excel has restrictions for how large your data can be. Even if if your data don’t exceed this maximum size, Excel can become slow with large data sets (especially after you add tabs, formulas, and references). R supports larger data, and can support big data with packages such as Hadoop.

3. It’s Open Source. Unlike Excel and other proprietary software used for data analysis, R is not a black box. You can examine the code for any function or computation you perform. You can even modify and improve these functions by changing the code.

You may read the rest at Fantasy Football Analytics.

Fantasy Football Analytics: R or Excel

Related Posts

Smart appliances, including a refrigerator, used in an IoT-based spam attack A report by Proofpoint Inc., a security-as-a-service provider, has revealed a spam attack that involved so-called Internet of Things, everyday devices...
OpenShift Online: a non-developer’s guide OpenShift is a Platform as a Service (PaaS) offering from Red Hat, Inc., and OpenShift Online is the hosted or cloud version of it. OpenShift Enterpri...
Disable guest session and Ayatana scrollbar in Ubuntu 11.10 Ubuntu 11.10, the latest stable release of the popular Linux distribution, sports two guest accounts, one in the login screen and the other accessible...
Nuvola Player: Enjoy all your Cloud music services from one interface Nuvola Player is a very simple graphical interface for Cloud music services. If you have more than one of those services that you listen to regularly,...
How to disable Secure Boot on a Lenovo G50 laptop A Lenovo G50 laptop with an AMD CPU and Radeon R5 GPU is the new laptop I bought to replace an old one. Like virtually all OEM computers that ship ...
Guest account and user management on Mandriva 2011 Creating and managing user accounts are very basic tasks that you would need to perform on any operating system. If you are new to Linux and to Mandri...

We Recommend These Vendors and Free Offers

ContainerizeThis 2016 is a free, 2-day conference for all things containers and big data. Featured, will be presentations and free, hands-on workshops. Learn more at

Launch an SSD VPS in Europe, USA, Asia & Australia on Vultr's KVM-based Cloud platform starting at $5:00/month (15 GB SSD, 768 MB of RAM).

Deploy an SSD Cloud server in 55 seconds on DigitalOcean. Built for developers and starting at $5:00/month (20 GB SSD, 512 MB of RAM).

Want to become an expert ethical hacker and penetration tester? Request your free video training course of Online Penetration Testing and Ethical Hacking

Whether you're new to Linux or are a Linux guru, you can learn a lot more about the Linux kernel by requesting your free ebook of Linux Kernel In A Nutshell.

Leave a Comment

Your email address will not be published. Required fields are marked *