Pandas / IPython Notebook: Include and display an Image in a dataframe

Question

I have a pandas Dataframe which also has a column with a filename of an image. How can I display the image inside of the DataFrame?

I tried the following:

import pandas as pd
from IPython.display import Image

df = pd.DataFrame(['./image01.png', './image02.png'], columns = ['Image'])

df['Image'] = Image(df['Image'])

But when I show the frame, each column only shows the to_string representation of the Image Object.

    Image
0   IPython.core.display.Image object
1   IPython.core.display.Image object

Is there any solution for this?

Thanks for your help.

Kirill Bulygin · Accepted Answer · 2023-05-23 08:30:04Z

16

Instead of inserting the html code into the dataframe, I suggest to use a formatter. Unfortunately you need to set the truncation settings, so long text doesn't get truncated with "...".

import pandas as pd
from IPython.display import HTML

df = pd.DataFrame(['./image01.png', './image02.png'], columns=['Image'])

def path_to_image_html(path):
    return '<img src="'+ path + '"/>'

pd.set_option('display.max_colwidth', -1)

HTML(df.to_html(escape=False, formatters={'Image': path_to_image_html}))

edited May 23, 2023 at 8:30

Kirill Bulygin

3,8561 gold badge20 silver badges23 bronze badges

answered May 13, 2017 at 17:03

Fabian Hertwig

1,14313 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Regenschein · Accepted Answer · 2016-05-21 17:33:51Z

10

The solution I found is to not use the IPython.display Image, but to use the IPython.display HTML and the to_html(escape=False) feature of a dataframe.

Altogether, it looks like this:

import pandas as pd
from IPython.display import Image, HTML

df = pd.DataFrame(['<img src="image01.png"/>', './image02.png'], columns = ['Image'])

HTML(df.to_html(escape=False))

answered May 21, 2016 at 17:33

Regenschein

1,5021 gold badge13 silver badges26 bronze badges

Comments

Darius · Accepted Answer · 2025-04-22 06:22:20Z

0

A few times in the past I needed the ability to render elements in dataframes. Because of that I developed the package pandas-render. I'm the developer of this package and want to share this alternative approach.

Install the package with: pip install pandas-render

Create and render the dataframe:

from pandas_render import pandas as pd

df = pd.DataFrame(['./image01.png', './image02.png'], columns=['Image'])

df.render({"Image": '<img src="{{ content }}"/>'}, n=5)

The parameter n allows to display n elements in a row. The result is a compact gallery of images.

edited Apr 22 at 6:22

answered Apr 21 at 19:49

Darius

12.4k2 gold badges33 silver badges51 bronze badges

Comments

piRSquared · Accepted Answer · 2016-05-21 17:57:11Z

-1

I think you are misunderstanding what gets stored in a dataframe and confusing it with how it's displayed. In order to show an image in the html table representation you'd have to write your own function to insert an image tag in the html table cell.

edited May 21, 2016 at 17:57

answered May 21, 2016 at 17:23

piRSquared

296k68 gold badges509 silver badges654 bronze badges

Collectives™ on Stack Overflow

Pandas / IPython Notebook: Include and display an Image in a dataframe

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related