Created
May 14, 2012 18:52
-
-
Save andrewheiss/2695674 to your computer and use it in GitHub Desktop.
Dataframe Summary
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DataframeSummary <- function(x) { | |
if (class(x) != "data.frame") | |
stop("must supply a dataframe") | |
#------------------------------------- | |
# Continuous, numeric data summaries | |
x.continuous <- x[ , sapply(x, is.numeric)] | |
if (ncol(x.continuous) > 0) { | |
x.min <- apply(x.continuous, 2, min, na.rm=TRUE) | |
x.max <- apply(x.continuous, 2, max, na.rm=TRUE) | |
x.sd <- apply(x.continuous, 2, sd, na.rm=TRUE) | |
x.mean <- as.numeric(lapply(x.continuous, mean, na.rm=TRUE)) | |
x.n <- apply(!is.na(x.continuous), 2, sum) | |
x.na <- apply(is.na(x.continuous), 2, sum) | |
row.names <- colnames(x.continuous) | |
# Build output dataframe | |
results.continuous <- data.frame(x.mean, x.sd, x.min, x.max, x.n, x.na) | |
colnames(results.continuous) <- c("Mean", "Std Dev", "Min", "Max", "N", "NAs") | |
rownames(results.continuous) <- row.names | |
# Print the results | |
writeLines("Summary of continuous variables") | |
writeLines("-------------------------------") | |
print(results.continuous) | |
} | |
#------------------------ | |
# Categorical summaries | |
x.factors <- x[ , sapply(x, is.factor)] | |
if (ncol(x.factors) > 0) { | |
x.counts <- apply(x.factors, 2, summary.factor) | |
lprint <- function(lst) { | |
for (i in 1:length(lst)) { | |
cat(names(lst[i]), "\n") | |
print(lst[[i]]) | |
cat("\n") | |
} | |
} | |
if (ncol(x.continuous) > 0) | |
writeLines("\n") | |
writeLines("Summary of categorical variables") | |
writeLines("(first row = categories; second row = counts)") | |
writeLines("---------------------------------------------") | |
lprint(x.counts) | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment