Save image properties to CSV using Python

Last Updated : 03 Jan, 2023

In this article, we are going to write python scripts to find the height, width, no. of channels in a given image file and save it into CSV format. Below is the implementation for the same using Python3. The prerequisite of this topic is that you have already installed NumPy and OpenCV.

Approach:

First, we will load the required libraries into the python file ( NumPy, OpenCV, etc.).
Create an empty CSV file with the column name only if there is no existing CSV file( Height, Width, Channels, colors, etc.). If the file data.csv does not exist then a new file will be created by the else statement.
Now we will use argparse() function to get the directory path of the images from the user in the command line.
Find the color properties using CV2.
We will be using image.shape function to find out the Height, Width, Channels of the image.
Then we will calculate the average red, average blue, average green of the image
Then we will write the outputs to the csv file using writerow() function.

Below is the implementation:

Python3

# Required Libraries 
from os import listdir 
from os.path import isfile, join 
from pathlib import Path 
import numpy 
import cv2 
import argparse 
import numpy 
import csv 
  
# Check whether the CSV  
# exists or not if not then create one. 
my_file = Path("csv/details.csv") 
  
if my_file.is_file(): 
    f = open(my_file, "w+") 
    with open('csv/details.csv', 'a', newline='') as file: 
        writer = csv.writer(file) 
          
        writer.writerow(["S.No.", "Name", "Height", 
                         "Width", "Channels", 
                         "Avg Blue", "Avg Red", 
                         "Avg Green"]) 
    f.close() 
    pass
    
else: 
    with open('csv/details.csv', 'w', newline = '') as file: 
        writer = csv.writer(file) 
          
        writer.writerow(["S.No.", "Name", "Height", 
                         "Width", "Channels", 
                         "Avg Blue", "Avg Red", 
                         "Avg Green"]) 
  
# Argparse function to get 
# the path of the image directory 
ap = argparse.ArgumentParser() 
  
ap.add_argument("-i", "--image",  
                required = True,  
                help = "Path to folder") 
  
args = vars(ap.parse_args()) 
  
# Program to find the 
# colors and embed in the CSV 
mypath = args["image"] 
  
onlyfiles = [ f for f in listdir(mypath) if isfile(join(mypath,f)) ] 
images = numpy.empty(len(onlyfiles), dtype = object) 
  
for n in range(0, len(onlyfiles)): 
    
    path = join(mypath,onlyfiles[n]) 
    images[n] = cv2.imread(join(mypath,onlyfiles[n]), 
                           cv2.IMREAD_UNCHANGED) 
      
    img = cv2.imread(path) 
    h,w,c = img.shape 
    print(h, w, c) 
      
    avg_color_per_row = numpy.average(img, axis = 0) 
    avg_color = numpy.average(avg_color_per_row, axis = 0) 
      
    with open('csv/details.csv', 'a', newline = '') as file: 
        writer = csv.writer(file) 
        writer.writerow([n+1, onlyfiles[n], h, w, c,  
                         avg_color[0], avg_color[1], 
                         avg_color[2]]) 
        file.close() 

Output:

Usage:

Save this code-named main.py.
Shift(Key) + Right Click and Click open PowerShell window here.

python3 main.py --image /path/to/images/folder/:

CSV file output:

Generated Csv File

Append to JSON file using Python

idevesh

Improve

Article Tags :

Practice Tags :

python

Save image properties to CSV using Python

Python3

Usage:

Similar Reads