how to run a code putting conditions on names cell

I have a dataset as follows:

where there are patients and each session of them in the first column, the second is the age, and imagine that the third is my data. I have to do some stuff with this data and I know how I can do it. Imagine now that I have only to plot the third column against the second. What I want is to compute output for all data considering all sessions of each patient. For instead for P10 I want consider the column vectors that go from 1°row to 4°, or for P13.....from 5°to7° etc etc.

PS: I thought to have done well to leave the first column as lonely cell array and the rest of matrix like double.

Answer 1

[Rik]

Convert the array to a 3D array: (patient,session,param_index). You can fill missing slots with NaN. That way it is just a matter of indexing to select all sessions from one patient.

If you need help with the conversion, post an example of your data (or your actual data).

[matteo bottoni]

list=dir('C:\Users\39338\Desktop\PROJECTMATLAB\TD_output\');
list_clean = setdiff({list([list.isdir]).name},{'.','..'});

[DATA, txt] = xlsread('Table_GR_TD_children.xlsx');
antro_matrix=[DATA(2:10,1:5); DATA(13:14,1:5); DATA(16:17,1:5); DATA(19:20,1:5);DATA(22:54,1:5);DATA(56,1:5);DATA(58:63,1:5)];
list_table=[txt(2:10,2); txt(13:14,2); txt(16:17,2); txt(19:20,2);txt(22:54,2);txt(56,2);txt(58:63,2)];
antro_matrix_cell = arrayfun(@num2str,antro_matrix,'UniformOutput',false);   
C = [list_table,antro_matrix_cell];
antro = sortrows(C,1);
names_cell=[antro(:,1)];
antro=str2double(antro(:,2:end));
General_matrix = [antro,R_ST_SW_DS,R_Std_Phases,%others];     

Before I obviously putted an example with a small General_matrix (2° and 3° column of pic)

[Rik]

You shared an image. Either post code that will convert that image back to data, or post actual data. I don't need the code that generated the cell array, just the cell array. If you do want to post the generator code, you should include the excel file as well.

[matteo bottoni]

yes you're right sorry

[Rik]

Something like this?

clear%optional, useful during debugging
S=load('antro.mat');
labels=S.list_table;
data=S.antro_matrix;

%extract the values from P%dS%d
%method 1: regexp
a=regexp(labels,'P([0-9]*)S([0-9]*)','tokens');
a=[a{:}].';a=cat(1,a{:});a=cellfun(@str2double,a);

%method 2: textscan
b=cellfun(@(x) textscan(x,'P%dS%d'),labels,'UniformOutput',0);
b=cellfun(@(x) [x{1} x{2}],b,'UniformOutput',0);
b=double(cell2mat(b));

%create indices (assumes no patient or session number is 0 or non-integer
pat=a(:,1);
ses=a(:,2);
param_idx=(1:size(data,2));

%extend to fit size of data
pat=pat.*ones(size(data));
ses=ses.*ones(size(data));
param_idx=param_idx.*ones(size(data));

%put the data in an array
new_data_shape=accumarray([pat(:),ses(:),param_idx(:)],data(:),[],[],NaN);

%examples:

%select all sessions from patient 24:
pat24=new_data_shape(24,:,:);

%select all patients that have data session 1 parameter 4:
pat_list=find(~isnan(new_data_shape(:,1,4)));

[matteo bottoni]

I'm sorry sir but I'm not understanding very well how can I work with 3d matrix and automatizate it for all file. I mean that I don't want to create every output manually. I would like that Matlab should understand that while the number # doesn't change after P then it has to rune the code for that small matrix. If u think that your code is better can you add something else please?

[Rik]

I showed two examples at the end of the code I posted. What is unclear to you?

This code will change your data array so you don't need to know that lines 1 and 18 belong to the same patient, but you can simply index into your data:

patient=17;session=1;
parameter=4;

%easy:
value=new_data_shape(patient,session,parameter);

%hard:
lookuplabel={sprintf('P%dS%d',patient,session)};%create {'P17S1'}
idx=find(ismember(labels,lookuplabel));
value=data(idx,parameter);