How to change bytes of array into image?

I have a csv file, which was extracted from MS SQL database with image column included. My task is to convert the contents of each row in image column into image and save it as image file.

Here is the content of a row-

https://drive.google.com/open?id=1J_jz5vN8ATxJ5Qw_c8l0qqKFrIee8kHF

As the contents length exceeds the limited word count, I uploaded it to google drive.

I changed it to bytearray and try to write it to new file and read it as an image but I haven't got the image.

https://drive.google.com/open?id=1h-7cRiTWErZzmMJYmc6XmLmeLK982WZR

How could I convert that bytearray to the image?? I have tried writing it to new file and reading it with io. I have spent 8+ hours on this and have tried every solutions found on stackoverflow. Please help me find the solution.

Here is my code -

df = (pd.Series(df['image']))
df = df.dropna()

x = df[3]
print (x)
bytes = base64.b64decode(x)
print (bytes)
image = open("new.jpeg","wb")
image.write(bytearray(bytes))
image.close()


1 Answer
1

The row is in hexadecimal format. You can strip the leading 0x and then convert to bytes with

0x

import codecs
data = codecs.decode(x[2:], 'hex')


Or, equivalently, with

data = bytes.fromhex(x[2:])


(Hexadecimal is such a common format that bytes has an alternate constructor for it.)

bytes

Then imghdr reports it's a jpeg.

imghdr

import imghdr
print(imghdr.what(None, h=data))


If you save those bytes in a .jpeg file you should be able to open it.

.jpeg

with open('foo.jpg', 'wb') as foo:
foo.write(data)


By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.