How to calculate the area in table and certain coordinate

Question

mohd akmal masud 2021-10-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1465679-how-to-calculate-the-area-in-table-and-certain-coordinate

评论： C B 2021-10-13

      Area        Centroid    
      ____    ________________
        9     147.67    109.11
       27     146.81    108.52
       43     147.09     109.7
       54     147.81    109.35
       12     146.17    134.42
       56     147.73    109.46
       21     146.48    134.05
       53     147.83    109.26
       20      147.3    134.25
        2      126.5       146
       43     147.67    108.63
       24        147    134.04
        2      126.5       146
       45     147.93    108.87
       20     147.25    133.95
       10      125.5     146.8
       37     147.43    108.89
       16     147.31    133.56
        6     126.17       147
       36     147.39    108.81
       12     147.92    133.75
        6      126.5       147
       34     147.32    108.91
       12     147.92    133.75
        8      126.5       146
       29     147.69       109
       13     147.54    133.38
        8      126.5       146
       28     147.71    109.11
        7     148.14    134.43
        8      126.5       146
       28     147.71    109.11
        6        148     134.5
        7     126.43    145.71
       28     147.71    109.11
        7     147.29    133.71
        1        106       132
        8     126.25     145.5
       25      147.4    109.08
        7     147.29    133.71
        1        106       132
        5      126.4     145.2
       31     147.03    108.87
        9     147.33    133.78
        2      105.5       132
        6     126.17       145
       31     147.03    108.87
        9     147.33    133.78
        1        106       132
        3     125.67    144.33
       31     147.03    108.87
        9     147.33    133.78
       31     147.03    108.87
        9     147.33    133.78
       28     147.43    109.39
       10      146.7     133.6
       25     147.08     109.4
       11     147.55    133.18
       28     147.43    109.39
        5      146.8     133.2
       20      147.7    109.55
        3        149       132
       12     147.92    109.33

Hi all, I have data above.Anyone know how to calculate the total are ? Let say Inwant calculate the the total are that have coordinate (147 109) and (146 108), is it like this the command sum([146:147 108:109])?

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

请先登录，再进行评论。

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

Answer 1

C B 2021-10-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1465679-how-to-calculate-the-area-in-table-and-certain-coordinate#answer_800474

编辑：C B 2021-10-3

在 MATLAB Online 中打开

Hello @mohd akmal masud, You need to take out Area index then sum it where centroid is within you range.

You can do that like following

Area  = [9;27;43];
Centroid = [146.67    108.11; 146.81    109.52; 146.09     108.7];
T = table(Area ,Centroid);
%check in all value which are 147 in column 1 and 109 in column 2
trueIndex = ((147>=T.Centroid(:,1) & T.Centroid(:,1)>=146)&(109>=T.Centroid(:,2) & T.Centroid(:,2)>=108));
%add all area which have 147 and 109
sum(Area(trueIndex))

Or in one liner if you want

sum(Area(((147>=T.Centroid(:,1) & T.Centroid(:,1)>=146)&(109>=T.Centroid(:,2) & T.Centroid(:,2)>=108))))

Please mark answer as accepted if it satisfies your requirement.

13 个评论
显示 11更早的评论隐藏 11更早的评论

mohd akmal masud 2021-10-3

在 MATLAB Online 中打开

Ok, I explain to you.

Let say I have this below table. If you see, the first centroid is (147.59 109.28) have area 29. The third centroid is (147.55 110.18) have area 11.

Then I wrote Function as below

function total_Area = sum_area_objects(T,coord1,coord2)
total_Area = 0;
for i = 1:height(T);
    if T.Centroid(i,1) > coord1-1 & T.Centroid(i,1) < coord1+1 & T.Centroid(i,2) > coord2-1 & T.Centroid(i,2) < coord2+1
        total_Area = total_Area + T.Area(i);
    end
end
end

So , I dont know how to sum all the area that have centroid from (147 109) till (148 110). I wrote below but the answer is wrong. Because I want to all the centroid that have decimal point also .

Your_Answer = sum_area_objects( T, 147:148 , 109:110)

Area        Centroid    
____    ________________
   147.59    109.28
      147    129.57
   147.55    110.18
      147       129
      122     142.5
      122     142.5
      142       139
    145.5    111.14
      142       138
   146.74    108.68
   147.05    109.85
      142       137
   147.75    129.75
   147.75    109.56
   146.28    134.05
      125       145
   147.68    109.52
   146.48     133.8
   125.67    146.33
   147.77    109.37
   147.15    134.06
    126.5       146
   147.62    108.91
   146.89    133.84
   105.33    135.33
   126.31    145.92
   147.84    108.89
   147.07    133.89
    105.5     135.5
    125.5    146.86
   147.45     108.9
   147.17    133.64
   105.57    135.14
   126.09    146.91
   147.41    108.84
   147.82    133.85
   105.67    134.78
   126.35    146.57
   147.38    108.93
   147.82    133.85
    106.2     134.2
   126.41    146.04
    147.6    108.92
    147.6    133.63
    105.8    133.47
    126.5       146
   147.64    109.05
   147.76    134.14
   106.08    133.15
    126.5       146
   147.64    109.05
   147.68    134.18
   105.93    132.86
   126.26    145.78
   147.64    109.05
   147.41     133.9
   105.75    132.38
   126.07    145.62
    147.4    108.91
   147.41     133.9
   105.73    132.53
   126.52    145.38
   147.12    108.86
   147.42     133.9
    105.5    132.25
   125.96    144.91
   147.12    108.86
   147.21    133.82
      106       132
   125.56    144.67
   147.12    108.86
   147.32    133.85
    105.5     133.5
    125.7       145
   147.12    108.86
   147.32    133.85
      106       133
   125.56    144.78
   147.52    109.31
   146.94    133.79
    125.4     143.8
   147.25    109.26
   147.63    133.26
   147.52    109.31
   147.25    133.21
   147.78    109.32
    148.4    132.15
   147.71    109.57

C B 2021-10-3

编辑：C B 2021-10-3

在 MATLAB Online 中打开

data = [      9     147.67    109.11
   146.81    108.52
   147.09     109.7
   147.81    109.35
   146.17    134.42
   147.73    109.46
   146.48    134.05
   147.83    109.26
    147.3    134.25
    126.5       146
   147.67    108.63
      147    134.04
    126.5       146
   147.93    108.87
   147.25    133.95
    125.5     146.8
   147.43    108.89
   147.31    133.56
   126.17       147
   147.39    108.81
   147.92    133.75
    126.5       147
   147.32    108.91
   147.92    133.75
    126.5       146
   147.69       109
   147.54    133.38
    126.5       146
   147.71    109.11
   148.14    134.43
    126.5       146
   147.71    109.11
      148     134.5
   126.43    145.71
   147.71    109.11
   147.29    133.71
      106       132
   126.25     145.5
    147.4    109.08
   147.29    133.71
      106       132
    126.4     145.2
   147.03    108.87
   147.33    133.78
    105.5       132
   126.17       145
   147.03    108.87
   147.33    133.78
      106       132
   125.67    144.33
   147.03    108.87
   147.33    133.78
   147.03    108.87
   147.33    133.78
   147.43    109.39
    146.7     133.6
   147.08     109.4
   147.55    133.18
   147.43    109.39
    146.8     133.2
    147.7    109.55
      149       132
   147.92    109.33];
T=table;
T.Area = data(:,1);
T.Centroid = data(:,2:3);
Input1 =[147 109];
Input2 =[148 110];
output = sum(T.Area(((Input2(1)>=T.Centroid(:,1) & T.Centroid(:,1)>=Input1(1))&(Input2(2)>=T.Centroid(:,2) & T.Centroid(:,2)>=Input1(2)))))

mohd akmal masud 2021-10-13

在 MATLAB Online 中打开

yah..

T =
1593×2 table
Area                Centroid         
__________    __________________________
9862e+05    128.24    134.13    72.539
      16       139         1
  36.462    99.308    1.1538
  69.987    156.37    3.2267
      73       229         1
      79       192         1
  85.903    175.84    1.3226
   95.75    128.22     1.575
  95.333    169.38    1.1429
  90.026    119.06    7.0692
  105.71        36         1
     108       145         1
   110.5       146         1
     113       230         1
     115       147         1
     118       148         1
  128.44    174.24    6.4785
     142        86         1
  148.89    229.22         1
  152.11    172.63    8.7867

C B 2021-10-13

in this case there are 2 area what do you want with them 1st one or second or sum?

请先登录，再进行评论。

How to calculate the area in table and certain coordinate

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

采纳的回答

13 个评论
显示 11更早的评论隐藏 11更早的评论

更多回答（0 个）

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

How to calculate the area in table and certain coordinate

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

采纳的回答

13 个评论 显示 11更早的评论隐藏 11更早的评论

更多回答（0 个）

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

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

13 个评论
显示 11更早的评论隐藏 11更早的评论