python资产负债表_用Python清理雅虎财务资产负债表

最简单的方法是使用一个try/except组合，使用凸起的ValueError：import requests, bs4, re

def periodic_figure_values(soup, yahoo_figure):

values = []

pattern = re.compile(yahoo_figure)

title = soup.find("strong", text=pattern) # works for the figures printed in bold

if title:

row = title.parent.parent

else:

title = soup.find("td", text=pattern) # works for any other available figure

if title:

row = title.parent

else:

sys.exit("Invalid figure '" + yahoo_figure + "' passed.")

cells = row.find_all("td")[1:] # exclude the

with figure name

for cell in cells:

if cell.text.strip() != yahoo_figure: # needed because some figures are indented

str_value = cell.text.strip().replace(",", "").replace("(", "-