MATLAB: How can extract specific value from a column contains 3 conditions

csvexcel

Hello,

I faced problem of separating the data in .csv file. I have huge data consiste of 81 csv, and each file consists of 887808×74 matrix. My work depends on separted 3 conditions (labels) based on third column which has condition 1 , condition 2, and condition 3. I want to put each condition togethor for example condition 1 with all information that related in other columns togethor and so on for other conditions. i tried to do it by myself but not work.

If any one has idea to help me i will appretiate that. it can find out the sample of the file in attachment.

Regards,

Best Answer

I assume that you are using datastore and tall array.

Suppose tb is your tall table. You can use tb1 = tb(tb.(3) == 1, :) to get a subtable that has condition 1 on the third column. and similarly use tb(tb.(3) == 2, :) to get a subtable that has condition 2.

Is this what you want?

Related Solutions

MATLAB: Saving with quotes.

Hint

>> grunk = '''WOW'''

grunk =

'WOW'

Depending on what you want, you could consider repmat()?

MATLAB: I have an hourly meteorological data screenshot attached which i need to convert to average daily data. Since I have a long period of data it is difficult to do it in excel. If anyone knows how to code it in matlab pls let me know

T = readtable('your_xls_file.xls');
t = datetime(strcat(T{:,2},'_',T{:,1}),'i','MM/dd/uuuu_HH:mm');
TT = table2timetable(T(:,3:end),'RowTimes',t);
E = regexp(TT{:,end},'\d+','match');
E = str2double(cat(1,E{:}));
tt = duration(E(:,1),E(:,2),0);
TT = [TT(:,1:end-1),table(tt,'v',TT.Properties.VariableNames(end))];
TTout = retime(TT,'daily','mean');
TTout = TTout(all(~isnan(TTout{:,:}),2),:);

T = readtable('your_xls_file.xls');
t = datetime(T{:,2});
A = regexp(T{:,end},'\d+','match');
A = str2double(cat(1,A{:}));
tt = duration(A(:,1),A(:,2),0);
TT = table2timetable([T(:,3:end-1),table(tt,'v',T.Properties.VariableNames(end))],'RowTimes',t);
TTout = varfun(@mean,TT,'GroupingVariables','Time');

Best Answer

Related Solutions

MATLAB: Saving with quotes.

MATLAB: I have an hourly meteorological data screenshot attached which i need to convert to average daily data. Since I have a long period of data it is difficult to do it in excel. If anyone knows how to code it in matlab pls let me know

Related Question