# Re: [R] Table of basic descriptive statistics like SPSS

From: William Revelle <lists_at_revelle.net>
Date: Tue, 18 Mar 2008 06:02:43 -0500

At 7:05 PM +0100 3/17/08, ukoenig_at_med.uni-marburg.de wrote:
>I want to:
>
>1. Get a table of basic descriptive statistics for my variables
>with the variable names one below the other
>like SPSS descriptive statistics:
>
>Varname N Min Max Mean SD
>xxxx x x x x x
>xxx x x x x x
>....

Udo,

To limit the number of columns of describe, set skew=FALSE

to delete variables from the description, do so in the call to describe

e.g.,
df <- as.data.frame(matrix( rnorm(1000), ncol=100)) describe(df[c(1:10,20:30)],skew=FALSE)
describe(df[-c(10:98)],range=FALSE,skew=FALSE)

to print the output into LaTeX, look at the the Sweave package.

Bill

>2. Delete some variables from a data frame or exclude variables
>from beeing analyzed.
>
>3. Create a text file / redirect the terminal output to a
>file (it is supposed to be easy, but I could not find a solution)?
>
>4. Create a latex/dvi file
>
>5. Create a PDF file (can that be done within R?)
>
>This code took me some ours (I am new to R). What do you think about
>my solution? Are there easier ones? Comments welcome! Sorry if
>my questions look very basic and I hope they are understandable.
>
>
>#here is my code
>setwd("c:\\temp") #set working directory
>
>library(psych)
>library(xtable)
>library(tools)
>
>#Create example data frame with many variables
>df <- as.data.frame(matrix( rnorm(1000), ncol=100))
>
>df <- describe(df) #describe from lib psych
>
>#How Can I create a text file with the output of "describe"?
>#The "save as" function from the GUI saves
>#only last part of the output to a text file (the first part is cut)
>
>
>#delete some variables. Or can I exclude variables from
>#beeing analyzed by "describe" to reduce the numer of cols?
>df$kurtosis <- df$skew <- df\$se <- NULL
>
>x.df <- xtable(df) #Create an xtable object
>print(x.df, tabular.environment = "longtable", , floating = FALSE,
> file="c:\\temp\\descript.tex") #create latex file
>
># produce dvi file in working directory (from tools)
>texi2dvi("c:\\temp\\descript.tex") #the lines below have to be added
>
>#Problem: these lines have to be added "manually" to the latex
>#before calling "texi2dvi":
>
>#\documentclass{article}
>#\usepackage{longtable}
># Latex code
>#\end{document
>
>
>#Can I prodcuce a PDF file within R?
>
>
>Udo
>
>______________________________________________
>R-help_at_r-project.org mailing list
>https://stat.ethz.ch/mailman/listinfo/r-help
>and provide commented, minimal, self-contained, reproducible code.

--
William Revelle		http://personality-project.org/revelle.html
Professor			http://personality-project.org/personality.html
Department of Psychology             http://www.wcas.northwestern.edu/psych/
Northwestern University	http://www.northwestern.edu/
Use R for statistics:                          http://personality-project.org/r

______________________________________________
R-help_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help