Hi Kreil,
Sorry for the bad format...
Let me know if the attachments work...
Here is what my data means in real life:
Input matrix
Rows are individual observations
Col 1 = transect number
Col 2= species code
Col 3= count of animals of corresponding species
Col 4= % ice cover for that specific...
(hope) these are nicer matrices:
Input:
1 NaN NaN 20
1 2 4 10
1 2 3 15
1 NaN NaN 10
1 5 2 25
1 6 1 10
1 2 5 5
2 NaN NaN 5
2 1 3 10
2 1 2 25
3 6 5 15
3 4 3 10
3 3 1 30
desired output:
1 2 3 4 5 6 mean
1 NaN 12 NaN NaN 2 1 13.57
2 5 NaN NaN NaN NaN NaN 13.33
3 NaN NaN 1 3 NaN 5 18.33
Hi all,
I need to rearrange my data. I have an excel file with 12 columns and 2045 rows, which I transformed that into a .mat.
I need to query my data rearranged as follows (cf. example matrix below):
1-sum all values of Col 3 if:
a-they belong to a given value of Col 1 and to a...