[R] Help with tables in R
Duncan Murdoch
murdoch.duncan at gmail.com
Thu Jul 3 12:23:10 CEST 2014
On 02/07/2014, 10:33 PM, Barry Lambert wrote:
> I am a new convert to R (from SAS). I am a research scientist and most of
> my
> use of SAS was in data analysis. Recently, I have been wanting to use R to
> create a simple, reliable way to summarize a dataset of student demographics
> for a university.
> The spreadsheet has a row for every student registered at the university for
> each term since fall 2010 with the following information about each student
> in columns:
> Columns are the following: Term, College, Program, Campus, Gender,
> Ethnicity, Age.
>
> I have created summary tables in Excel using if/then type formulas to select
> data and count the number of female students in program A at location 3,
> etc.
>
> I have written some R code to create some figures that generally meet my
> needs.
> I would like to find a way to have R populate some tables with this type of
> information.
>
> An example of my excel sheets are attached.
>
The "tables" package has formulas that are like PROC TABULATE formulas
(except better :-).
Your samples would be something like
tabular( term ~ campus * college )
tabular( college * program ~ campus * term )
The second one will need some extra work to remove all the empty cells
(e.g. College 1 Program 3 will show up, even though it doesn't really
exist). See the vignette for a couple of approaches to handling this.
The package is mainly aimed at LaTeX output, but it can produce HTML, or
just put the numbers in a CSV file for pasting into some spreadsheet for
manual formatting.
Duncan
More information about the R-help
mailing list