如何从URL中的第二个表中抓取数据？

import requests
from bs4 import BeautifulSoup

# 解析URL
url = "http://example.com"
parsed_url = urllib.parse.urlparse(url)

# 发起HTTP请求
response = requests.get(url)

# 解析HTML
soup = BeautifulSoup(response.text, "html.parser")

# 定位表格
table = soup.select("table")[1]  # 假设第二个表格是目标表格

# 提取数据
data = []
for row in table.find_all("tr"):
    cells = row.find_all("td")
    if cells:
        row_data = [cell.text.strip() for cell in cells]
        data.append(row_data)

# 打印数据
for row_data in data:
    print(row_data)

# 存储数据（示例：存储到CSV文件）
import csv

with open("data.csv", "w", newline="") as csvfile:
    writer = csv.writer(csvfile)
    writer.writerows(data)