https://cran.r-project.org/doc/manuals/R-intro.pdf
Case sensitive
Database connectivity
http://www.ibm.com/developerworks/data/library/techarticle/dm-1402db2andr/
Install packages on locked down installation:
.libPaths(c(“C:\\Users\\lross\\R\\library”, .libPaths()))
Manually unzip required packages into above path, then you can use as normal
e.g. library(openxlsx)
alternate: library(ggplot2, lib.loc=”/data/Rpackages/”)
Unload package:
detach(package:openxlsx)
Clear workspace (Default action at start of a file?)
rm(list=ls())
Merging Data
Adding Columns
To merge two data frames (datasets) horizontally, use the merge function. In most cases, you join two data frames by one or more common key variables (i.e., an inner join).
# merge two data frames by ID
total <- merge(data frameA,data frameB,by=”ID”)
# merge two data frames by ID and Country
total <- merge(data frameA,data frameB,by=c(“ID”,”Country”))
Add column to Data Frame
Add column to dataframe, combined with vector (row) operation
mtcars1 <- mtcars mtcars1$x <- mtcars1$gear * mtcars1$carb mtcars1
xx