How to separate data sets/clusters that got saved in a single data file?

Question

Raju Kumar 2023-5-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1965324-how-to-separate-data-sets-clusters-that-got-saved-in-a-single-data-file

评论： Cris LaPierre 2023-5-19

Image1.png

I have this follwing data. Col 1: Vertical Pixels, Col 2: Horizontal Pixels, Col 3: Index of 256x256 pixels, Col 4: Data 1, Col 5: Data 2. When I plot Col 3 and Col 5 (as shown in the figure) using 'imagesc', there appear two seprate clusters each containing a part of values from Col 5. My question is how do I extract the data or columns correponding to each cluster without visualizing it. Any leads will be highly appreciated. Many thanks.

9 77 19464 410575406 13

15 73 18446 410575406 11

17 74 18704 410575406 12

12 77 19467 410575406 17

9 76 19208 410575408 1

16 74 18703 410575406 13

11 77 19466 410575406 31

10 77 19465 410575406 21

16 73 18447 410575406 34

15 74 18702 410575406 80

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Cris LaPierre 2023-5-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1965324-how-to-separate-data-sets-clusters-that-got-saved-in-a-single-data-file#answer_1237174

在 MATLAB Online 中打开

kmeans clustering algorithm?

data = [9 77 19464 410575406 13

15 73 18446 410575406 11

17 74 18704 410575406 12

12 77 19467 410575406 17

9 76 19208 410575408 1

16 74 18703 410575406 13

11 77 19466 410575406 31

10 77 19465 410575406 21

16 73 18447 410575406 34

15 74 18702 410575406 80]

data = 10×5

9 77 19464 410575406 13 15 73 18446 410575406 11 17 74 18704 410575406 12 12 77 19467 410575406 17 9 76 19208 410575408 1 16 74 18703 410575406 13 11 77 19466 410575406 31 10 77 19465 410575406 21 16 73 18447 410575406 34 15 74 18702 410575406 80

img = zeros(256);

img(data(:,3)) = data(:,5);

imagesc(img)

xlim([68 82])

ylim([7 20])

idx = kmeans(data(:,1:2),2);

figure

gscatter(data(:,2),data(:,1),idx)

axis image

axis ij

xlim([68 82])

ylim([7 20])

4 个评论
显示 2更早的评论隐藏 2更早的评论

Raju Kumar 2023-5-19

@Cris LaPierre Thanks but this finds more k even when there should not be any. I have found a way by applying logical thoughts looking at the data. But I appreciate your answers.

Cris LaPierre 2023-5-19

Without having the actual data, it's hard to say for certain what would work. You have something working, wich is great. My next thought would be to look into some image processing techinques, like blob analysis perhaps?

请先登录，再进行评论。