graphics recognition

chroniclard · 27 Feb 2020 at 13:34

Google and stackoverflow.com have the answers to 99% of programming queries.

chroniclard · 27 Feb 2020 at 13:58

Parse the "SourceFolder" for all .png files(might be a different format?) and output 2 column result to excel file ParsedImages.xlsx in same folder.

Filename, distance

Code:

using ClosedXML.Excel;
using System;
using System.Collections.Generic;
using System.Drawing;
using System.IO;
using System.Linq;

namespace ImageProcessor
{
    class Program
    {
        private static string SourceFolder = @"C:\TempPath";

        private class PixelData
        {
            public int x { get; set; }
            public int y { get; set; }
            public Color pixel { get; set; }
        }

        static void Main(string[] args)
        {
            ParseFolder();

        }


        static void ParseFolder()
        {
            DirectoryInfo d = new DirectoryInfo(SourceFolder);
            FileInfo[] Files = d.GetFiles("*.png");
            double distance;
            int row = 1;
            using (var workbook = new XLWorkbook())
            {
                var worksheet = workbook.Worksheets.Add("Parsed Images");

                foreach (FileInfo file in Files)
                {
                    distance = ParseImage(file.Name);
                    worksheet.Cell($"A{row}").Value = file.Name;
                    worksheet.Cell($"B{row}").Value = distance;
                    row++;
                }
                workbook.SaveAs($"{SourceFolder}\\ParsedImages.xlsx");
            }
        }

        static double ParseImage(string fileName)
        {
            double distance;
            List<PixelData> data = new List<PixelData>();

            Bitmap img = new Bitmap($"{SourceFolder}\\{fileName}");
            for (int x = 0; x < img.Width; x++)
            {
                for (int y = 0; y < img.Height; y++)
                {
                    Color pixel = img.GetPixel(x, y);

                    var newDataPoint = new PixelData
                    {
                        x = x,
                        y = y,
                        pixel = pixel
                    };
                    data.Add(newDataPoint);
                }
            }

            var allWhitePixels = data.Where(d => d.pixel.A == 255 && d.pixel.B == 255 && d.pixel.G == 255).OrderBy(d => d.x);
            if (allWhitePixels.Count() > 0)
            {
                Point left = new Point(allWhitePixels.FirstOrDefault().x, allWhitePixels.FirstOrDefault().y);
                Point right = new Point(allWhitePixels.LastOrDefault().x, allWhitePixels.LastOrDefault().y);
                distance = Math.Sqrt(Math.Pow(right.X - left.X, 2) + Math.Pow(right.Y - left.Y, 2));
                Console.WriteLine($"Parsing:{fileName}:distance:{distance}");
            }
            else
            {
                Console.WriteLine($"Parsing Failed:{fileName}");
                distance = 0;
            }

            return distance;
           
        }
    }
}

adolf hamster · 27 Feb 2020 at 14:05

thanks so much man, i'll give this a go and see what it looks like.

sorry for having to be spoon-fed somewhat

touch · 27 Feb 2020 at 14:10

That's a nice solution.
You could maybe make it a little more efficient by not adding the black pixels to the list:

Code:

using ClosedXML.Excel;
using System;
using System.Collections.Generic;
using System.Drawing;
using System.IO;
using System.Linq;

namespace ImageProcessor
{
   class Program
    {
        private static string SourceFolder = @"C:\TempPath";

        private class PixelData
        {
            public int x { get; set; }
            public int y { get; set; }
        }

        static void Main(string[] args)
        {
            ParseFolder();
        }

        static void ParseFolder()
        {
            DirectoryInfo d = new DirectoryInfo(SourceFolder);
            FileInfo[] Files = d.GetFiles("*.png");
            double distance;
            int row = 1;
            using (var workbook = new XLWorkbook())
            {
                var worksheet = workbook.Worksheets.Add("Parsed Images");

                foreach (FileInfo file in Files)
                {
                    distance = ParseImage(file.Name);
                    worksheet.Cell($"A{row}").Value = file.Name;
                    worksheet.Cell($"B{row}").Value = distance;
                    row++;
                }
                workbook.SaveAs($"{SourceFolder}\\ParsedImages.xlsx");
            }
        }

        static double ParseImage(string fileName)
        {
            double distance;
            List<PixelData> data = new List<PixelData>();

            Bitmap img = new Bitmap($"{SourceFolder}\\{fileName}");
            for (int x = 0; x < img.Width; x++)
            {
                for (int y = 0; y < img.Height; y++)
                {
                    Color pixel = img.GetPixel(x, y);
                    if(pixel.A == 255 && pixel.B == 255 && pixel.G == 255)
                    {
                       var newDataPoint = new PixelData
                       {
                           x = x,
                           y = y
                       };
                       data.Add(newDataPoint);
                    }
                }
            }

            var allWhitePixels = data.OrderBy(d => d.x);
            if (allWhitePixels.Count() > 0)
            {
                Point left = new Point(allWhitePixels.FirstOrDefault().x, allWhitePixels.FirstOrDefault().y);
                Point right = new Point(allWhitePixels.LastOrDefault().x, allWhitePixels.LastOrDefault().y);
                distance = Math.Sqrt(Math.Pow(right.X - left.X, 2) + Math.Pow(right.Y - left.Y, 2));
                Console.WriteLine($"Parsing:{fileName}:distance:{distance}");
            }
            else
            {
                Console.WriteLine($"Parsing Failed:{fileName}");
                distance = 0;
            }

            return distance;
           
        }
    }
}

chroniclard · 27 Feb 2020 at 14:12

Yeah I left them in in case I wanted to use them but didnt in the end.

Could use a load more images to actually test properly but I expect you could filter out any extreme anomalies in excel anyway.

adolf hamster · 27 Feb 2020 at 14:29

chroniclard said:
Yeah I left them in in case I wanted to use them but didnt in the end.

Could use a load more images to actually test properly but I expect you could filter out any extreme anomalies in excel anyway.

how many you need? i have thousands

the single one i posted is the crack at full opening but the progression goes from a black screen with nothing through to that:

thats ~every 1k images in a series of 4000.

the crack does jump inside the space of a frame, but hopefully that should line up nicely with the load data from the machine (both the camera and the machine were running the same sampling rate)

fortunately these are very rough samples so i can figure out this analysis before using my good peices, so i should hopefully will be able to tweak the sample preperation and camera settings to get some better images.

chroniclard · 27 Feb 2020 at 14:32

6vuZR6T.png 0
N1IZXW9.png 38.20995
Wnb2ALb.png 114.3547
a9DYf83.png 572.0428

Is spot on from those 4 samples at least.

adolf hamster · 27 Feb 2020 at 14:58

chroniclard said:
6vuZR6T.png 0
N1IZXW9.png 38.20995
Wnb2ALb.png 114.3547
a9DYf83.png 572.0428

Is spot on from those 4 samples at least.

good to know.

i'm currently running it on the full batch, seems to be doing fine at the moment.

currently pretty excited to see how it turns out (yes i'm a massive nerd

)

edit:

came out beautifully, there's a lot of noise in the chart but that's to be expected as the camera is barely picking up the crack edge but it seems to be doing exactly what the doctor ordered:

should be able to do a bit of smoothing on that, and some better image capture for future runs.

many thanks guys, this has been a great help!

adolf hamster · 13 Oct 2020 at 15:28

so bit of an update to this.

for some reason it seems it doesn't want to run the code any more.

after some messing around i figured out how to fix the missing closedxml reference by installing the nuget closedxml add-in.

but now it's coming up with:

Code:

Error    CS0246    The type or namespace name 'Color' could not be found (are you missing a using directive or an assembly reference?)    ConsoleApp8    C:\Users\wmose\source\repos\ConsoleApp8\Program.cs    18    N/A

any idea what's up?

chroniclard · 13 Oct 2020 at 15:37

"Color" should be in the System.Drawing name space, make sure "using System.Drawing;" is still at the top?

adolf hamster · 13 Oct 2020 at 15:56

system.drawing; is still at the top but it's greyed out along with system.linq; and system;

chroniclard · 14 Oct 2020 at 09:49

adolf hamster said:
system.drawing; is still at the top but it's greyed out along with system.linq; and system;

Post up the whole class.

Greyed out means its not being referenced/not used.

adolf hamster · 14 Oct 2020 at 13:53

ok, so the process as i've been doing so far:

new project in console app.net framework using default settings

paste code

under references- manage nuget packages, search closedxml and install the first one on the list:

which after running build solution gives me this:

chroniclard · 14 Oct 2020 at 14:12

All I did was create new console app but used ".net core", paste code, add closedxml.

Something conflicting I guess.

adolf hamster · 14 Oct 2020 at 14:21

ok

so running the same setup process as before, only changing to the .net core console app yeilds a new error:

chroniclard · 14 Oct 2020 at 14:35

Have you got all the code there. Says "Distance" declared but not used, which is not correct.

static double ParseImage(string fileName)
{
double distance;
List<PixelData> data = new List<PixelData>();

Bitmap img = new Bitmap($"{SourceFolder}\\{fileName}");
for (int x = 0; x < img.Width; x++)
{
for (int y = 0; y < img.Height; y++)
{
Color pixel = img.GetPixel(x, y);

var newDataPoint = new PixelData
{
x = x,
y = y,
pixel = pixel
};
data.Add(newDataPoint);
}
}

var allWhitePixels = data.Where(d => d.pixel.A == 255 && d.pixel.B == 255 && d.pixel.G == 255).OrderBy(d => d.x);
if (allWhitePixels.Count() > 0)
{
Point left = new Point(allWhitePixels.FirstOrDefault().x, allWhitePixels.FirstOrDefault().y);
Point right = new Point(allWhitePixels.LastOrDefault().x, allWhitePixels.LastOrDefault().y);
distance = Math.Sqrt(Math.Pow(right.X - left.X, 2) + Math.Pow(right.Y - left.Y, 2));
Console.WriteLine($"Parsing:{fileName}:distance:{distance}");
}
else
{
Console.WriteLine($"Parsing Failed:{fileName}");
distance = 0;
}

return distance;

}

adolf hamster · 14 Oct 2020 at 16:39

you are indeed correct, apprently a chunk was missing. that's cleared up the errors.

when running it came up with "code exited with code 0" which i *think* is because the folder's images were .bmp rather than .png.

tried changing the format to .bmp and now it's doing something. saying parsing failed for the early images which i'm guessing is because they contain no white pixels.

chroniclard · 14 Oct 2020 at 16:41

Should work with .bmp needs to be black and white for that code. If there is no crack at all you could just return 0 as a data point?

adolf hamster · 14 Oct 2020 at 16:52

yeah it seems to be running fine with .bmp's, the output is pure black and white.

it seems to return 0 for the failed data points with no crack, which is perfect.

now all i need to do is run it on all the folders.