Limit values based on one column?

Question

DrWooo 2017-10-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/359370-limit-values-based-on-one-column

评论： DrWooo 2017-10-2

采纳的回答： James Tursa

在 MATLAB Online 中打开

Hi. I'm trying to plot data inputted from Excel into a simple (x,y) scatter plot.

As an example, data in the Excel file was:

Location  Distance (m)  Time (seconds)
                 5  120
                 10  200
                 25  300
                 30  350
                 4  100
                 50  200
                 70  250
                 100  300
                 5  75
                 12  100
                 13  200
                 40  300

I've already successfully inputted the data into a matrix using:

B = xlsread('filename','sheetname');

I set each column as a variable:

    L = B(:,1);
    D = B(:,2);
    T = B(:,3);

I'd like to plot (D,T) for each value of L. I know how to do this if I call each cell in L; for example:

    for x = D(1:4)
        for y = T(1:4)
        scatter(x,y)
        end
    end

However, I'd like to set it up so that I can call for the location (ie, for L = 1) and create separate (x,y) plots of each L, as I have quite a bit of data and think this will be faster. Additionally, the L values correspond with a text value (I converted to numbers as the text appeared as NaN). If possible, I'd like to make the title of each graph correspond with the text Location value. Any suggestions for how to approach this are greatly appreciated.

Cheers

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

请先登录，再进行评论。

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

Answer 1

James Tursa 2017-10-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/359370-limit-values-based-on-one-column#answer_284000

在 MATLAB Online 中打开

Something like this?

u = unique(B(:,1));
for k=1:numel(u)
    d = B(B(:,1)==u(k),:);
    figure; scatter(d(:,2),d(:,3)); grid on;
    title(sprintf('Location = %d',u(k)));
end

5 个评论
显示 3更早的评论隐藏 3更早的评论

James Tursa 2017-10-2

So, what is the relationship between the columns of your 53x18 matrix and your 12x3 example? How are we supposed to know what you are wanting to plot if your example does not match your actual data?

DrWooo 2017-10-2