[R] Help with tables in R
jim at bitwrit.com.au
Thu Jul 3 12:16:54 CEST 2014
On Wed, 2 Jul 2014 09:33:12 PM Barry Lambert wrote:
> I am a new convert to R (from SAS). I am a research scientist and
> 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
> for a university.
> The spreadsheet has a row for every student registered at the
> each term since fall 2010 with the following information about each
> in columns:
> Columns are the following: Term, College, Program, Campus,
> Ethnicity, Age.
> I have created summary tables in Excel using if/then type formulas
> data and count the number of female students in program A at
> I have written some R code to create some figures that generally
> I would like to find a way to have R populate some tables with this
> An example of my excel sheets are attached.
> Any suggestions will be appreciated.
If I understand the above properly, you are calculating counts of
female students in different programs and locations. I would do this
using the "by" function with "length" as the function called for each
group defined by program and location. This will produce an array of
counts, and your problem is then to add a table of values to the plot.
Here is an example:
More information about the R-help