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.seha...@gmail.com > Sent: Sat, 6 Oct 2012 01:11:11 -0700 (PDT) > To: r-help@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@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! ______________________________________________ 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.