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 <jdnew...@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:<jdnew...@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 <barrylamb...@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]] ______________________________________________ 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.