Thanks for the suggestions Jeff.  I have added some text below that will
hopefully clarify my question and more closely follow the guidelines.
Barry
--

Sorry for the confusing first post. I have edited for clarity and included
some sample data.

Clarified summary of problem: I have an excel 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: Term, Campus,
College, Major, Gender, Ethnicity, Age.

My goal is to be able to generate a print ready report out of R that will
build some output quality tables for printing. I don't care if they are
PDF, HTML, etc., as long as I can print them and they are somewhat
attractive. So far, I have imported the spreadsheet into R as a CSV I have
been attempting to do this with the "GridExtra" library with some success.

I have 3 problems thus far: 1. If the count for a cell in the table is
zero, it does not appear in the table; 2. I am unable to understand how to
create more complex tables: for example a table that; 3. I am not able to
create a column and row total.

An example table is shown below:

       ------Campus S-------|---------Campus M-----|-----Campus O------
       2010    2011    2012   2010    2011    2012  2010    2011
2012   Total column

COE

    A
    B
    C

COBA

    A
    B
    C

Totals -->

Thus far my efforts have been something like this (small sample dataset):

Term <- c("Fall 2010", "Fall 2010", "Fall 2011", "Fall 2011", "Fall
2011", "Fall 2011", "Fall 2010",
          "Fall 2010", "Fall 2011", "Fall 2011", "Fall 2011", "Fall 2011")
Campus <- c("S", "M", "O", "O", "S", "S", "O", "S", "S", "O", "S", "S")
College <- c("COE", "COBA", "COBA", "COLFA", "COE", "COBA", "COBA",
"COBA", "COBA", "COBA", "COBA", "COLFA")
Major <- c("A", "B", "C", "A", "C", "C", "A", "C", "C", "A", "C", "C")
Gender <- c("M", "F", "F", "F", "F", "M", "F", "F", "M", "F", "F", "M")
Ethnicity <- c("B", "W", "W", "B", "B", "W", "B", "W", "W", "B", "W", "W")
Age <- c(25, 27, 44, 62, 23, 36, 42, 44, 55, 65, 33, 20)
mydata <- data.frame(Term, Campus, College, Major, Gender, Ethnicity, Age)
mydata

termxcamp.table <- table(mydata$Term, mydata$Campus)
termxcoll.table <- table(mydata$Term, mydata$College)

library(gridExtra)
plot.new()
grid.table(termxcamp.table)
plot.new()
grid.table(termxcoll.table)



On Thu, Jul 3, 2014 at 3:05 AM, Jeff Newmiller <jdnewmil@dcn.davis.ca.us>
wrote:

> Your question is vague. You say you have code that does what you want it
> to, yet do not share an example of it as a starting point, or explain what
> you have not been able to do. It is the nature of the Internet that you
> have to be precise in describing your problems and desired solutions.
>
> When I read "populate tables" I think of input processing, yet you say you
> already have code, suggesting that you have successfully read in your data
> to R.
>
> Since you attempted to attach Excel files to a posting, I assume you have
> not yet read the Posting Guide mentioned at the bottom of this (or any
> other email from this mailing list) since that document warns against
> attaching non-text files. Please read it. Also, we tend to "speak" in R on
> this list rather than translating from other programming dialects,
> especially proprietary ones... that is your responsibility. Sort of like
> foreign language immersion. :-)
>
> A word to the wise... it is significantly easier to read in CSV data than
> XLS or XLSX data in R. For getting started in R I highly recommend
> exporting your XLSX data to CSV.
>
> You may find [1] helpful in formulating a reproducible example to get the
> ball rolling more effectively.
>
> [1]
> http://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example
>
> ---------------------------------------------------------------------------
> Jeff Newmiller                        The     .....       .....  Go Live...
> DCN:<jdnewmil@dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live
> Go...
>                                       Live:   OO#.. Dead: OO#..  Playing
> Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
> /Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
> ---------------------------------------------------------------------------
> Sent from my phone. Please excuse my brevity.
>
> On July 2, 2014 7:33:12 PM PDT, Barry Lambert <barrylambert@gmail.com>
> 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.
> >
> >
> >Any suggestions will be appreciated.
> >
> >
> >------------------------------------------------------------------------
> >
> >______________________________________________
> >R-help@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.
>
>


-- 
--
Barry Lambert
Mobile/Text: 254-485-5328

	[[alternative HTML version deleted]]

