1419 search results for "excel"

R, Python, MATLAB, & Excel Dashboards & Graphs with D3.js & WebGL

April 29, 2015
By
R, Python, MATLAB, & Excel Dashboards & Graphs with D3.js & WebGL

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

Read more »

Get data out of excel and into R with readxl

April 15, 2015
By
excel_to_R

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

Read more »

R Tutorial on Reading and Importing Excel Files into R

April 2, 2015
By
R Tutorial on Reading and Importing Excel Files into R

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. The post

Read more »

Resources for Learning Data Manipulation in R, SAS and Microsoft Excel

Resources for Learning Data Manipulation in R, SAS and Microsoft Excel

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

Read more »

An R tutorial for Microsoft Excel users

February 16, 2015
By

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...

Read more »

Seven 3D Graphs You Can Make In Excel, Python, MATLAB, R, & LaTeX

January 15, 2015
By
Seven 3D Graphs You Can Make In Excel, Python, MATLAB, R, & LaTeX

Plotly’s interactive 3D graphs let you make graphs from (click the links for tutorials): our web app, Excel, Google Docs, Python, MATLAB, and R. Click any image below to go to the full-screen interactive version. Also, news for users with on-premise needs. Plotly On-Premise can be hosted on a private server. Contact us...

Read more »

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 »