table.df: TABLE DATAFRAME

In TPeschel/hlpr4life: HELPER FOR LIFE

Description

table.df returns data about missings, availables of every column in a given dataframe. If summary is TRUE, min, max, median and mean are shown additionally.

Usage

table.df(data, horizontal = T, summary = F, na.rm = T, sort.by = "NO")

Arguments

data	A dataframe which columns should be summarised.
horizontal	logical: The result is shown in horizontal or vertical style. Default is TRUE.
summary	logical: If summary is TRUE additionally min, median, mean and max are tabled. Default is FALSE.
na.rm	logical: If na.rm is TRUE missings are ignored. Default is FALSE.
sort.by	character: If sort.by is NAMES, then it is sorted by column names of the table. One can also sort by the rownames as MISSING or MEAN if summary is TRUE. Default is "NO"

Value

A dataframe containing sum of missing and available data and if summary is TRUE mins and maxs, means and medians of every column of a given datframe.

Examples

table.df(data.frame(x=c(1:3),y=c(NA,1,NA),z=c(NA,NA,NA),n=c("blonde","brown","black")))
table.df(data.frame(x=c(1:3),y=c(NA,1,NA),z=c(NA,NA,NA),n=c("blonde","brown","black")),F,F,F,"NO")
table.df(data.frame(x=c(1:3),y=c(NA,1,NA),z=c(NA,NA,NA),n=c("blonde","brown","black")),F,T,F,"MISSING")
table.df(data.frame(x=c(1:3),y=c(NA,1,NA),z=c(NA,NA,NA),n=c("blonde","brown","black")),T,F,F,"AVAILABLE")
table.df(data.frame(x=c(1:3),y=c(NA,1,NA),z=c(NA,NA,NA),n=c("blonde","brown","black")),T,T,F,"NAMES")
table.df(data.frame(x=c(1:3),y=c(NA,1,NA),z=c(NA,NA,NA),n=c("blonde","brown","black")),F,F,T,"MIN")
table.df(data.frame(x=c(1:3),y=c(NA,1,NA),z=c(NA,NA,NA),n=c("blonde","brown","black")),T,T,T,"MAX")
table.df(data.frame(x=c(1:3),y=c(NA,1,NA),z=c(NA,NA,NA),n=c("blonde","brown","black")),T,T,T,"MEAN")
table.df(data.frame(x=c(1:3),y=c(NA,1,NA),z=c(NA,NA,NA),n=c("blonde","brown","black")),F,T,T,"MEDIAN")

TPeschel/hlpr4life documentation built on May 9, 2019, 2:25 p.m.