MATLAB Answers

0

calculate area in table

Asked by nur afiqah on 22 Jul 2019
Latest activity Commented on by Andrei Bobrov
on 23 Jul 2019
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
 Accepted Answer

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

  2 Comments

nur afiqah on 23 Jul 2019
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
T = readtable('Book2.xlsx');
out = varfun(@sum,T,'g',{'Class_Name','distance'});

Sign in to comment.


KSSV
Answer by KSSV
on 22 Jul 2019

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.