1302 search results for "excel"

Excel spreadsheets are hard to get right

November 18, 2014
By
Excel spreadsheets are hard to get right

Any practicing data scientist is going to eventually have to work with a data stored in a Microsoft Excel spreadsheet. A lot of analysts use this format, so if you work with others you are going to run into it. We have already written how we Related posts: Please stop using...

Read more »

First steps with ChainLadder: Import triangle from Excel into R

November 18, 2014
By
First steps with ChainLadder: Import triangle from Excel into R

Taking the first step is often the hardest: getting data from Excel into R. Suppose you would like to use the ChainLadder package to forecast future claims payments for a run-off triangle that you have stored in Excel. How do you get the triangle into R and execute a reserving function, such as MackChainLadder?Well, there are...

Read more »

Excel (and French people) are such a pain in the…

November 6, 2014
By
Excel (and French people) are such a pain in the…

A few days ago, I published a post entitled extracting datasets from excel files in a zipped folder, because I wanted to use datasets that were online, in some (zipped) excel format. The first difficult part was the folder with a non-standard character (the French é). Because next week I should be using those dataset in a crash course...

Read more »

Extracting datasets from excel files in a zipped folder

October 30, 2014
By
Extracting datasets from excel files in a zipped folder

The title of the post is a bit long, but that’s the problem I was facing this morning: importing dataset from files, online. I mean, it was not a “problem” (since I can always download, and extract manually the files), more a challenge (I should be able to do it in R, directly). The files are located on ressources-actuarielles.net, in a...

Read more »

14 Reasons Why R is better than Excel

October 10, 2014
By

The Fantasy Football Analytics blog shares these 14 reasons why R is better than Excel for data analysis: More powerful data manipulation capabilities Easier automation Faster computation It reads any type of data Easier project organization It supports larger data sets Reproducibility (important for detecting errors) Easier to find and fix errors It's free It's open source Advanced Statistics...

Read more »

R meets Excel- R Training Oct. 2014

September 22, 2014
By

(This article was first published on Rmetrics blogs, and kindly contributed to R-bloggers) To leave a comment for the author, please follow the link and comment on his blog: Rmetrics blogs. R-bloggers.com offers daily e-mail updates about R news and tutorials on topics such as: visualization (ggplot2, Boxplots, maps, animation), programming (RStudio, Sweave, LaTeX, SQL, Eclipse, git, hadoop, Web...

Read more »

Quickly export multiple R objects to an Excel Workbook

June 19, 2014
By
Quickly export multiple R objects to an Excel Workbook

Working with a business audience, I am frequently called upon to send analytic results to clients in the form of Excel Workbooks. The xlsx package facilitates exporting tables and datasets Excel, but I wanted a very simple function that would let me … Continue reading →

Read more »

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 »

Importing an Excel Workbook into R

June 4, 2014
By
Importing an Excel Workbook into R

usually import Excel data in CVS format A new package in CRAN facilitates reading in entire Excel workbook and selecting worksheets and cells from there. example.... require(XLConnect)# Load Excel workbook into memorywb # Convert a sheet to a data frame df sheet = "SGI-NUMA", startRow = 3, endRow =...

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 »