MATLAB: Retrieving data and plotting it

datamininggraphs

I have 100*10 rows and column of data
col1 col2 A A A B B B C C
1 2 0.2 .3 .2 .1 .2 .69 .87 .8
2 3 0.2 0.8 .7 .5 .6 .9 .5 .8
2 4 0.2 .3 .2 .1 .2 .69 .87 .8
5 8 0.2 0.8 .7 .5 .6 .9 .5 .8
from this data i have found the highest accuracy for the for unique values in col1 and have plotted
the res for ex is
col1 clo2 acc
1 2 94
2 4 95
now for this data i have to find corresponging values from first data such as
col1 clo2 acc A A A B B B C C
1 2 94 0.2 .3 .2 .1 .2 .69 .87 .8
2 4 95 0.2 .3 .2 .1 .2 .69 .87 .8
FROM THIS DATA I WANT TO PLOT K MEANS,is it possible

Best Answer

  • d = [ 1 2 0.2 .3 .2 .1 .2 .69 .87 .8
    2 3 0.2 0.8 .7 .5 .6 .9 .5 .8
    2 4 0.2 .3 .2 .1 .2 .69 .87 .8
    5 8 0.2 0.8 .7 .5 .6 .9 .5 .8]
    d1 = [ 1 2 94
    2 4 95]
    out = [d1, d(ismember(d(:,1:2),d1(:,1:2),'rows'),3:end)]