1330 search results for "excel"

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 »

Data Visualization: From Excel to ???

April 26, 2013
By
Data Visualization: From Excel to ???

So you’re an excel wizard, you make the best graphs and charts Microsoft’s classic product has to offer, and you expertly integrate them into your business operations.  Lately you’ve studied up on all the latest uses for data visualization and … Continue reading →The post Data Visualization: From Excel to ??? appeared first on Data Community...

Read more »

More reasons not to use Excel for modeling

April 17, 2013
By
More reasons not to use Excel for modeling

As if the London Whale nearly bankrupting Chase Bank wasn't lesson enough, we now hear that an Excel error impacted the conclusions of a major economics paper that influenced the recent austerity policies in the US, UK and elsewhere. Matt Frost says enough is enough, and implores to everyone to stop using error-prone point-and-click tools, and instead use a...

Read more »

Spring Cleaning Data: 1of 6- Downloading the Data & Opening Excel Files

April 8, 2013
By

With spring in the air, I thought it would be fun to do a series on (spring) cleaning data. The posts will follow my efforts to to download the data, import into R, cleaned it up, merge the different files, add columns of information created, and then ...

Read more »

Rationality, and MS Excel (and other calculators)

March 27, 2013
By
Rationality, and MS Excel (and other calculators)

This morning, Mathieu had a nice experience in his course on computational method in actuarial science. But let us start with some mathematical formal definitions. First, recall that is – somehow – a standard expression. No one should be surprised to see such an expression. Generally (as explained in http://en.wikipedia.org/… ), this function is defined only when . The...

Read more »

Copying Data from Excel to R and Back

February 24, 2013
By
Copying Data from Excel to R and Back

A lot of times we are given a data set in Excel format and we want to run a quick analysis using R's functionality to look at advanced statistics or make better visualizations. There are packages for importing/exporting data from/to Excel, but I have f...

Read more »

Copying Data from Excel to R and Back

February 23, 2013
By
Copying Data from Excel to R and Back

A lot of times we are given a data set in Excel format and we want to run a quick analysis using R's functionality to look at advanced statistics or make better visualizations. There are packages for importing/exporting data from/to Excel, but I have found them to be hard to work with or only work with old versions of...

Read more »

Some of Excel’s Finance Functions in R

February 16, 2013
By

Last year I took a free online class on finance by Gautam Kaul. I recommend it, although there are other classes I can not compare it to. The instructor took great efforts in motivating the concepts, structuring the material, and enable critical thinking / intuition. I believe this is an advantage of video...

Read more »