How to import an image into a csv file using python

Question

Hey there!

Any one know  how to import an image into a csv file using python...I tried a lot using multiple option but doesn't work...plz give me ur suggestions!

Comments

Are you looking at reading an image file or want to write an image into CSV. I am not sure if storing image is CSV is advisable

---

Hey @Bhanu, I want to write an image into CSV.

---

#Useful function

def createFileList(myDir, format='.jpg'):

fileList = []

print(myDir)

for root, dirs, files in os.walk(myDir, topdown=False):

for name in files:

if name.endswith(format):

fullName = os.path.join(root, name)

fileList.append(fullName)

return fileList

# load the original image

myFileList = createFileList('D:/Gen5/Memory_audit/Memory_audit_automation')

for file in myFileList:

print(file)

img_file = Image.open(file)

img_file.show()

    # get original image parameters...

width, height = img_file.size

format = img_file.format

mode = img_file.mode

    # Make image Greyscale

img_grey = img_file.convert('L')

img_grey.save('result.png')

img_grey.show()

    # Save Greyscale values

value = np.asarray(img_grey.getdata(), dtype=np.int).reshape((img_grey.size[1], img_grey.size[0]))

value = value.flatten()

print(value)

with open("img_pixels.csv", 'a') as f:

writer = csv.writer(f)

writer.writerow(value)

Answer 1

I am sure you are aware CSV is plain text.

There's no way to include graphic data unless both the generator and the reader agree on a format, such as base64-encoded PNG.

This still may not be accurate and hence not suggested.

Comments

I completely agree! Unless, you want to transform your image into a csv file as in a numpy array.