Sorting Excel values into new vector

Question

John Corrado 2021-8-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1441979-sorting-excel-values-into-new-vector

回答： darova 2021-8-29

Hi, I'm sort of lost when it comes to sorting data. I have a .xlxs file that contains data in a single column that's formated as four values. The first value is 255 , never changes, and I planned on using that as a marker to start sorting. I've imported the table and made it a vector, however, I have no clue on how to add every other value into a certain vector.

The data looks something like:

                               % Start sorting 
66                                % Data set 1 
52                               % Data set 2 
59                                % Data set 3 
                               % Start sorting 
65                                % Data set 1 
98                               %And so on and so forth 

And my code looks something like this:

clear all
filename = "CARACT 255 60.XLSX";    % Set filename
DATA = xlsread(filename,'A:A')      % Read data table 
DUTY = 1;                           % Counter 1 
TVIN = 2;                           % Counter 2 
TEMP = 3;                           % Counter 3 
LVIN = 4;                           % Counter 4 
for i = 1:length(DATA)
    DUTY_OUT = xlsread              % Sort 1 
    TVIN_OUT = xlsread              % Sort 2 
    TEMP_OUT = xlsread              % Sort 3 
    LVIN_OUT = xlsread              % Sort 4 
    
    DUTY = DUTY+1;                  % Add to counter 1
    TVIN = TVIN+1;                  % Add to counter 2
    TEMP = TEMP+1;                  % Add to counter 3
    LVIN = LVIN+1;                  % Add to counter 4
end

Any help would be much appreciated!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

darova 2021-8-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1441979-sorting-excel-values-into-new-vector#answer_776424

在 MATLAB Online 中打开

Try this

ind = find(abs(data-255)<0.1);          % find all '255' numbers
ind(end+1) = numel(data)+1;             % add last index+1
for i = 1:numel(ind)-1
    ii = ind(i)+1:ind(i+1)-1;           % select data between current '255'
    data(ii) = sort(data(ii));          % sort data
end