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
Why an R Tutorial on Reading and Importing Excel Files into R is necessary As most of you know, Excel is a spreadsheet application developed by Microsoft. It is an easy accessible tool for organizing, analyzing and storing data in tables and has a widespread use in many different application fields all over the world.
I had the great pleasure of speaking to the Department of Statistics and Actuarial Science at Simon Fraser University on last Friday to share my career advice with its students and professors. I emphasized the importance of learning skills in data manipulation during my presentation, and I want to supplement my presentation by posting some
If you currently use a spreadsheet like Microsoft Excel for data analysis, you might be interested in taking a look at this tutorial on how to transition from Excel to R by Tony Ojeda. The tutorial explains how to use R functions in place of Excel formulas, including tools like =AVERAGE and =VLOOKUP. For the most part, it uses...
Without no doubts, a researcher should several nice tools to handle their data, and testify their results. EXCEL, SPSS, and R represent different stages for doing a research.1. EXCELMost data retrieved from a database has a excel format like xls or xlsx. We probably spend lots time on cleaning missing values and doing some simple valuable transformations with EXCEL.2.