1617 search results for "Excel"

Importing an Excel Workbook into R

June 5, 2014
By
Importing an Excel Workbook into R

The usual route for importing data from spreadsheet applications like Excel or OpenOffice into R involves first exporting the data in CSV format. A newer (c. 2011) and more efficient CRAN package, called XLConnect, facilitates reading an entire Excel workbook and manipulating worksheets and cells programmatically from within R. XLConnect doesn't require a running installation...

Read more »

Updates to repmis: caching downloaded data and Excel data downloading

May 11, 2014
By

Over the past few months I’ve added a few improvements to the repmis–miscellaneous functions for reproducible research–R package. I just want to briefly highlight two of them: Caching downloaded data sets. source_XlsxData for downloading data in Excel formatted files. Both of these capabilities are in repmis version 0.2.9 and greater. Caching When working with data sourced directly from the internet, it can be...

Read more »

Automatically Exporting Multiple Cross Tables from Tableau Server into Excel

May 10, 2014
By
Automatically Exporting Multiple Cross Tables from Tableau Server into Excel

Introduction The following blog post is based on a classical reporting task most of the people working in BI got frequently: Besides all the nice dashboards you create in Tableau, from time to time people will approach you with a request for a “data extract” – reports that...

Read more »

Control R from Excel

February 20, 2014
By
Control R from Excel

Here is a simple script modified from univie.ac.at that you can just run in R. Follow the instructions in the ensuing dilaogue boxes after running the script. This RExcel interface will help you if you tend to work with people whose knowledge of R is ...

Read more »

A million ways to connect R and Excel

February 11, 2014
By

In quantitative finance both R and Excel are the basis tools for any type of analysis. Whenever one has to use Excel in conjunction with R, there are many ways to approach the problem and many solutions. It depends on what you really want to do and the size of the dataset you’re dealing with. I

Read more »

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 »

Sponsors

Mango solutions



RStudio homepage



Zero Inflated Models and Generalized Linear Mixed Models with R

Quantide: statistical consulting and training

datasociety

http://www.eoda.de





ODSC

ODSC

CRC R books series





Six Sigma Online Training









Contact us if you wish to help support R-bloggers, and place your banner here.

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)