Using ordered list for plotting charts

Hi guys!

I have a list of numbers as shown below. The problem is, I need plotting some charts using these data. You gonna notice that the first value of 5th column is 23, so I need to sweep all the rows which contains 23 in the 5th column and make a chart. After that, I go to the next one (28) and do the same. How could I do that? I have plenty of files which have different numbers of rows, for instance, the first file has 10 rows with 23 in the 5th column, but the last file could have 18 rows which has 23 in the 5th column. Please, I need your help and thank in advance! See ya!

Answer 1

[Michael Haderlein]

Your question is a bit unclear. Do you struggle with loading the data, with sorting the data or with plotting the data? Plus, what kind of plot do you mean?

As loading this kind of files is pretty simple, I just want to refer to dlmread.

As I have just answered on another question with slightly similar content, I suggest to use arrayfun also here. Suppose data is the variable containing all the data (intuitive naming here).

 figure, hold all
 arrayfun(@(x) plot(data(data(:,5)==x,2)),unique(data(:,5)))

will plot the data of the second column over 1:n, while

 figure, hold all
 arrayfun(@(x) plot(data(data(:,5)==x,1),data(data(:,5)==x,2)),unique(data(:,5)))

will plot the data of the second column over the data of the first column. If you need another kind of plotting, just change the argument here.

[Carlos Nogueira]

Hi! Actually, loading data is ok, I am able loading. Look the image below. I have sorted the "A" matrix using B =sortrows(A,5), in other words by 5th column. First of all, I need to plot the blue block. Later, I have using all rows which has 28 at the 5th column and so on. The problem is not how to plot, the big deal is how to get these data. Thanks guy!

;

[Michael Haderlein]

Ok, you can sort the data before, but it's not necessary. The more important question is how should the plot look like? Should the 6th column be plotted against the 4th? Columns 4-8 against 1:n? A possible way to do so is sketched in my previous answer. You can either work out the way which fits your needs perfectly starting from there or you tell us what exactly the plot should be.

[Carlos Nogueira]

Hi Michael! Yes, my plot should be the 6th column plotted against the 4th as you said. If I found a way to find out what would be the position of the last element repeated, I guess my problem would be solved. For instance, in the last picture I sent, the first element of 5th column is 23. In this file, it repeats up to 23th row (shaded in blue).

[Michael Haderlein]

Well, if you just want the 6th column be plotted against the 4th (was just a random guess I must admit), simply change my upper suggestion to:

 figure, hold all
 arrayfun(@(x) plot(data(data(:,5)==x,4),data(data(:,5)==x,6)),unique(data(:,5)))

or, to make it clear:

 indicatingColumn=5;
 xColumn=4;
 yColumn=6;
 figure, hold all
 arrayfun(@(x)plot(data(data(:,indicatingColumn)==x,xColumn),...
                   data(data(:,indicatingColumn)==x,yColumn)),...
              unique(data(:,indicatingColumn)))