Each row of the table want contains information about a specific person. Each row of the cell array (I tried having it be a table and got different errors) roster has information about a specific person and their subject ID. I want to get the subject ID of every person in the table want. To do this, I am saying (I think I'm saying) for every row in want to find the row in roster that has the same value in column 3 as want's column 3 and the same value in roster's column 2 as want's column 2. Then the array PTID will print all of the subject IDs that I want.
Errors:
-line 5: too many input arguments for == (it does this with and without the and)
-line 5: I think the {:,3} and {:,2} might not necissarily mean the same row in both cases
-line 1 & 2 (currently not an error, but might cause other errors): having want be a table and roster be a cell doesn't allow it to do the same things as matrices does, but I am unable to turn them into matrices.
-previously I had the error == was an undefined operator for cell type, but fixed it by using curly brackets
1 want=readtable('miniStable_MCI.csv');
2 roster = table2cell(readtable('miniROSTER.csv'));
3 PTID=zeros(4439);
4 for j = 1:4439
5 rosterrow=find((roster{:,3}==want{j,3})&(roster{:,2}==want{j,2}));
6 ...
7 ...
8 PTID(j)=roster(rosterrow,5);
9 end
sprintf(PTID)
example rows of want:
[ADNI1 39 267 2035; ADNI1 5 267 50; ADNI2 39 19 50]
example row of roster:
[ADNI1 39 82 50 149_S_0082; ADNI1 14 19 002_S_0019; ADNI1 5 267 50 014_S_0267]
So row 2 of want would correlate with row 3 of roster and output subject ID 014_S_0267]
Thank you so much!!
