Info

This question is closed. Reopen it to edit or answer.

Fltering to subsets of matrices

1 view (last 30 days)
David
David on 4 May 2012
Closed: MATLAB Answer Bot on 20 Aug 2021
both Excel and Sql can 'query' and run functions on subsets of data based on common lable fields (e.g. return all sales in GA)
sum if 'GA' or count if 'GA'
Does Matlab have similare functionality?
  1 Comment
Sean de Wolski
Sean de Wolski on 4 May 2012
Please provide a small example (inputs/ops/expected outputs).

Answers (1)

per isakson
per isakson on 4 May 2012
Yes!
sum( MyData( strcmp( MyData( :, ixColumn ), 'GA' ), : ), 1 )
This question is very close to Summing values with database "group by" functionality. It is a better tactic to provide a toy example than repeating the question! Didn't the answers to you other question help you?
  2 Comments
David
David on 22 May 2012
Sorry, but I was not successful using the previous answer and I assumed it was because of the way I framed my question - which is why I tried to improve my question.
per isakson
per isakson on 22 May 2012
Does your code work now?

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!