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

From: <ukoenig_at_med.uni-marburg.de>
Date: Tue, 18 Mar 2008 17:49:03 +0100

Dear all,
thank you very much for the provided support and all the hints, which were very helpful! Now I know how to continue.

>See ?pdf
>Please, note first search commands:
>apropos("pdf")
>RSiteSearch("latex")
>Using these, you would have found by yourself the various corresponding
>functions.
Philippe

Sorry Philippe, I always try to solve problems myself before contacting the list, but sometimes you get so many results, that itīs somewhat confusing for an R-novice like me. I will use apropos() and RsiteSearch() next time, thank you very much..

>I don't think the OP was using Hmisc::describe. I
>think it was psych::describe.
Yes, it was describe from lib psych.

Regards,
Udo

Quoting John Kane <jrkrideau_at_yahoo.ca>:

> I don't think the OP was using Hmisc::describe. I
> think it was psych::describe.
>
>
> --- Frank E Harrell Jr <f.harrell_at_vanderbilt.edu>
> wrote:
>
> > John Kane wrote:
> > > #How Can I create a text file with the output of
> > > "describe"?
> >
> > sink('my.txt')
> > describe( )
> > sink()
> >
> > If you use LaTeX you'll get more (and better) output
> > including tiny
> > high-resolution histograms of continuous variables.
> >
> > Frank
> >
> > >
> > > ?sink
> > > ?write.table
> > > ?write.csv

> > >
> > > #delete some variables.
> > >
> > > ?Extract
> > > df[,-(10:12)]
> > > df[, 1:9]
> > >
> > >
> > > --- ukoenig_at_med.uni-marburg.de wrote:
> > >
> > >> Dear list readers,
> > >> 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
> > >> ....
> > >>
> > >> 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?
> > >>
> > >>
> > >> Thanks a lot in advance!
> > >> Udo
> > >>
> > >> ______________________________________________
> > >> R-help_at_r-project.org mailing list
> > >> https://stat.ethz.ch/mailman/listinfo/r-help
> > >> PLEASE do read the posting guide
> > >> http://www.R-project.org/posting-guide.html
> > >> and provide commented, minimal, self-contained,
> > >> reproducible code.
> > >>
> > >
> > >
> > >
> > > [[elided Yahoo spam]]
> > >
> > > ______________________________________________
> > > R-help_at_r-project.org mailing list
> > > https://stat.ethz.ch/mailman/listinfo/r-help
> > > PLEASE do read the posting guide
> > http://www.R-project.org/posting-guide.html
> > > and provide commented, minimal, self-contained,
> > reproducible code.
> > >
> >
> >
> > --
> > Frank E Harrell Jr Professor and Chair
> > School of Medicine
> > Department of Biostatistics
> > Vanderbilt University
> >
>
>
>
> Looking for the perfect gift? Give the gift of Flickr!
>
> http://www.flickr.com/gift/
>
>



R-help_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. Received on Tue 18 Mar 2008 - 17:00:52 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Tue 18 Mar 2008 - 17:30:22 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive