RinAction - R Data Manipulation - Sort and Merge

gistfile1.r

#################################################
##              SORT & MERGE                   ##
#################################################

###################
#Sorting a dataset
###################
attach(leadership)
newdata <- leadership[order(age), ]
newdata
detach(leadership)
newdata

attach(leadership)
newdata <- leadership[order(gender, -age), ]
newdata
detach(leadership)
newdata

# Rank
rank(c(1,9,3,3,6,4),ties.method="average")

##########
# Merging
##########

# Merging horizontally (adding columns)
total <- merge(dataframeA, dataframeB, by="key")
total <- merge(dataframeA, dataframeB, by=c("key1","key2"))

# Merging without a common key (matrix, dataframe)
total <- cbind(A, B)


# Merging vertically (adding rows)
# two data frames must have the same variables, but not necessarily in the same order
total <- rbind(dataframA, dataframeB)