python - 从网页上抓取 2 个不同格式的表格 - Beautiful Soup
问题描述
因此,我的目标是在对许可证代码列表进行迭代之后从网站上抓取 2 个表格(以不同格式) - FSC 公共搜索。我的问题是,因为我想要的两个表 Product Data 和 Certificate Data 有两种不同的格式,所以我必须分别抓取它们。例如,网页上的产品数据是正常"tr"
格式,而证书数据是"div"
格式。
根据我之前提出的问题,我几乎解决了我的问题,并且可以在一系列许可证代码中完全检索证书数据(“div”表单)。但是,我无法按我的意愿输出产品数据表。它没有显示 5 个许可证代码的产品数据,而是显示了第一个许可证代码的 5 个副本。我已经尝试将此抓取放在定义的函数 get_data_by_code 中,但我仍然无法以我想要的格式获取它,这只是 CSV 文件中的一个表。
基本上我不确定在我的函数/脚本中包含这个抓取的位置,所以任何输入都会非常感谢,谢谢。
df3 = pd.DataFrame()
df = pd.read_csv("MS_License_Codes.csv")
codes = df["License Code"]
data = [
('code', code),
('submit', 'Search'),
]
response = requests.post('https://info.fsc.org/certificate.php', data=data)
soup = BeautifulSoup(response.content, 'lxml')
def get_data_by_code(code):
data = [
('code', code),
('submit', 'Search'),
]
response = requests.post('https://info.fsc.org/certificate.php', data=data)
soup = BeautifulSoup(response.content, 'lxml')
#scraping the certificate data
status = soup.find_all("label", string="Status")[0].find_next_sibling('div').text
first_issue_date = soup.find_all("label", string="First Issue Date")[0].find_next_sibling('div').text
last_issue_date = soup.find_all("label", string="Last Issue Date")[0].find_next_sibling('div').text
expiry_date = soup.find_all("label", string="Expiry Date")[0].find_next_sibling('div').text
standard = soup.find_all("label", string="Standard")[0].find_next_sibling('div').text
return [code, status, first_issue_date, last_issue_date, expiry_date, standard]
# Just insert here output filename and codes to parse...
OUTPUT_FILE_NAME = 'Certificate_Data.csv'
df3 = pd.DataFrame()
with open(OUTPUT_FILE_NAME, 'w') as f:
writer = csv.writer(f)
for code in codes:
print('Getting code# {}'.format(code))
writer.writerow((get_data_by_code(code)))
##attempting to scrape the product data
table = soup.find_all('table')[0]
df1, = pd.read_html(str(table))
df3 = df3.append(df1)
df3.to_csv('Product_Data.csv', index = False, encoding='utf-8')
编辑
因此,使用下面的代码,我得到了最后一个许可证代码的产品数据的 5 个副本.. 稍微接近了一点,但我仍然不明白为什么会这样
df3 = pd.DataFrame()
for code in codes:
print('Getting code# {}'.format(code))
response = requests.post('https://info.fsc.org/certificate.php', data=data)
soup = BeautifulSoup(response.content, 'lxml')
table = soup.find_all('table')[0]
df1, = pd.read_html(str(table))
df3 = df3.append(df1)
df3.to_csv('Product_Data.csv', index = False, encoding='utf-8')
编辑 2
我一直在使用的示例代码:
codes = ['FSC-C001777', 'FSC-C124838' ,'FSC-C068163','FSC-C101537','FSC-C005776']
格式编辑
这是正确的表格格式,但是如您所见,它是来自第一个许可证代码的信息重复 5 次,而不是唯一数据。
解决方案
对于codes
您提供的,这种简化的方法就足够了。它只是直接从 BeautifulSoup 中提取必要的信息,而不需要使用 Pandas 来尝试提取它:
from bs4 import BeautifulSoup
import requests
import csv
fieldnames_cert = ['Code', 'Status', 'First Issue Date', 'Last Issue Date', 'Expiry Date', 'Standard']
fieldnames_prod = ['Code', 'Product Type', 'Trade Name', 'Species', 'Primary Activity', 'Secondary Activity', 'Main Output Category']
codes = ['FSC-C001777', 'FSC-C124838', 'FSC-C068163', 'FSC-C101537', 'FSC-C005776']
with open('Certificate_Data.csv', 'wb') as f_output_cert, \
open('Product_Data.csv', 'wb') as f_output_prod:
csv_output_cert = csv.writer(f_output_cert)
csv_output_cert.writerow(fieldnames_cert)
csv_output_prod = csv.writer(f_output_prod)
csv_output_prod.writerow(fieldnames_prod)
for code in codes:
print('Getting code# {}'.format(code))
response = requests.post('https://info.fsc.org/certificate.php', data={'code' : code, 'submit' : 'Search'})
soup = BeautifulSoup(response.content, 'lxml')
# Extract the certificate data
div_cert = soup.find('div', class_='certificatecl')
csv_output_cert.writerow([code] + [div.text for div in div_cert.find_all('div')])
# Extract the product data
table = soup.find('h2', id='products').find_next_sibling('table')
for tr in table.find_all('tr')[1:]:
row = [td.get_text(strip=True).encode('utf-8') for td in tr.find_all('td')]
csv_output_prod.writerow([code] + row)
这将产生Certificate_Data.csv
包含:
Code,Status,First Issue Date,Last Issue Date,Expiry Date,Standard
FSC-C001777,Valid,2009-04-01,2018-02-16,2019-04-01,FSC-STD-40-004 V3-0
FSC-C124838,Valid,2015-03-23,2015-03-23,2020-03-22,FSC-STD-40-004 V3-0
FSC-C068163,Valid,2010-03-01,2017-08-23,2022-08-22,FSC-STD-40-003 V2-1;FSC-STD-40-004 V3-0
FSC-C101537,Valid,2010-10-01,2013-11-28,2018-11-27,FSC-STD-40-003 V2-1;FSC-STD-40-004 V3-0
FSC-C005776,Valid,2007-07-17,2017-07-17,2022-07-16,FSC-STD-40-004 V3-0
并产生Product_Data.csv
含有:
Code,Product Type,Trade Name,Species,Primary Activity,Secondary Activity,Main Output Category
FSC-C001777,W12 Indoor furnitureW12.4 Beds,,,Secondary Processor,Secondary Processor,FSC Mix
FSC-C124838,"W18 Other manufactured wood productsW18.4 Tools, tool bodies and handles",, Abies spp; Betula spp.; Fagus sylvatica L.; Hevea brasiliensis; Paulownia tomentosa (Thunb. ex Murr) Steud; Picea spp.; Populus spp.; Quercus spp; Schima wallichii (DC.) Korth.; Swietenia macrophylla; Tilia spp.; Ulmus spp.,brokers/traders with physical posession,,FSC Mix;FSC 100%;FSC Recycled
FSC-C068163,P2 Paper,,,brokers/traders with physical posession,Distributor/Wholesaler,FSC Mix;FSC 100%;FSC Recycled
FSC-C068163,P3 Paperboard,,,brokers/traders with physical posession,Distributor/Wholesaler,FSC Mix;FSC 100%;FSC Recycled
FSC-C101537,P8 Printed materials,,,Printing and related service,Secondary Processor,FSC Mix;FSC 100%;FSC Recycled
FSC-C101537,P7 Stationery of paper,,,Printing and related service,Secondary Processor,FSC Mix;FSC 100%;FSC Recycled
FSC-C005776,W12 Indoor furnitureW12.10 Cupboards and chests,"Outros produtos, (baú, quadro espelho, etc.)", Eucalyptus spp; Pinus spp.,Secondary Processor,,FSC Mix
FSC-C005776,W12 Indoor furnitureW12.7 Office furniture,"Produtos para escritório (escrivaninha, mesa, gaveteiros, etc.)", Eucalyptus spp; Pinus elliottii,Secondary Processor,,FSC Mix
FSC-C005776,W12 Indoor furnitureW12.12 Parts of furniture,"Partes de movéis, (peças de reposição)", Eucalyptus spp; Pinus taeda,Secondary Processor,,FSC Mix
FSC-C005776,W12 Indoor furnitureW12.4 Beds,Camas, Eucalyptus spp; Pinus taeda,Secondary Processor,,FSC Mix
推荐阅读
- drupal - 我已经构建了一个drupal模块,现在呢?
- java - Lcom/google/firebase/FirebaseApp 类中没有虚拟方法 zzbqo()Z;或其超类('com.google.firebase.FirebaseApp' 的声明
- unity3d - 如何在 ARcore 中确定平面垂直或水平?
- javascript - 如何使用带有 Google Maps API 的 JavaScript 获取地点的时区偏移量?
- html - 12 列系统在移动设备上没有响应
- ada - 使用 ASIS 比较 Ada 中两种子类型的混合、最大值
- hadoop - 在 MapR-FS 中读取和写入文件的剖析
- spring-boot - 如何从 Spring Boot 在控制台上打印 redis 查询?
- javascript - 将字符串拆分为数组
- marklogic - 多方面互动