MATLAB: Copy the content of one table to an other table with different size

table

I need to copy the "GroupCount" of the first table to the second table. Second table has larger size and I need to copy the GrouCount of table one to the second table with correpsonding tme and radius. For example GroupCount=1 of the first row of the first table should be copied to the seond table that its time=0 and its radous is 0.

I used this code but I got error:

  table2.x=...
         table1.GroupCount(table1.time==table2.time && table1.radius==table2.radius)

and the error:

         Matrix dimensions must agree.

Best Answer

This is trivially done with outerjoin:

mergedtable = outerjoin(yourbigtable, yourgroupcounttable, 'Keys', {'Time', 'radius'}, 'MergeKeys', true, 'Type', 'left')

Any time you want to merge tables, look at join, innerjoin, or outerjoin depending on the type of join you need.

Related Solutions

MATLAB: Simple for loop efficiency

How about doing this.

table{:,1} = (table{:,1}-table{1,1})/fs*1000;

And let's check the calculation time.

 fs = 100;
 table1 = array2table(rand(1000,2));
 table2 = table1;
 % Slightly modified original code
 tic
 firstvalue = table1{1,1};
 i = 1;
 n = height(table1);
 for i = 1:n
    x = table1{i,1};
    table1{i,1} = (x-firstvalue)/fs*1000;
 end
 toc
 % Proposed code
 tic
 table2{:,1} = (table2{:,1}-table2{1,1})/fs*1000;
 toc
 % Check the answer
 isequal(table1, table2)

In my PC, the result is 0.131066 sec -> 0.003073 sec and table2 is the same as table1.

MATLAB: Call specific rows of a table then choose rows that has specific criteria in those rows .

I want to say for each radius celltracker_group2.time == 10 if radius<=3 and cell_type==4 then GroupCount=GroupCoutn+1

Easily done:

selectedrows = celltracker_group2.time == 10 & celltracker_group2.radius <= 3 & celltracker_group2.celltype == 4;  %logical vector indicating which rows match the condition
celltracker_group2.GroupCount(selectedrows) = celltracker_group2.GroupCount(selectedrows) + 1;  %add 1 to groupcount of the rows that match the condition

Best Answer

Related Solutions

MATLAB: Simple for loop efficiency

MATLAB: Call specific rows of a table then choose rows that has specific criteria in those rows .

Related Question