A few months ago a reader point me out this new way of connecting R and Excel. I don’t know for how long this has been around, but I never came across it and I’ve never seen any blog post or article about it. So I decided to write a post as the tool is really
by Joseph Rickert In a post late last year, my colleague and fellow blogger, Andrie de Vries described enhancements to the AzureML R package that makes it easy to publish R functions that consume data frames as Azure Web Services. A very nice consequence is that it is now feasible to develop predictive models in R and enable the...
XLConnect allows to create a formatted spreadsheet usable as a dynamic report of the R analysis. Discover how to link R and Excel with just a few steps
The post Few steps to connect R with Excel: XLConnect! appeared first on MilanoR.
Here is a video I made showing how R should not be considered “scarier” than Excel to analysts. One of the takeaway points: it is easier to email R procedures than Excel procedures. Win-Vector’s John Mount shows a simple analysis both in Excel and in R.
by Yanchang Zhao RDataMining.com I attended the KDD 2015 conference in Sydney last week. At the conference, there were more than 10 tutorials and I went to two of them, which are 1) Graph-Based User Behavior Modeling: From Prediction to … Continue reading →
Showing a third dimension on a flat computer screen is usually hard. Plotly’s interactive 3D graphing changes that. You can zoom, toggle, pan, rotate, spin, see data on the hover, and more. In this post we’ll make 3D graphs with our APIs fo...
By Andy Nicholls, Head of Consulting As companies increasingly look beyond the scope of what is logistically possible in Excel more and more companies are approaching Mango looking for help with connecting to Excel from R. With over 6,500 packages … Continue reading →
Web tools like D3.js and WebGL let you make beautiful, interactive 2D and 3D graphs. You can now publish graphs and dashboards with these technologies using Python, R, MATLAB, & Excel. Publishing and sharing is one extra line of code. This post puts you on your way, no downloads or installations required. We’ll start with ggplot2; scroll to see Python and MATLAB plots in 2D and 3D. See our
I’m pleased to announced that the first version of readxl is now available on CRAN. Readxl makes it easy to get tabular data out of excel. It: Supports both the legacy .xls format and the modern xml-based .xlsx format. .xls support is made possible the with libxls C library, which abstracts away many of the