1262 search results for "excel"

Step up your R capabilities with new tools for increased productivity

July 1, 2012
By
Step up your R capabilities with new tools for increased productivity

I guess a lot of us actually use many tools to accomplish various things in their everyday life. There is the (not that uncommon) case where you have to build something that others will use in their everyday business life to get insights, information and/or take decisions. The basic implementation scenario here would be to build an excel workbook where

Read more »

Preparing Spectrum to import into "ChemoSpec"

June 28, 2012
By
Preparing Spectrum to import into "ChemoSpec"

In this video I show I to prepare a spectrum to import later into ChemoSpec:The software I use gives the option to export the spectrum as a TXT file.This file is open with Excel and saved as CSV, to import later with others into ChemoSpec.

Read more »

Making Reproducible Research Enjoyable

June 25, 2012
By
Making Reproducible Research Enjoyable

Note: this is a contributed article for the ICSA Bulletin and the basic idea can be summarized in this picture. It is hard to convince people to think about reproducible research (RR). There are two parts of difficulties: (1) tools used to be for ex...

Read more »

reading shape files in R

June 24, 2012
By
reading shape files in R

If I would like to adjust a shape file I normally used the way over an excel file or a text file to get a table and to join this with an existing shape file. Due to the sp and rgdal packages in R you can manipulate shapefiles directly in R: now lets map the

Read more »

Mexico City’s Metro Statistics

June 24, 2012
By
Mexico City’s Metro Statistics

I used R and ggplot2 to make a bubble map of Mexico City’s Metro passenger count from January to February 2012. The statistics are stunning, some stations for example Indios Verdes, reached 10 million passengers in jus three months. You can see the code below and get the data for the project here.The post Mexico City’s Metro Statistics...

Read more »

Framing investing as a decision-making process

June 23, 2012
By
Framing investing as a decision-making process

Brian Peterson and I had a chance to visit the University of Washington a couple of weeks ago at the behest of Doug Martin, where we gave a seminar covering various R packages we’ve written. Here are the slides we used. We also had quite a bit of time that we spent with Doug, Eric

Read more »

Two new, important books on R

June 22, 2012
By
Two new, important books on R

Two books were recently published that are sure to help R grow even faster. R has a reputation, partially deserved, for being hard to learn.  These books will help.  The first makes learning easier, the second can make learning less necessary for initiates. I have not yet touched either book. R for Dummies The authors … Continue reading...

Read more »

Solving Big Problems with Oracle R Enterprise, Part I

June 21, 2012
By
Solving Big Problems with Oracle R Enterprise, Part I

Abstract: This blog post will show how we used Oracle R Enterprise to tackle a customer’s big calculation problem across a big data set. Overview: Databases are great for managing large amounts of data in a central place with rigorous enterprise-level controls.  R is great for doing advanced computations.  Sometimes you need to...

Read more »

Body Weight in the United States – Part 3, "Contributing Factors"

June 20, 2012
By
Body Weight in the United States – Part 3, "Contributing Factors"

Carbs In Part 2 of this series, micro-nutrients were cited as a non-factor for weight gain. This is not the case with macro-nutrients (carbohydrates, fats, proteins, water). While fats, proteins and water are essential (without them you could no...

Read more »

UseR 2012 highlights

June 20, 2012
By
UseR 2012 highlights

The eighth annual R user conference, UseR! 2012, has come and gone — and what an event it was! I've been to five useR! conferences so far, and each one improves upon the last. This year's conference at Vanderbilt was the best so far: an outstanding location (my first visit to Nashville, a great city), excellent facilities (the lecture...

Read more »