Creating a struct with means and standard deviations
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
I'd like to create a script that loops through multiple subjects and creates a new structure with doubles in it.
First Column of Master Table: I want the SubjectID but I only want it once, I don't want it repeating like it is in the dataset I've attached.
Second Column of Master Table: I want it to lead to a struct with the means of each of the six events. So in the new struct, I want the first column of the first row to be for event 1_a, second column first row event 2_a, etc.
Third Column of Master Table: I want it to lead to a struct with the standard deviation of each of the six events.
Here's an example of what I want it to look like:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1127180/image.png)
The examples of mean and standard deviation doubles are only for one subject. I'd like to loop this for every subject in the data table to create a master struct.
0 Kommentare
Akzeptierte Antwort
Chris
am 16 Sep. 2022
Bearbeitet: Chris
am 16 Sep. 2022
S = struct('id',uint64(123456),'mean',rand(3),'stdev',rand(1,3))
% Add new data
for idx = 2:4
S(idx).mean = rand(3);
S(idx).stdev = rand(1,3);
S(idx).id = uint64(randi(1e9));
end
S
% Retrieve data
x = S(3).stdev
y = [S(1:2).id]
5 Kommentare
Chris
am 16 Sep. 2022
Bearbeitet: Chris
am 16 Sep. 2022
Unstack sounds useful, but I'm unfamiliar with it and man, I need to learn some table stuff.
@BA How about something like this?
EventData = readtable('Event_1_2.xlsx');
vars = T.Properties.VariableNames;
[u,~,ic] = unique(EventData.UserID);
for idx = 1:numel(u)
Updating(idx).ID = u(idx);
T = EventData(ic==idx,2:end);
Updating(idx).stdev = array2table(std(T{:,:}),'VariableNames',vars);
Updating(idx).mean = array2table(mean(T{:,:}),'VariableNames',vars);
end
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Matrices and Arrays finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!