html导出.csv在一列,BeautifulSoup/Python-将HTML表转换为CSV并获取一列的ref

您应该在第8个td标记中访问a标记的href属性：import csv

import urllib2

from bs4 import BeautifulSoup

records = []

for index in range(39):

url = get_url(index) # where is the formatting in your example happening?

response = urllib2.urlopen(url)

try:

html = response.read()

except Exception:

raise

else:

my_parse(html)

finally:

try:

response.close()

except (UnboundLocalError, NameError):

raise UnboundLocalError

def my_parse(html):

soup = BeautifulSoup(html)

table2 = soup.find_all('table')[1]

for tr in table2.find_all('tr')[2:]:

tds = tr.find_all('td')

url = tds[8].a.get('href')

records.append([elem.text.encode('utf-8') for elem in tds])

# perhaps you want to update one of the elements of this last

# record with the found url now?

# It's more efficient to write only once

with open('listing.csv', 'wb') as f:

writer = csv.writer(f)

writer.writerows(records)

我冒昧地基于索引定义了一个函数get_url，因为您的示例每次都会重读同一个文件，这是我猜您实际上并不需要的。我会把实现交给你。另外，我还添加了一些更好的异常处理。

同时，我还演示了如何从该网页的表中访问第二个表。