1265 search results for "excel"

Combining ggplot Images

July 3, 2012
By
Combining ggplot Images

The ggplot2 package provides an excellent platform for data visualization. One (minor) drawback of this package is that combining ggplot images into one plot, like the par() function does for regular plots, is not a straightforward procedure. Fortunately, R user Stephen Turner has kindly provided a function called “arrange” that does exactly this. The function,

Read more »

Graphics Artifacts from Quarterly Commentary

July 2, 2012
By
Graphics Artifacts from Quarterly Commentary

For my Q2 2012 commentary, I tried multiple graphs to illustrate the disconnect of the US stock markets with the rest of the world.  I think I finally settled on this simple Excel bar graph populated by Bloomberg data, but I thought some might lik...

Read more »

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

Read more »

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 »