1350 search results for "excel"

Tips on accessing data from various sources with R

October 3, 2012
By

Jeffrey Breen (the man behind the Twitter airline sentiment analysis example) recently posted a collection of slides with some great tips for accessing data from R. "Tapping the Data Deluge" includes information on: Using the XLConnect package to read data from Excel spreadsheets Using the foreign package to read SPSS, SAS, Stata and dBase data files Using SQL queries...

Read more »

Working with Bipartite/Affiliation Network Data in R

September 30, 2012
By
Working with Bipartite/Affiliation Network Data in R

Data can often be usefully conceptualized in terms affiliations between people (or other key data entities). It might be useful analyze common group membership, common purchasing decisions, or common patterns of behavior. This post introduces bipartite/affiliation network data and provides … Continue reading →

Read more »

Football, an ordinal model

September 30, 2012
By
Football, an ordinal model

On September 19th, flo2speak remarked under a post that his/her experience is that ordinal models had better performance. That seems reason enough to try, so there we are. In examining this type of model it is found that more complex models can be...

Read more »

Modifying select off-diagonal items in a matrix

September 25, 2012
By

This is something I have had the occasion to do, and never remember how, so this is legitimately a reminder to my future self of how to do things with off-diagonal elements of a matrix. Select rows and columns are easy: mat or mat, for...

Read more »

Transition probabilities when adjacent sequence items must be different

September 24, 2012
By

Generating a random sequence from a fixed set of items is a common requirement, e.g., given the items A, B and C we might generate the sequence BACABCCBABC. Often the randomness is tempered by requirements such as each item having each item appear a given number of times in a sequence of a given length,

Read more »

Federal Register API/R Package Ideas?

September 21, 2012
By

The other day Critical Juncture put up an API for the Federal Register. I thought it would be great if there was a package that could use this API to download data directly into R (much like the excellent WDI package). This would make it easier to anal...

Read more »

Technical Analysis of Montana Voter Registration Files

September 18, 2012
By
Technical Analysis of Montana Voter Registration Files

By Earl F Glynn | Franklin Center This article shows how to analyze Montana voter registration files using R. The Montana Secretary of State sells two files of voter registration records for a fee of $1000: Statewide Voter File Voter History File The Montana Secretary of State provides information about the two files on this

Read more »

Designing Data Apps with R at Periscopic

September 18, 2012
By
Designing Data Apps with R at Periscopic

Today's guest post comes to us from Andrew Winterman, Data Designer at data visualization company Persiscopic. He shares with us the process of using the R language and other tools to create an interactive data application for a client — ed. The Hewlett Foundation contacted us a few months ago because they were interested in exploring ways to visualize...

Read more »

Football model

September 16, 2012
By
Football model

After reading Dutch football data (Eeredivisie 2011-2012) and making a predictions display it is time to look at a few simple models to predict goals. To reiterate the data setup, each game played consists of two rows in the data frame. ...

Read more »

Getting into R, RCommander, JGR and Deducer

September 14, 2012
By

I've been meaning to post something about R for a while, but never got started, and now have a pile of things I'd like to post, so it's time to get started. I first started using R during my Master Dissertation where I had to do some stats.  I've ...

Read more »