niccw
3/6/2019 - 3:14 PM

R_df

Dataframe

A list of dataframe

dfls <- ls(pattern = "res*")
dls <- list()

# List of dataframe
for (i in seq_along(dfls)){
  dls[[i]] <- get(dfls[i])
}

# rbind
do.call(rbind,dls)
# or by dplyr
bind_row(dls)

Stop using factor in dataframe

stringsAsFactors = FALSE

as.data.frame(do.call(rbind,tcntls),stringsAsFactors=FALSE)

Using subset to drop column

Quick-R: Subsetting Data

subset(df,select=-c("A"))

wide -> long form (by reshape2/tidyr)

Converting data between wide and long format

tcnpdf_l <- melt(tcnpdf,id=c("stage","DE"),variable.name = "species",value.name = "percentage")
gather(olddata_wide, condition, measurement, control, cond1, cond2)

long -> wide form (by tidyr)

r - How to reshape data from long to wide format? - Stack Overflow

library(tidyr)
spread(fulldf,key="stage",value="0")

Expand frequency table

Expanding data from a frequency table into case form in R and STATA

require(vcdExtra)
CaseForm <- expand.dft(FrequencyTable, freq=”Frequency”)