1234 search results for "Excel"

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 »

Winners of 2010 ggplot2 case study competition

October 18, 2010
By
Winners of 2010 ggplot2 case study competition

The winners of this year's ggplot2 case study competition have been announced. I was honoured to be asked to be a judge of the competition this year, but it was a difficult job with so many excellent entries. In the end, the judging panel (which included Heike Hoffman and Hadley Wickham and me) selected three entries which each demonstrated...

Read more »

American TV does cointegration

October 18, 2010
By
American TV does cointegration

Fringe provides an excellent example of cointegration.  This is a television show in which there are two adjacent universes.  The universes are almost alike but not exactly. Now, everyone knows that history is chaotic.  If a butterfly does an extra flap of its wings, then that difference spreads out to change subsequent events everywhere.  But … Continue reading...

Read more »

Generating graphs of retweets and @-messages on Twitter using R and Gephi

October 17, 2010
By
Generating graphs of retweets and @-messages on Twitter using R and Gephi

After recently discovering the excellent methods section on mappingonlinepublics.net, I decided it was time to document my own approach to Twitter data. I’ve been messing around with R and igraph for a while, but it wasn’t until I discovered Gephi that things really moved forward. R/igraph are great for preprocessing the data (not sure how

Read more »

Prediction with Multilevel Regression Models, and Pizza

October 15, 2010
By

The Meetup phenomenon, which is now substantial and longstanding enough to be more of a cultural change than a flash in the pan, continues to impress me. Even more so than tools like LinkedIn, Meetups have changed the nature of professional networking, making it more informal, diverse, and decentralized. Last night, statistics consultant (and cheap

Read more »

R Tutorial Series: One-Way Omnibus ANOVA

October 11, 2010
By
R Tutorial Series: One-Way Omnibus ANOVA

Testing the omnibus hypothesis via one-way ANOVA is simple process in R. This tutorial will explore how R can be used to perform a one-way ANOVA to test the difference between two (or more) group means. Tutorial FilesBefore we begin, you may want to do...

Read more »

R Tutorial Series: One-Way Omnibus ANOVA

October 11, 2010
By
R Tutorial Series: One-Way Omnibus ANOVA

Testing the omnibus hypothesis via one-way ANOVA is simple process in R. This tutorial will explore how R can be used to perform a one-way ANOVA to test the difference between two (or more) group means. Tutorial FilesBefore we begin, you may want to do...

Read more »