How do i retrieve image based on its value in an excel file?
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Dear Experiences...
i have an excel file.. in the following directory (D:\image_table).. where in this table there 100 x 100 matrix value look like the following, where the values refer to the degree of similarity among images (0..1), and images are store in folder (D:\images).. images names are (A1...A100).
A1 A2 A3 A4 A5 A6 .... A100
A1 1.0 0.25 0.33 ....
A2 0.25 1.0 ..................
A3
A4
..
..
A100
so, i need to retrieve all images names that satisfy condition like similarity>0.50 and also view all images from D:\images folder in category that match images names.. perhaps images name view as table.. thanks
excel file..
2 Kommentare
Image Analyst
am 24 Jul. 2017
Bearbeitet: Image Analyst
am 24 Jul. 2017
Where are the image names stored? Are they the row and column headers? Can you attach the workbook?
Antworten (1)
Image Analyst
am 25 Jul. 2017
Try this:
[rows, columns] = find(similarityMatrix > 0.5);
for k = 1 : length(rows)
fprintf('%s and %s have a similarity of %f.\n', ...
filenames(rows(k)), filenames(columns(k)), ...
similarityMatrix(rows(k), columns(k));
end
7 Kommentare
Image Analyst
am 26 Jul. 2017
Let's say you have a random smattering of values in the array that are more than 0.5, so you have a bunch of image pairs. I'm not sure what you want. Do you want a wide image with the pair of images stitched side-by-side? Or above and below? Or something else? So if you had 5 numbers, you'd have 5 stitched image pairs? Please try to explain better. Attaching a desired output image would also be great.
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!