Sorting out an entire table with index

5 次查看（过去 30 天）

显示更早的评论

Yannick Tabot Njami 2019-3-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/450221-sorting-out-an-entire-table-with-index

评论： Yannick Tabot Njami 2019-3-15

data.xlsx

在 MATLAB Online 中打开

Dear ALL,

Basically i want to generate 4 figure windows each having 8 graphs on it corresponding to the cases when y=[20 50 80 110 140 170 200 230]

For each case i need to get the index of y pass it to each of the last four columns of the table to get the corressponding values and the x coorinate at which they occure. making them now pairs of( x,y) and then make a plot for each 4 columns. I.e plot (x, mean velocity), (x,stdvelocity), (x,mean_pd), (x,std_pd)

I did that for the first case for y=20 and the resulting grapgh was good see attachment.

Please how do i extend that to the remaining columns? perhaps a for loop and how can i pass the yindex to the the table?

attached is my data,first figure and below is my code :

many thanks in advance

Generating the table  of average values
 Average_Table = table(xcoordinate,ycoordinate,mean_velocity,std_velocity, mean_pd ,std_pd);
 
  
 for jj = 20 :30 :230
     yindex=find(ycoordinate == jj);
%      Deleting the  first index  to eliminat  the  offset value at  y=20
      if  jj ==20
         yindex(yindex==1)=[];
      end
  % getting the indices corresponding to each  case.
      newX=(xcoordinate(yindex));
      newY =mean_velocity(yindex);
    
     
%      table of newx and newY
     tableXY =[newX newY];
%          soting out the  table in descending order 
      sortedtable =zeros(length(tableXY),2);
     sortedtable(:,1)=sort(tableXY(:,1));
      sortedX = sortedtable (:,1);
      for N =1:length(tableXY)
          sortedtable(N,2) =tableXY(find(ismember(tableXY(:,1),sortedtable(N))),2);
         %     sorted  Y coordinates
          sortedY = sortedtable(:,2);
     end
     
      hold on 
     
  
           plot(sortedX,sortedY,'color',rand(1 ,3),'marker','*','DisplayName',['Y =',num2str(jj)]);
         xlabel('x position');
       ylabel('mean velocity');
       legend show
%      
       drawnow;
      
 end

2 个评论
显示无隐藏无

Guillaume 2019-3-15

Is this in any way different to your previous question?

Yannick Tabot Njami 2019-3-15

Hello Guillaume, its the same question. the code you proded did run but the out put was not what i expected. i expected 4 plots each with 8 lines. please i guuess not its more understandable since i have my data,first plot and entire code uploaded....

请先登录，再进行评论。

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