将图像添加到 Pandas DataFrame [英] Adding image to pandas DataFrame

问题描述

假设我有一个要导出为 PDF 的 DataFrame.在 DataFrame 中，我有以下列:代码、名称、价格、净值、销售额.每一行都是一个产品.

Suppose I have a DataFrame I want to export to a PDF. In the DataFrame I have the following columns: Code, Name, Price, Net, Sales. Every row is a Product.

我想向该 DataFrame 中的每个产品添加一张我可以使用 BeautifulSoup 获得的图像.有什么方法可以将图像添加到 DataFrame 中?不是链接，只是产品的图片.

I want to add to every product in that DataFrame an image which i could get using BeautifulSoup. Is there some way to add the image to the DataFrame? Not the link, just the image of the product.

更具体地说，我想要这样的东西:

Being more specific i want something like this:

代码:

import pandas as pd
df = pd.DataFrame([['A231', 'Book', 5, 3, 150], 
                   ['M441', 'Magic Staff', 10, 7, 200]],
                   columns = ['Code', 'Name', 'Price', 'Net', 'Sales')

#Suppose this are the links that contains the imagen i want to add to the DataFrame
images = ['Link 1','Link 2'] 

推荐答案

您可能需要对 width 和 height 属性进行一些尝试，但这应该可以帮助您入门.基本上，您只是将图像/链接转换为 html，然后使用 df.to_html 来显示这些标签.请注意，它不会显示您是否在 Spyder 中工作，但是正如您在下面的输出中看到的那样，通过 jupyter notebooks 可以正常工作

You'll probably have to play a bit around with width and height attributes, but this should get you started. Basically, you're just converting the image/links to html, then using the df.to_html to display those tags. Note, it won't show if you're working in Spyder, but as you can see below with my output, works fine through jupyter notebooks

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

df = pd.DataFrame([['A231', 'Book', 5, 3, 150], 
                   ['M441', 'Magic Staff', 10, 7, 200]],
                   columns = ['Code', 'Name', 'Price', 'Net', 'Sales'])

# your images
images1 = ['https://vignette.wikia.nocookie.net/2007scape/images/7/7a/Mage%27s_book_detail.png/revision/latest?cb=20180310083825',
          'https://i.pinimg.com/originals/d9/5c/9b/d95c9ba809aa9dd4cb519a225af40f2b.png'] 


images2 = ['https://static3.srcdn.com/wordpress/wp-content/uploads/2020/07/Quidditch.jpg?q=50&fit=crop&w=960&h=500&dpr=1.5',
           'https://specials-images.forbesimg.com/imageserve/5e160edc9318b800069388e8/960x0.jpg?fit=scale']

df['imageUrls'] = images1
df['otherImageUrls'] = images2


# convert your links to html tags 
def path_to_image_html(path):
    return '<img src="'+ path + '" width="60" >'

pd.set_option('display.max_colwidth', None)

image_cols = ['imageUrls', 'otherImageUrls']  #<- define which columns will be used to convert to html

# Create the dictionariy to be passed as formatters
format_dict = {}
for image_col in image_cols:
    format_dict[image_col] = path_to_image_html


display(HTML(df.to_html(escape=False ,formatters=format_dict)))

然后您可以选择在那里做什么才能转至 pdf.

Then you have some options of what to do there to go to pdf.

您可以另存为 html

You could save as html

df.to_html('test_html.html', escape=False, formatters=format_dict)

然后简单地使用和 html 到 pdf 转换器这里，或使用诸如 pdfkit 或 WeasyPrint一>.我对这些并不完全熟悉(很久以前我只使用过其中一个)，但这里有一个很好的 link

then simply use and html to pdf converter here, or use a library such as pdfkit or WeasyPrint. I'm not entirely familiar with those (I only used one of them once a long time ago), but here's a good link

祝你好运.

这篇关于将图像添加到 Pandas DataFrame的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！