Excellent website full of useful information on using R Project:
Getting data from the web
This is probably my favorite project on his site – not because it’s Star Wars, but because of the way the data is presented:
Great website that give basic instructions on using R Project: statmethods.net
I have a pivot table with Routes going down and years going across, but I need to normalize it – have a column for the route and a column for the year and then a value for each route, column.
Oracle and MS SQL databases have a function called UNPIVOT.
MySQL does not have a similar function yet, so you have to do a SELECT, UNION ALL type command.
In R Project, the function is called “Melt”
Doing this in R Project:
1. Install the reshape library if you don’t have it.
2. Program looks like so:
Line 1 runs the reshape library
Line 2 reads the data in
Line 3 "Melts" the data
Line 4 Shows the output
Link to a blog that shows how to perform a function in SAS and also in R. Looks like a really good reference.