{"id":127931,"date":"2022-09-08T15:23:42","date_gmt":"2022-09-08T15:23:42","guid":{"rendered":"https:\/\/blog.finxter.com\/?p=657549"},"modified":"2022-09-08T15:23:42","modified_gmt":"2022-09-08T15:23:42","slug":"python-convert-image-jpg-png-to-csv","status":"publish","type":"post","link":"https:\/\/sickgaming.net\/blog\/2022\/09\/08\/python-convert-image-jpg-png-to-csv\/","title":{"rendered":"Python Convert Image (JPG, PNG) to CSV"},"content":{"rendered":"\n
\n
\n
\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n
5\/5 – (1 vote) <\/div>\n<\/div>\n

Given an image as a .png<\/code> or .jpeg<\/code> file. How to convert it to a CSV file in Python?<\/p>\n

Example image:<\/p>\n

\"\"<\/figure>\n

Convert the image to a CSV using the following steps:<\/p>\n

    \n
  1. Read the image into a PIL.Image<\/code> object.<\/li>\n
  2. Convert the PIL.Image<\/code> object to a 3D NumPy array with the dimensions rows, columns, and RGB values.<\/li>\n
  3. Convert the 3D NumPy array to a 2D list of lists<\/a> by collapsing the RGB values into a single value (e.g., a string representation).<\/li>\n
  4. Write the 2D list of lists to a CSV<\/a> using normal file I\/O in Python.<\/li>\n<\/ol>\n

    Here’s the code that applies these four steps, assuming the image is stored in a file named 'c++.jpg'<\/code>:<\/p>\n

    \nfrom PIL import Image\nimport numpy as np # 1. Read image\nimg = Image.open('c++.jpg') # 2. Convert image to NumPy array\narr = np.asarray(img)\nprint(arr.shape)\n# (771, 771, 3) # 3. Convert 3D array to 2D list of lists\nlst = []\nfor row in arr: tmp = [] for col in row: tmp.append(str(col)) lst.append(tmp) # 4. Save list of lists to CSV\nwith open('my_file.csv', 'w') as f: for row in lst: f.write(','.join(row) + '\\n')\n<\/pre>\n
    Note that the resulting CSV file looks like this with super long rows.<\/p>\n
    \n
    \"\"<\/figure>\n<\/div>\n
    Each CSV cell (column) value is a representation of the RGB value at that specific pixel. For example, [255 255 255]<\/code> represents the color white at that pixel.<\/p>\n
    \n
    For more information and some background on file I\/O, check out our detailed tutorial on converting a list of lists to a CSV:<\/p>\n
    \"\ud83c\udf0d\" Related Tutorial<\/strong>: How to Convert a List to a CSV File in Python [5 Ways]<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
    5\/5 – (1 vote) Given an image as a .png or .jpeg file. How to convert it to a CSV file in Python? Example image: Convert the image to a CSV using the following steps: Read the image into a PIL.Image object. Convert the PIL.Image object to a 3D NumPy array with the dimensions rows, […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[857],"tags":[73,468,528],"class_list":["post-127931","post","type-post","status-publish","format-standard","hentry","category-python-tut","tag-programming","tag-python","tag-tutorial"],"_links":{"self":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/posts\/127931","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/comments?post=127931"}],"version-history":[{"count":0,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/posts\/127931\/revisions"}],"wp:attachment":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/media?parent=127931"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/categories?post=127931"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/tags?post=127931"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}