Table - conditional maths and plots from variables
Show older comments
Dear all,
I have a 57254x87 table, on which I need to perform some maths and plots with the tables. I have one column called Subject_Id (total of 8 particpants) and another one called Trial_Id (a total of 6 per particpant), and I need to plot the data from two others variables. For example, I am looking for a code that will take the first subject, then run a loop for each one of the 6 trials, ploting the data of my columns 3 and 4, and then take the second subject, and reproduces the same thing one more time, and so on for the 8 subjects.
I guess I need one loop inside the other, but I am not sure how to do it.
Any help will be very much appreciated.
3 Comments
Chunru
on 19 Sep 2022
post a portion of your data.
Thiago de Aquino Costa Sousa
on 19 Sep 2022
Chunru
on 19 Sep 2022
Try to upload a mat file:
data = yourdata(1:200, :); % 1:200 or other number to demonstrate your case
Accepted Answer
Paul
on 19 Sep 2022
1 vote
Check out splitapply
7 Comments
Thiago de Aquino Costa Sousa
on 19 Sep 2022
Adam Danz
on 19 Sep 2022
While splitapply certainly could be used, I don't think it's the best option. A simple for-loop (or two nested for-loops) would likely be faster and more readable.
Thiago de Aquino Costa Sousa
on 19 Sep 2022
Hi @Adam Danz, thank you very much for you reply. I am pretty new in coding and Matlab. I have this code so far...
clear
clc
mytopfolder = '/Users/.../Participants data';
filepattern = fullfile(mytopfolder, '**/VIVE/Walking_ST/Trial_.txt');
thefiles = dir(filepattern);
nfiles = length(thefiles);
for k = 1:nfiles
basefilename = thefiles(k).name;
fullfilename = fullfile(thefiles(k).folder, basefilename);
fprintf(1, 'Now reading %s\n', fullfilename);
thisTable = readtable(fullfilename);
thisTable.Subject_Id(:) = {fullfilename(98:102)};
thisTable.Trial_Id(:) = {fullfilename(120:130)};
fprintf(' It has %d rows in it.\n', height(thisTable));
if k == 1
masterTable = thisTable;
else
masterTable = [masterTable; thisTable];
end
fprintf(' Now there are a total of %d rows in the master table.\n', height(masterTable));
end
masterTable.CameraX = masterTable.CameraX*-1;
And this is the structure of directory I have
Based on that, would you be able to hep me with this two nested for-loops as I don't have idea how to write it, that allows me to make a plot for each of my Subject associated to the trial Id. Thank you.
Paul
on 19 Sep 2022
Two nested for loops, with a unique() inside each could definitely do the job. I guess I've gotten into the splitapply habit. Don't know which is faster, or which would be considered more readable.
The splitapply approach would go as follows (completely untested code)
splitapply(@(trialid,col3,col4) plottrajid(trialid,col3,col4),T.Trial_ID,T.col3,T.col4,findgroups(T.Subject_Id))
function plottrialid(trialid,col3,col4)
splitapply(@(col3,col4) plotcols(col3,col4),col3,col4,findgrous(trialid))
end
function plotcols(col3,col4)
figure
plot(col3,col4)
xlabel('whatever')
% etc
end
Thiago de Aquino Costa Sousa
on 19 Sep 2022
Only one splitapply is needed
Create some data in a table.
rng(100)
T = table;
T.subj = [ones(10,1); 2*ones(10,1)];
T.trial = 3*randi(2,20,1);
T.col3 = (1:20).';
T.col4 = T.subj + T.trial;
Make the plots
G = findgroups(T.subj,T.trial);
splitapply(@(subj,trial,col3,col4) makeplot(subj(1),trial(1),col3,col4),T.subj,T.trial,T.col3,T.col4,G);
function makeplot(subj,trial,col3,col4)
figure
plot(col3,col4,'-o')
title("subj = " + double(subj) + ", trial = " + double(trial));
end
Thiago de Aquino Costa Sousa
on 21 Sep 2022
More Answers (0)
Categories
Find more on 2-D and 3-D Plots in Help Center and File Exchange
on 18 Sep 2022
on 21 Sep 2022
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
