How to put loop result in csv file

[Doni FInn]

i've done got my outputs for the csv file, but i dont know how to write it into csv file `
`` def find_mode(np_array) :
vals,counts = np.unique(np_array, return_counts=True)
index = np.argmax(counts)
return(vals[index])
folder = ("C:/Users/ROG FLOW/Desktop/Untuk SIDANG TA/Sudah Aman/testbikincsv/folderdatacitra/*.jpg")
for file in glob.glob(folder):
a = cv2.imread(file)
rows = a.shape[0]
cols = a.shape[1]
middlex = cols/2
middley = rows/2
middle = [middlex,middley]
titikawalx = middlex - 10
titikawaly = middley - 10
titikakhirx = middlex + 10
titikakhiry = middley + 10
crop = a[int(titikawaly):int(titikakhiry), int(titikawalx):int(titikakhirx)]
c = cv2.cvtColor(crop, cv2.COLOR_BGR2HSV)
H,S,V = cv2.split(c)
hsv_split = np.concatenate((H,S,V),axis=1)
Modus_citra = (find_mode(H)) ```
my outputs is modus citra, im trying to put it on csv file but im still confused how to write it into csv because the output inside a loop. Can someone help me how to write it into csv file ? i appreciate every help

 

[Kuncode]

i've done got my outputs for the csv file, but i dont know how to write it into csv file `
`` def find_mode(np_array) :
vals,counts = np.unique(np_array, return_counts=True)
index = np.argmax(counts)
return(vals[index])
folder = ("C:/Users/ROG FLOW/Desktop/Untuk SIDANG TA/Sudah Aman/testbikincsv/folderdatacitra/*.jpg")
for file in glob.glob(folder):
a = cv2.imread(file)
rows = a.shape[0]
cols = a.shape[1]
middlex = cols/2
middley = rows/2
middle = [middlex,middley]
titikawalx = middlex - 10
titikawaly = middley - 10
titikakhirx = middlex + 10
titikakhiry = middley + 10
crop = a[int(titikawaly):int(titikakhiry), int(titikawalx):int(titikakhirx)]
c = cv2.cvtColor(crop, cv2.COLOR_BGR2HSV)
H,S,V = cv2.split(c)
hsv_split = np.concatenate((H,S,V),axis=1)
Modus_citra = (find_mode(H)) ```
my outputs is modus citra, im trying to put it on csv file but im still confused how to write it into csv because the output inside a loop. Can someone help me how to write it into csv file ? i appreciate every help

You can use the csv module to write the results of the find_mode function to a CSV file.

Here a nice python script for it :

import csv

def find_mode(np_array) :
    vals,counts = np.unique(np_array, return_counts=True)
    index = np.argmax(counts)
    return(vals[index])

folder = ("C:/Users/ROG FLOW/Desktop/Untuk SIDANG TA/Sudah Aman/testbikincsv/folderdatacitra/*.jpg")

# Create a new CSV file or overwrite if it already exists
with open('modus_citra.csv', 'w', newline='') as file:
    writer = csv.writer(file)
    # Write the header row
    writer.writerow(["Filename", "Modus Citra"])
    for file in glob.glob(folder):
        a = cv2.imread(file)
        rows = a.shape[0]
        cols = a.shape[1]
        middlex = cols/2
        middley = rows/2
        middle = [middlex,middley]
        titikawalx = middlex - 10
        titikawaly = middley - 10
        titikakhirx = middlex + 10
        titikakhiry = middley + 10
        crop = a[int(titikawaly):int(titikakhiry), int(titikawalx):int(titikakhirx)]
        c = cv2.cvtColor(crop, cv2.COLOR_BGR2HSV)
        H,S,V = cv2.split(c)
        hsv_split = np.concatenate((H,S,V),axis=1)
        modus_citra = find_mode(H)
        # Write a row for each file
        writer.writerow([file, modus_citra])