1240 search results for "Excel"

R Beginner’s Guide Book Update: Statistical Analysis with R Released

November 8, 2010
By
R Beginner’s Guide Book Update: Statistical Analysis with R Released

In the final days of October, my beginner's guide to R was released. The book's official title is Statistical Analysis with R and it can be found on the Packt Publishing website. The primary focus of Statistical Analysis with R is helping new users bec...

Read more »

Dress your R code for the Web with Pretty R

November 4, 2010
By
Dress your R code for the Web with Pretty R

If you have some R code to include in a document, especially a Web-based document like a blog post, the new "Pretty R" feature on inside-R.org can help you make it look its best. Given some raw R code, it will create a HTML version of the code, adding syntax highlighting elements and links. Functions, strings, comments and literals...

Read more »

How to buy a used car with R (part 1)

October 31, 2010
By
How to buy a used car with R (part 1)

I’m in the process of buying a used car. Since I enjoy making these decisions as complicated as possible, I’ve written some R code to scrape relevant websites for informative data. I’ve written this up as a blog entry because I think it’s a decent example of how one might use the XML...

Read more »

How to buy a used car with R (part 1)

October 31, 2010
By
How to buy a used car with R (part 1)

nStrict Standards: Non-static method StringParser_Node::destroyNode() should not be called statically, assuming $this from incompatible context in /afs/ir.stanford.edu/users/k/n/knoepfle/cgi-bin/flatpress/fp-plugins/bbcode/inc/stringparser.class.php on line 358I’m in the process of buying a used car. Since I enjoy making these decisions as complicated as possible, I’ve written some R code to scrape relevant websites for informative data. I’ve written this up as a...

Read more »

Bayesian Model Averaging (BMA) with uncertain Spatial Effects

October 27, 2010
By
Bayesian Model Averaging (BMA) with uncertain Spatial Effects

This file illustrates the computer code to use spatial filtering in the context of Bayesian Model Averaging (BMA). For more details and in case you use the code please cite Crespo Cuaresma and Feldkircher (2010). In addition, this tutorial exists as ...

Read more »

Handling Large Datasets in R

Handling large dataset in R, especially CSV data, was briefly discussed before at Excellent free CSV splitter and Handling Large CSV Files in R. My file at that time was around 2GB with 30 million number of rows and 8 columns. Recently I started to collect and analyze US corporate bonds tick data from year...

Read more »

Grabbing Tables in Webpages Using the XML Package

October 24, 2010
By

ables are pretty common in web pages as data sources, and the most direct way to get these data is probably to copy and paste. This is OK if there are only two or three tables, and when we need to grab 5000 tables in 1000 web pages, we may not really wish to fulfill

Read more »

vecLib: Why Mac users are better off with Open Source R

October 21, 2010
By
vecLib: Why Mac users are better off with Open Source R

Thanks to its use of Apple's vecLib for BLAS, LAPACK and related functions, the open source distribution of R performs many matrix calculations 2-10X faster than Revolution Analytics Community edition on Mac OS X systems.

Read more »

Trading secrets

October 20, 2010
By
Trading secrets

Recently I had the opportunity to do a job swap with one of the guys in the laboratory here at HSL.  I helped out with the mass-spectrometry and James helped me with the data analysis.  Two very useful things came out of this. Firstly, it’s been very informative to see how the data I get

Read more »

Monitoring Productivity Experiment

October 20, 2010
By
Monitoring Productivity Experiment

For over a year now, i've been collecting how much time i spend in computer and how much of it is actually used in creative/productive activities. By productive activity i mean that the time spent in text editor(emacs), terminal, excel or a datab...

Read more »