嵌套于两个列表的循环python，以生成列表以进入熊猫数据框表

Question

我有两个列表：soapname和soapprices，每个包含16个元素：

soapname

[{'title': 'Beer and Honey Shampoo bar'},
 {'title': 'Cedarwood Shaving Soap'},
 {'title': 'Chamomile and Lavender Shampoo and Body Bar'}...]

soapprices

[{'price': 6.0},
 {'price': 5.0},
 {'price': 5.0}...]

我想以以下格式创建一个表，以便我可以将其插入 pandas dataframe表：

{'title': 'Beer and Honey Shampoo bar', 'price': 6.0}
{'title': 'Cedarwood Shaving Soap', 'price': 5.0}
{'title': 'Chamomile and Lavender Shampoo and Body Bar', 'price': 5.0}....

到目前为止我使用 BeautifulSoup 返回第一原则，以刮擦数据并尝试执行嵌套循环：

all_soap = []

soapinformation = soup.find_all("h1", class_= "product_title entry-title elementor-heading-title elementor-size-default")

for soap in soapinformation:
    soapTitle = soap.find("a").text
    soapInfo = {"title" : soapTitle, "price" : price3[0-17]}
    print(soapInfo)

输出是：

{'title': 'Beer and Honey Shampoo bar', 'price': '6.00'}
{'title': 'Cedarwood Shaving Soap', 'price': '6.00'}
{'title': 'Chamomile and Lavender Shampoo and Body Bar', 'price': '6.00'}....

我不确定如何迭代价格数据。

Answer 1

Zip 名称和价格，然后为每对名称和价格创建一个新的dact：

[{**name, **price} for name, price in zip(names, prices)]

#[{'title': 'Beer and Honey Shampoo bar', 'price': 6.0}, 
# {'title': 'Cedarwood Shaving Soap', 'price': 5.0}, 
# {'title': 'Chamomile and Lavender Shampoo and Body Bar', 'price': 5.0}]

Answer 2

除了回答@PSIDOM - 尝试避免使用一堆列表，因为如果没有元素，您只能在困难中控制长度。

更改收集数据的策略，您可以一口气获得信息。

for e in soup.select('article'):
    data.append({
        'title':e.h1.text,
        'price':e.bdi.span.next_sibling,
        'url':e.a.get('href')
    })

示例

import pandas as pd
from bs4 import BeautifulSoup
import requests

url = 'https://ratherlather.co.uk/shop/'
req = requests.get(url)

soup = BeautifulSoup(req.content)
data = []
for e in soup.select('article'):
    data.append({
        'title':e.h1.text,
        'price':e.bdi.span.next_sibling,
        'url':e.a.get('href')
    })

pd.DataFrame(data)

输出

标题	价格	URL
啤酒和蜂蜜洗发水条	6.00	https：// stylather.co.uk/shop/beer-and-honey-shampoo-bar/
Cedarwood剃须肥皂	5.00	https://ratherlather.co.uk/shop/shop/cedarwood-shaving-shaving-soap/
洋甘菊和薰衣草洗发水和身体棒	5.00	https://ratherlather.co.uk/shop/shop/chamomile - 和lavender-shampoo-and-body-bar/
fir针，薄荷洗发水和身体棒	5.00	https://ratherlather.co.uk/shop /fir-deedle and mint-shampoo and-body-bar/
薄荷巧克力脸和身体棒	5.00	https：//ratherlather.co.uk/shop/shop/mint-chocelice -face-and-Body-bar/
薄荷巧克力脸和身体Bar-纯素食	5.00	https://ratherlather.co.uk/shop/mint - 巧克力 - 面棒式素食/
橙色和蜂蜜洗发水和身体棒	5.00	https://ratherlather.co.uk/shop/orange - honey-shampoo and-body-bar/
迷迭香，柠檬草和薰衣草脸和身体棒	5.00
身体黄油 - 黄油up＆amp;定居	7.00	https://ratherlather.co.uk/商店/身体燃料 - 燃料固定/

...