从url读取图像，并将其放在数据框架列上，并在python中标记为另一列

Question

我想从url读取图像并将它们放在pandas数据框架列上，并将标签放置到另一个列上。我该怎么做呢，请帮帮我。下面是我读取的文件中的数据帧。有4个url页面与4个标签。但我必须排除。svg图像，因为它不显示任何图片。
所以最后的结果将是ondf ={"图像":…,"标签":["图标","图标","图标")}谢谢你

import pandas as pd
data={'image_url':['https://www.philips.com/c-dam/b2c/en_US/experience/sound-and- 
vision/headphones/fidelio-l3/L3_38_hr_88x88.png'
,'https://www.philips.com/c-dam/b2c/tv/categorypage/us/AndroidTVLP/HDR.png'
,'https://www.philips.com/c-dam/b2c/category-pages/sound-and- 
vision/headphones/master/homepage/awaraness-mode-anc.png'],
,'https://https://www.philips.com/c-dam/b2c/master/experience/pe/shavers/360-d.svg'
'label':['icon','icon','icon','icon']}
df=pd.DataFrame(data)
#Below is what I tried so far with no success 
img=[]
image=df['image_url']
for i in image:
if not i.endswith('.svg'):
response = requests.get(i)
img1 = Image.open(BytesIO(response.content))
img.extend(img1)

Answer 1

这是你要找的吗?

img = []
image = df['image_url']
for i in image:
if not i.endswith('.svg'):
response = requests.get(i)
img1 = Image.open(BytesIO(response.content))
img.extend([img1])
else:
img.extend([None])
df['image'] = pd.DataFrame(img)