MATLAB: Summing columns of table

columnsum

Hello,

I have imported a table from excel to Matlab in it's correct form.

I have already summed the first two columns and added as new column to table by doing:

T = readtable("Table 1.xlsx")
T.Early = (T.x22_early) + (T.x7_early)

However, the rest of the table is very long. I was wondering if there is a simpler way than to enter all the columns individually as I did previously.

Thank you in advance

Best Answer

hello

see doc Calculations on Tables - MATLAB & Simulink (mathworks.com)

see example for taking mean values :

Find the Average Across Each Row

Extract the data from the second, third, and fourth variables using curly braces, {}, find the average of each row, and store it in a new variable, TestAvg.

T.TestAvg = mean(T{:,2:end},2)

T=10×5 table

Gender Test1 Test2 Test3 TestAvg

__________ _____ _____ _____ _______

HOWARD {'male' } 90 87 93 90

WARD {'male' } 87 85 83 85

TORRES {'male' } 86 85 88 86.333

PETERSON {'female'} 75 80 72 75.667

GRAY {'female'} 89 86 87 87.333

RAMIREZ {'female'} 96 92 98 95.333

JAMES {'male' } 78 75 77 76.667

WATSON {'female'} 91 94 92 92.333

BROOKS {'female'} 86 83 85 84.667

KELLY {'male' } 79 76 82 79

now do it for sum , and specify column index if needed :

T.TestSum = sum(T{:,2:end},2)

Related Solutions

MATLAB: Sorting a table with strings and numbers

Use readtable() to read in the workbook

T = readtable(fullXlsFileName);

Then use sortrows() to sort the table based on the column with strings in it. Let's say that the column with strings is the first column, like in the example below. Then you'd just do:

LastName = {'Smith';'Johnson';'Williams';'Jones';'Brown'};
Age = [38;43;38;40;49];
Height = [71;69;64;67;64];
Weight = [176;163;131;133;119];
BloodPressure = [124 93; 109 77; 125 83; 117 75; 122 80];
% Create a table, T, as a container for the workspace variables.
T = table(LastName, Age,Height,Weight,BloodPressure)
% Sort rows by last name.
sortedTable = sortrows(T, 1)

In the command window, you'll see the unsorted table first, followed by the sorted table:

T = 
     LastName     Age    Height    Weight    BloodPressure
    __________    ___    ______    ______    _____________
    'Smith'       38     71        176       124     93   
    'Johnson'     43     69        163       109     77   
    'Williams'    38     64        131       125     83   
    'Jones'       40     67        133       117     75   
    'Brown'       49     64        119       122     80   
sortedTable = 
     LastName     Age    Height    Weight    BloodPressure
    __________    ___    ______    ______    _____________
    'Brown'       49     64        119       122     80   
    'Johnson'     43     69        163       109     77   
    'Jones'       40     67        133       117     75   
    'Smith'       38     71        176       124     93   
    'Williams'    38     64        131       125     83

MATLAB: Table row not selecting

You need to define LastName. How should your program know what it is? It's not a built in function or anything.

Best Answer

Related Solutions

MATLAB: Sorting a table with strings and numbers

MATLAB: Table row not selecting

Related Question