Message-ID: <064CC1D8-E45D-4DDD-BEFC-FEA41B72D713@comcast.net>
Date: 2016-04-15T00:31:29Z
From: David Winsemius
Subject: Unequal column lengths
In-Reply-To: <CB5791F5EA3D82408B277900997482D27F7D3B49@mboxes2.campus.vims.edu>
> On Apr 14, 2016, at 2:33 PM, Tom Mosca <tom at vims.edu> wrote:
>
> Hello,
>
> I?ve tried several times to learn R, but have never gotten past a particular gate. My data are organized by column in Excel, with column headers in the first row. The columns are of unequal lengths. I export them as CSV, then import the CSV file into R. I wish to summarize the data by column. R inserts NA for missing values, then refuses to operate on columns with NA. R is importing my data into a data frame, and I realize that is inappropriate for what I want to do.
>
> How can I import my data so that I can work on columns of unequal length? The first thing I would like to do is generate a table containing mean, median, mode, standard deviation, min, max and count, all per column.
>
Most of the summary statistic functions have an na.rm options that you should set to TRUE.
> Thank you, Tom
>
> Example data
> Dat1 Dat2 Dat3
> 1 1 5 4
> 2 7 7 9
> 3 3 3 5
> 4 2 NA 5
> 5 9 NA NA
Looks like you have an R dataframe already, so I would try(
colMeans(data, na.rm=TRUE)
>
> [[alternative HTML version deleted]]
And do learn to configure your email client to post to r-help in plain text.
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.
David Winsemius
Alameda, CA, USA