How to filter rows in a matrix by specific values ?

2 views (last 30 days)
Hello all,
I have a matrix (2415 X 4): where the first row is the provider, second row is the component offered by this provider, third row is the response time and fourth row is the throughput. Example for the matrix is shown here:
33 91 3.14075497314567 10.4391069138934
71 91 3.36171668503407 11.2205073850638
83 91 4.29069645436403 13.4169751469859
110 91 3.92481038453624 13.6029164421016
111 91 3.56564449958498 12.5979622767888
112 91 3.92702593929893 13.7821476564517
124 94 3.57942708040803 12.8545093997351
138 94 3.44708165327646 17.3501207829139
83 111 3.81486001945104 12.1965426353231
84 111 4.46247233771049 14.6473650489708
108 111 3.12780955285937 13.4351793785538
127 111 4.87910430076851 14.4896824276430
I am trying to find three providers which can provide the same set of components. For example, provider(33) could provide components (91, 94, 111) and provider (84) provides the same set of components. Note that the number of unique providers is 133 but they are not incremental, for example (1, 3, 4, 6...). The number of unique components is 633, which is also not incremental, for instance (1, 5, 33, 40, 4999). They are not incremental, because these are already filtered from a dataset for specific values.
Thanks and any help please ? Because this took me quite some while and till now did not reach any solution.

Answers (0)

Categories

Find more on Statistics and Linear Algebra in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!