MATLAB: How to arrange a column in a concatenated Matrix

MATLABsummatrix

Hello Everyone,

I'm having hard time arrange the last Column which represents a the total nymber of each row in the following matrix. May you kindly highlight my mistake?

Much Obliged:

Title = ["Reported Country case","No . Deaths","Active case Total","Recovered","Total Cases"]
Countryname = ["Spain";"China";"Germany";"Iran";"France";"UK";"USA";"Italy"]
CasesNum = [24543,77112,137984;4633,599,77642;6623,29486,126900;6091,13237,76318;24376,93326,49476;26771,144138,0;63871,875696,155737;27967,101551,75945];  
Totalsumcolum = sum(CasesNum',1)
CasesNumT = [CasesNum,Totalsumcolum']
TotalAppended = [Countryname,CasesNum,Totalsumcolum']
Totalsumrow = sum(CasesNumT,1);

Best Answer

Try this:

Title = ["Reported Country case","No . Deaths","Active case Total","Recovered","Total Cases"]
Countryname = ["Spain";"China";"Germany";"Iran";"France";"UK";"USA";"Italy"]
CasesNum = [24543,77112,137984;4633,599,77642;6623,29486,126900;6091,13237,76318;24376,93326,49476;26771,144138,0;63871,875696,155737;27967,101551,75945];
Totalsumcolum = sum(CasesNum',1)
CasesNumT = [CasesNum,Totalsumcolum']
TotalAppended = [Countryname,CasesNum,Totalsumcolum']
Totalsumrow = sum(CasesNumT,1);
t = table(Countryname, CasesNumT(:, 1), CasesNumT(:, 2), CasesNumT(:, 3), CasesNumT(:, 4), 'VariableNames', Title)

You'll get a table:

t =

8×5 table

Reported Country case No . Deaths Active case Total Recovered Total Cases

_____________________ ___________ _________________ _________ ___________

"Spain" 24543 77112 137984 239639

"China" 4633 599 77642 82874

"Germany" 6623 29486 126900 163009

"Iran" 6091 13237 76318 95646

"France" 24376 93326 49476 167178

"UK" 26771 144138 0 170909

"USA" 63871 875696 155737 1095304

"Italy" 27967 101551 75945 205463

Related Solutions

MATLAB: Need help selecting the max of array A, then selecting corresponding array B

The problem is the 's' at the end of your fprintf() statement

   printf('\n The country with the lowest percentage of wind energy is  %s  with %2.2f \n',countrynameMIN,minpe)

MATLAB: Timetable with string array

As the error indicates, you cannot retime non-numeric data. Your table contains a column "participant" which contains strings. You must remove that column before applying retime().

Here's a look at your raw data.

% Here's the first few rows of your table 'W'
head(W)
%          date_time         participant     R       G       B      lux
%     ___________________    ___________    ____    ____    ____    ___
%     2018.05.19 08:56:00        "D"        8828    9756    6276    734
%     2018.05.19 08:57:00        "D"          12       4       4      0
%     2018.05.19 08:57:00        "D"          11       7       3      1
%     2018.05.19 08:57:00        "D"          75      39      17      3
%     2018.05.19 08:57:00        "D"          59      31      13      3
%     2018.05.19 08:57:00        "D"         258     122      56     10
%     2018.05.19 08:57:00        "D"          51      24       9      2
%     2018.05.19 08:58:00        "D"         570     193      88     19
% How many groups of participants are there?
unqParticipants = unique(W.participant)
% ans = 
%   10×1 string array
%     "D"
%     "E"
%     "F"
%     "G"
%     "P"
%     "Q"
%     "R"
%     "S"
%     "T"
%     "V"

If you want to apply retime() across all of your data, ignoring the participant groups,

% Create a sub-table, remove 'participant'

Wnum = W; 
Wnum.participant = []; 
% apply retime() to the entire numeric timetable
CM5_1min = retime(Wnum,'minutely','mean');
%Check out the result
size(CM5_1min)
%   ans =  18095   4
head(CM5_1min)  %first few rows
% ans =
%   8×4 timetable
%          date_time           R         G         B        lux  
%     ___________________    ______    ______    ______    ______
%     2018.05.14 09:50:00      1330      1151     453.5      91.5
%     2018.05.14 09:51:00    3192.8    2884.2      1164    228.33
%     2018.05.14 09:52:00     24439     21921     10705    1838.2
%     2018.05.14 09:53:00     29331     26110     12779    2194.8
%     2018.05.14 09:54:00     29041     25779     12505    2162.5
%     2018.05.14 09:55:00     16763     15040    7210.1      1225
%     2018.05.14 09:56:00     15675     13803      6534    1133.3
%     2018.05.14 09:57:00     14768     13287    6297.1    1083.9

If you want to apply retime() to each participan individually, you'll need to break apart the timetable by participant and store the minutely data in a cell array.

% Create a sub-table, remove 'participant'
Wnum = W; 
Wnum.participant = []; 
% separate minutely table for each participant
% This will take some several seconds....
unqParticipants = unique(W.participant)
TT = cell(numel(unqParticipants), 1); 
for i = 1:numel(unqParticipants)
    % identify rows of W that match participant i
    rows = strcmp(W.participant, unqParticipants(i)); 
    % retime for participant i
    TT{i} = retime(Wnum(rows,:),'minutely','mean');
    % If you want, you could add the participant back into the table
    TT{i}.Participant = repmat(unqParticipants{i},size(TT{i},1),1);    
end
% Check out the minutely table for participant n
n = 3
unqParticipants(n)
head(TT{n})

You can combine those minutely timetables back into one table and sort them by datetime

% Combine back to 1 TT
TTmain = sortrows(vertcat(TT{:})); 
% confirm that the date_time column is monotonically increasing
all(diff(TTmain.date_time) >= 0)  %should return 1 / true

Best Answer

Related Solutions

MATLAB: Need help selecting the max of array A, then selecting corresponding array B

MATLAB: Timetable with string array

Related Question