How do I turn a link to an image in a Python DataFrame column?

Question

I have the links in the column but I am trying to convert them to images

thumbnails = []
for index,row in pdr.iterrows():
    s = row['videoId']
    thumbnail_url = f"https://i.ytimg.com/vi/{s}/maxresdefault.jpg"
    thumbnails.append(thumbnail_url)
pdr['thumbnail'] = thumbnails

Output:

This is the output. I am trying to fill the 'thumbnail' column with images as opposed to linked text.

While, if you want image data, you can download it and read and parse it into a matrix, and save this matrix as the content of this cell. — Ember Xu, Aug 27 '21 at 02:29

imxitiz · Answer 1 · 2021-08-27T03:18:20.183

Try this:

thumbnails = []
for index,row in pdr.iterrows():
    s = row['videoId']
    thumbnail_url = f"<img src='https://i.ytimg.com/vi/{s}/maxresdefault.jpg' width='100px'>"
    thumbnails.append(thumbnail_url)
pdr['thumbnail'] = thumbnails

We have created the DataFrame, now we have to show it:

from IPython.display import Image, HTML

HTML(df.to_html(escape=False))

This will show you the DataFrame with real image rather then only link.

Learn more from here:

score 0 · Answer 2 · edited Apr 02 '22 at 15:59

0

from IPython.display import Image


Image(url= "http://my_site.com/my_picture.jpg")

edited Apr 02 '22 at 15:59

aaossa

3,763
2
21
34

answered Apr 02 '22 at 05:46

jeffasante

2,549
2
8
8

How do I turn a link to an image in a Python DataFrame column?

2 Answers2