[R] Extracting arithmetic mean for specific values from multiple .txt-files
jim holtman
jholtman at gmail.com
Mon Jul 9 01:35:07 CEST 2012
Since you did not provide an example of the file, I will take a guess
at the content and show to to extract the values and take the mean of
all of them since you did not say if you want the mean of each file,
or a single means.
myData <- do.call(c, lapply(1:65, function(.file){
x <- read.csv(paste0("XYZ_", .file, ".txt"))
x[15:166, 'colH']
})))
mean(myData)
On Sun, Jul 8, 2012 at 7:01 PM, vimmster <superdodge at gmx.net> wrote:
> Hello,
>
> I'm coming straight to the point:
>
> I have 65 .txt-Files named "XYZ_1.txt" to "XYZ_65.txt" (each number
> represents a test subject).
>
> I have to open them in Microsoft Excel to see the exact structure.
>
> In each of those .txt-files there are reaction time values (in milliseconds)
> from line 15, column H to line 166, column H for each test subject (and a
> couple of other data in the other colums of course).
>
> My problem is, that I only need the arithmetic mean for all of these
> reaction times per test subject.
>
> --> Again: I have 65 test subjects and according to Excel 152 reaction times
> for each test subject / in each .txt-file.
>
> Is there an easy way to only extract the arithmetic mean for each test
> subject in an Excel file column?
>
> Thanks for your answers!
>
> --
> View this message in context: http://r.789695.n4.nabble.com/Extracting-arithmetic-mean-for-specific-values-from-multiple-txt-files-tp4635809.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.
--
Jim Holtman
Data Munger Guru
What is the problem that you are trying to solve?
Tell me what you want to do, not how you want to do it.
More information about the R-help
mailing list