Hi,
Attached is a snipping of an excel workbook showing 30 rows and 11 columns of data. The other cells contain the formula used to produce a linear discriminant analysis from the data.
The full data contains 11 columns (group, ch.1,ch.2,ch.3,ch.4,ch.5,ch.11,ch.12,ch.13,ch.14,ch.15) and 82090 rows (numbered in frames). what I need to do is separate the 82090 frames into 92 frame epochs (82090/92=892). This gives 892 epochs of 92 rows and 11 column data sets.
What I need to do in R studio is to separate the data from 82090 rows and 11 columns into 892 lots of 92 rows x 2 columns (Group and Ch.1). For example epoch 1 of 892 would be 2 columns (Group, ch.1) and rows 1-92, group, ch.2 and rows 1-92, group, ch.3 and rows 1-92, group, ch.4 row 1-92, group, ch.5 row 1-92, group,ch.11 row1-92, group, ch.12 row 1-92, group,ch.13 row 1-92, group, ch.14 row 1-92, group, ch.15 row 1-92. So just for epoch 1 there is 10 data sets of 2 columns and 92 rows and an LDA analysis needs to be done on each of the 10 data sets for epoch 1 then the same for the other 891 epochs. I could do this on excel but it would take me ages (each LDA takes about 15 mins and there is 8920 of them).