[R] Calculating the mean in one column with empty cells

[John Kane]

Where is the csv data coming from?  If it is an export from a spreadsheet, Excel (and others?) has a nasty habit of exporting "as displayed" rather than the actual number as it's default.  

John Kane
Kingston ON Canada


> -----Original Message-----
> From: f.sehardt at gmail.com
> Sent: Sat, 6 Oct 2012 01:11:11 -0700 (PDT)
> To: r-help at r-project.org
> Subject: Re: [R] Calculating the mean in one column with empty cells
> 
> Hi,
> 
> the first command was bringing the numbers into R directly:
> *> testdata <- c(0.2006160108532920, 0.1321167173880490,
> 0.0563941428921262,
> 0.0264198664609803, 0.0200581303857603, -0.2971754213679500,
> -0.2353086361784190, 0.0667195538296534, 0.1755852636926560)
>> mean(testdata)
> [1] 0.0161584*
> 
> Here I tried to calculate the mean with the same numbers as given above,
> but
> taken from my dataset.
> *
>> str(dataSet2$ac_bhar_60d_4d_after_ann[1:9])
>  num [1:9] 0.2 0.13 0.06 0.03 0.02 -0.3 -0.24 0.07 0.18
>> mean(dataSet2$ac_bhar_60d_4d_after_ann[1:9])
> [1] 0.01666667
> *
> 
> It seems that in the second case he calculates the mean with rounded
> numbers
> (0.2 and not 0.20061601085...)
> Could it be that R imports only the rounded numbers?
> How can I build a CSV-file with numbers showing all decimal places?
> Because
> I think my current CSV-file only has numbers with 2 decimal places.
> 
> 
> Kind Regards,
> Felix
> 
> 
> 
> 
> --
> View this message in context:
> http://r.789695.n4.nabble.com/Calculating-the-mean-in-one-column-with-empty-cells-tp4645135p4645252.html
> Sent from the R help mailing list archive at Nabble.com.
> 
> ______________________________________________
> R-help at 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.

____________________________________________________________
FREE 3D MARINE AQUARIUM SCREENSAVER - Watch dolphins, sharks & orcas on your desktop!