MATLAB Answers

0

calculate area in table

Asked by nur afiqah on 22 Jul 2019 at 8:20
Latest activity Commented on by Andrei Bobrov
on 23 Jul 2019 at 9:11
Greetings,
I have a 32 variables containing 1000++ rows and a column containing area for each row. Can Matlab read and call a certain variable in the row and calculate area based on selected variable?

  0 Comments

Sign in to comment.

2 Answers

Andrei Bobrov
Answer by Andrei Bobrov
on 22 Jul 2019 at 8:48
 Accepted Answer

T = readtable('Book1.xlsx');
out = varfun(@sum,T,'g','Class_Name');

  2 Comments

nur afiqah on 23 Jul 2019 at 7:03
Thank you for the answer, I've reffered to the function varfun and managed to get the answer.
What if we have multiple argument? (e.g.: total area for each class at specific distance provided) I attached the file for your perusal.
Your answer is very much appeciated!
Andrei Bobrov
on 23 Jul 2019 at 9:11
T = readtable('Book2.xlsx');
out = varfun(@sum,T,'g',{'Class_Name','distance'});

Sign in to comment.


KSSV
Answer by KSSV
on 22 Jul 2019 at 8:27

Load the data from excel file using xlsread or readtable. Once you have data in workspace......you can get your desired result using some functions and indexing.

  0 Comments

Sign in to comment.