Subscribe to Vincent Granville's Weekly Digest:

What do you think about RExcel?

RExcel is an addin for Microsoft Excel. It allows access to the statistics package R from within Excel.

The main features are:

  • Data transfer (matrices and data frames) between R and Excel in both directions
  • Running R code directly from Excel ranges
  • Writing macros calling R to perform calculations without exposing R to the user
  • Calling R functions directly from cell formulas, using Excel's autoupdate mechanism to trigger recalculation by R
  • Using Excel as a GUI for R, making R functionality accessible through menus and dialog boxes instead of a command line oriented programming style. Using this paradigm, the widely used GUI package R Commander is available as an Excel menu bar.
  • Installed using the package RExcelInstaller from CRAN

RExcel only works on Microsoft Windows (XP, Vista or 7) and with Excel 2003, 2007, 2010, but only in the 32-bit version. It uses the statconnDCOM (available from the same site as RExcel) server and for certain configurations additionally the rcom package (available from CRAN) to access R from within Excel.

(extract from Wikipedia)

Views: 961

▶ Reply to This

Replies to This Discussion

Permalink Reply by Ralph Winters on October 23, 2012 at 8:45pm

I had problems with data being imported correctly directly from Excel, so I gave up on using it.  Now, I try to stick to csv files for import. 

-Ralph Winters

Permalink Reply by Miles Garnsey on November 3, 2012 at 9:34pm

I have concerns about the reliability factor, also, in the age of big data, I feel that you need a solution which scales better.

Power pivoting data from a server through excel and analysing it using R syntax but with the script run on the server would be a more powerful model, but I don't know of a solution that does this.

Permalink Reply by Ravirajan.K on December 5, 2012 at 8:59pm

I have a single txt file contains 8 million records, can I import into R and perform analysis? If it possible please share the procedure/protocol.

 

Thanks,

Ravi

RSS

Top Content 

1 Map of Data Science University Programs

Map of Data Science University Programs
2 Use PRESS, not R squared to judge predictive power of regression

Use PRESS, not R squared to judge predictive power of regression
3 Text mining: alternative to Wordflex?

Text mining: alternative to Wordflex?
4 Audience expansion

Audience expansion
5 How to develop churn prediction model for telecom company?

How to develop churn prediction model for telecom company?
6 Strategy for building a “good” predictive model

Strategy for building a “good” predictive model
7 The End of Theory: The Data Deluge Makes the Scientific Method Obsolete | Wired

The End of Theory: The Data Deluge Makes the Scientific Method Obsolete | Wired
8 Identifying the number of clusters: finally a solution

Identifying the number of clusters: finally a solution
9 Can we automate data mining?

Can we automate data mining?
10 The application of Propensity Score Matching

The application of Propensity Score Matching

Follow us

Big Data Jobs

Decision Scientists- Decision Sciences

Data Scientist - Electronic Arts

Data Analyst, Senior - Microsoft

Software Engineer - Cloud Computing Platform - VMware

Data Analyst - Corporate Analytics - Visa

Sr. Analyst, HR Analytics - Yahoo

Data Scientist - Facebook

Data Scientist - Spencer Reed Group, LLC

Lead Business Analyst - Google

Machine Learning Analyst - AxDx

© 2013   AnalyticBridge.com is a subsidiary and dedicated channel of Data Science Central LLC

Badges  |  Report an Issue  |  Terms of Service