i have a list of data and i have to select first 5th column of each row ..then simultaneously 6th column and 7th column

T = table(categorical({'karan';'varun';'ravina'}),[25;45;12],...
    {'Surgery';'orthopaedic';'orthopaedic'},[2017-04-15;2017-04-16;2017-04-15],[5000:8000:8000],['M';'M';'F'],logical([1;0;0]),...
    'VariableNames',{'Name','Age','Dept','DoB','charge','gender','vote'})
for i=1:3
    for j=1:7
        matrix(j)=T(i,j)    %at this point i should assign each row to matrix(j)
    end
    first_task=matrix(j-2) %  i should assign each row value of 'charge' here

I am not able to assign here...mistake in coding ...can anyone pls guide me where i am going wrong..

[Jan]

[5000:8000:8000] : This is 5000. Do you mean [5000, 8000, 8000]?

I do not understand, what you want to achieve. Maybe all you need is:

matrix = Table{:, 6:7}

[prabhu singh]

T = table(categorical({'karan';'varun';'ravina'}),[25;45;12],...

{'Surgery';'orthopaedic';'orthopaedic'},[2017-04-15;2017-04-16;2017-04-15],[5000:8000:8000],['M';'M';'F'],logical([1;0;0]),...

'VariableNames',{'Name','Age','Dept','DoB','charge','gender','vote'})

for i=1:3

for j=1:7

matrix(j)=T(i,j) %at this point i should assign each row to matrix(j)

at this point my result should be

matrix=karan,25,surgery,2017-04-15,5000,M,true

[Jan]

As said already: The code does not run:

T = table(categorical({'karan';'varun';'ravina'}), ...
    [25;45;12],...
    {'Surgery';'orthopaedic';'orthopaedic'}, ...
    [2017-04-15;2017-04-16;2017-04-15], ...  % 2017-04-15 is 1998 !!!
    %  Maybe this should be strings or datetime objects?
    % ["2017-04-15"; "2017-04-16"; "2017-04-15"]
    [5000:8000:8000], ...                    % This equals 5000 !!!!
    ...                            % Do you mean [5000, 8000, 8000] ?
    ['M';'M';'F'], ...
    logical([1;0;0]),...
    'VariableNames',{'Name','Age','Dept','DoB','charge','gender','vote'})

Using this code:

for i=1:3
    for j=1:7
        matrix(j)=T(i,j)        

you will overwrite the element matrix(j) in each iteration in the "for i" loop. Is this really wanted?

[prabhu singh]

yes sir i have to overwrite
i have to use loop here bcoz for every row i have to repeat the same procedure
first step is to assign 5th column ( one value of each row) then 6th column  value
i.e my loop first should select first row from the table in that assign
first task=5000
second task='M'
if T(i,7)==true            %logical one
 then
function(first task)                %i have created function here where i have to pass that first task value
else
otherfunction(first task)         %i have created other function also here where same first task value is passed
then same procedure i have to follow for second task also
if T(i,7)== true              %logical one
then
function(secondtask)                %i have created function here where i have to pass that second task value
else
otherfunction(fsecondtask)         %i have created other function also here where same second task value is passed

[Peter Perkins]

This sounds like you should be using rowfun on a table. See my other response.

[prabhu singh]

instead of creating a table form ..can i go with some other technique? (with same list of data)

like i can't create array bcoz each data is different

[Peter Perkins]

Mixed data types are exactly what tables are for.

Answer 1

[Arif Hoq]

I have changed your variable from categorical to cell arrray.

T = table({'karan';'varun';'ravina'},[25;45;12],...
    {'Surgery';'orthopaedic';'orthopaedic'},['2017-04-15';'2017-04-16';'2017-04-15'],...
    [5000;8000;8000],['M';'M';'F'],logical([1;0;0]),...
    'VariableNames',{'Name','Age','Dept','DoB','charge','gender','vote'});
T1=table2cell(T);
matrix=cell(size(T,1),1);
for i=1:3
    matrix{i} = T1(i,:);
end
output=reshape([matrix{:}],7,3)'

output = 3×7 cell array
    {'karan' }    {[25]}    {'Surgery'    }    {'2017-04-15'}    {[5000]}    {'M'}    {[1]}
    {'varun' }    {[45]}    {'orthopaedic'}    {'2017-04-16'}    {[8000]}    {'M'}    {[0]}
    {'ravina'}    {[12]}    {'orthopaedic'}    {'2017-04-15'}    {[8000]}    {'F'}    {[0]}

[prabhu singh]

thank u sir now

T1=table2cell(T);

matrix=cell(size(T,1),1);

for i=1:3

for j=1:7

matrix{i} = T1(i,:);

output=reshape([matrix{:}],7,3)'

end

first_task=matrix(j-2) % i m getting error here

my output should be

first_task= 5000 %i.e of each row i should assign 'charge' column

[Arif Hoq]

you can do that easlily by linear indexing from output variable

T = table({'karan';'varun';'ravina'},[25;45;12],...
    {'Surgery';'orthopaedic';'orthopaedic'},['2017-04-15';'2017-04-16';'2017-04-15'],...
    [5000;8000;8000],['M';'M';'F'],logical([1;0;0]),...
    'VariableNames',{'Name','Age','Dept','DoB','charge','gender','vote'});
T1=table2cell(T);
matrix=cell(size(T,1),1);
for i=1:3
    matrix{i} = T1(i,:);
end
output=reshape([matrix{:}],7,3)';
first_task=output(:,5)

first_task = 3×1 cell array
    {[5000]}
    {[8000]}
    {[8000]}

[Arif Hoq]

or do you want only the 'charge' column for each row ?

[prabhu singh]

as per now i want only 'charge' column of each row..

[Arif Hoq]

so, my last comment isn't enough for that ? you can find the charge column in the variable 'first_task'. or do you want 'charge' column from 'for' loop ?

[Arif Hoq]

if you want the 'charge' column in for loop then,

T = table({'karan';'varun';'ravina'},[25;45;12],...
    {'Surgery';'orthopaedic';'orthopaedic'},['2017-04-15';'2017-04-16';'2017-04-15'],...
    [5000;8000;8000],['M';'M';'F'],logical([1;0;0]),...
    'VariableNames',{'Name','Age','Dept','DoB','charge','gender','vote'});
T1=table2cell(T);
matrix=cell(size(T,1),1);
for i=1:3
for j=1:7    
matrix{i} = T1(i,5); % charge column only
end
end
first_task=[matrix{:}]'

first_task = 3×1 cell array
    {[5000]}
    {[8000]}
    {[8000]}

[prabhu singh]

thank you Sir ..this helped

[Arif Hoq]

most welcome. but you don't need the second for loop(for j=1:7) here. you can omit this loop

[prabhu singh]

sir ..nw i am not assigning correct value here

T = table({'karan';'varun';'ravina'},[25;45;12],...

{'Surgery';'orthopaedic';'orthopaedic'},['2017-04-15';'2017-04-16';'2017-04-15'],...

[5000;8000;8000],['M';'M';'F'],logical([1;0;0]),...

'VariableNames',{'Name','Age','Dept','DoB','charge','gender','vote'});

T1=table2cell(T);

matrix=cell(size(T,1),1);

for i=1:3

for j=1:7

matrix{i} = T1(i,5); % charge column only

matrix{i} = T1(i,6); % Selecting gender column only here

end % after this line i am not assigning correct values

first_task=[matrix{:}]' % this should be always be overwritten like in first 'i' iteration first_task =5000 then in 2nd 'i' iteration first_task=8000 and so on...now it will go to next line

if T1(i,7)==true %comparison if vote is true

display T1(i,1) % cell name of a person

else

display T1(i,1) % cell name of dept of person belongs to

end

k=i+1;

matrix{k} = T1(i,6); % same comparison i should perform for this column also

[Arif Hoq]

Please be specific about your expectaion. you don't need for loop i guess. if you want charge or gender column only or all variable then you don't need loop. you can do it by linear indexing.

Here again i have tried in your way with foor loop(unnecessary) and check the display result(logical part).

again i am asking about your expectation.

T = table({'karan';'varun';'ravina'},[25;45;12],...
    {'Surgery';'orthopaedic';'orthopaedic'},['2017-04-15';'2017-04-16';'2017-04-15'],...
    [5000;8000;8000],['M';'M';'F'],logical([1;0;0]),...
    'VariableNames',{'Name','Age','Dept','DoB','charge','gender','vote'});
T1=table2cell(T);
matrix=cell(size(T,1),3);
for i=1:3
% matrix{i,1} = T1(i,5);  % charge column only
% matrix{i,2} = T1(i,6);  % gender column only
matrix{i,3} = T1(i,:);        % all
end  
allVar=[matrix{:}];
results= reshape(allVar,7,[])';
out=cell2table(results);
first_task=results(:,5); % charge clolumn only
second_task=results(:,6); % gender clolumn only
for j=1:3
    if table2array(out(j,7))== true
        disp(results{j, 1})
    else
        disp(results{j, 3})
    end
end

[prabhu singh]

sir my expectation is

i have attached the image below ..

i have to use loop here bcoz for every row i have to repeat the same procedure

first step is to assign 5th column ( one value of each row) then 6th column value

i.e my loop first should select first row from the table in that assign

first task=5000

second task='M'

if T(i,7)==true %logical one

then

function(first task) %i have created function here where i have to pass that first task value

else

otherfunction(first task) %i have created other function also here where same first task value is passed

then same procedure i have to follow for second task also

if T(i,7)== true %logical one

then

function(secondtask) %i have created function here where i have to pass that second task value

else

otherfunction(fsecondtask) %i have created other function also here where same second task value is passed

Answer 2

[Jan]

With some guessing:

T = table(categorical({'karan';'varun';'ravina'}), ...
    [25;45;12],...
    {'Surgery';'orthopaedic';'orthopaedic'}, ...
    ["2017-04-15";"2017-04-16";"2017-04-15"], ...
    [5000; 8000; 8000], ...
    ['M';'M';'F'], ...
    logical([1;0;0]),...
    'VariableNames', {'Name','Age','Dept','DoB','charge','gender','vote'});

matrix = table2cell(T(3, :))

matrix = 1×7 cell array
    {[ravina]}    {[12]}    {'orthopaedic'}    {["2017-04-15"]}    {[8000]}    {'F'}    {[0]}

Answer 3

[Peter Perkins]

You almost certainly do not need cell arrays. You certainly don't need numeric matrices because most of your data is not numeric.

Here's the table you want to start from:

>> T = table(categorical({'karan';'varun';'ravina'}), ...
>>     [25;45;12],...
>>     categorical({'Surgery';'orthopaedic';'orthopaedic'}), ...
>>     datetime({'2017-04-15';'2017-04-16';'2017-04-15'}), ...
>>     [5000;8000;8000], ...
>>     categorical({'M';'M';'F'}), ...
>>     logical([1;0;0]), ...
>>     'VariableNames',{'Name','Age','Dept','DoB','charge','gender','vote'})
T =
  3×7 table
     Name     Age       Dept            DoB        charge    gender    vote 
    ______    ___    ___________    ___________    ______    ______    _____
    karan     25     Surgery        15-Apr-2017     5000       M       true 
    varun     45     orthopaedic    16-Apr-2017     8000       M       false
    ravina    12     orthopaedic    15-Apr-2017     8000       F       false

Now, what is it that you want to do? "select first 5th column of each row ..then simultaneously 6th column and 7th column"? That's just

>> T(1,5:7)
ans =
  1×3 table
    charge    gender    vote 
    ______    ______    _____
     5000       M       true 

But what you you want to do with that? You almost certainly do not need cell arrays or loops.