问题描述
我想从另一个 url 中获取数据,我正在使用 urllib 和 Beautiful Soup ,我的数据在 table 标签内(我已经使用 Firefox 控制台弄清楚了).但是当我尝试使用他的 id 获取表时,结果是 None ,那么我猜这个表必须通过一些 js 代码动态添加.
I want to fetch data from another url for which I am using urllib and Beautiful Soup , My data is inside table tag (which I have figure out using Firefox console). But when I tried to fetch table using his id the result is None , Then I guess this table must be dynamically added via some js code.
我已经尝试了所有的解析器 'lxml', 'html5lib' 但我仍然无法获取该表数据.
I have tried all both parsers 'lxml', 'html5lib' but still I can't get that table data.
我还尝试了另一件事:
web = urllib.urlopen("my url")
html = web.read()
soup = BeautifulSoup(html, 'lxml')
js = soup.find("script")
ss = js.prettify()
print ss
结果:
<script type="text/javascript">
myPage = 'ETFs';
sectionId = 'liQuotes'; //section tab
breadCrumbId = 'qQuotes'; //page
is_dartSite = "quotes";
is_dartZone = "news";
propVar = "ETFs";
</script>
但是现在我不知道如何获取这些js变量的数据.
But now I don't know how I can get data of these js variables.
现在我有两个选择,要么获取表格内容,要么获取 js 变量,其中任何一个都可以完成我的任务,但不幸的是我不知道如何获取这些,所以请告诉我如何解决任何一个问题.
Now I have two options either get that table content ot get that the js variables, any one of them can fulfil my task but unfortunately I don't know how to get these , So please tell how I can get resolve any one of the problem.
谢谢
推荐答案
EDIT
这将使用 re 模块提取数据并将其加载为 JSON:
This will do the trick using re module to extract the data and loading it as JSON:
import urllib
import json
import re
from bs4 import BeautifulSoup
web = urllib.urlopen("http://www.nasdaq.com/quotes/nasdaq-financial-100-stocks.aspx")
soup = BeautifulSoup(web.read(), 'lxml')
data = soup.find_all("script")[19].string
p = re.compile('var table_body = (.*?);')
m = p.match(data)
stocks = json.loads(m.groups()[0])
>>> for stock in stocks:
... print stock
...
[u'ASPS', u'Altisource Portfolio Solutions S.A.', 116.96, 2.2, 1.92, 86635, u'N', u'N']
[u'AGNC', u'American Capital Agency Corp.', 23.76, 0.13, 0.55, 3184303, u'N', u'N']
.
.
.
[u'ZION', u'Zions Bancorporation', 29.79, 0.46, 1.57, 2154017, u'N', u'N']
这样做的问题是脚本标记偏移量是硬编码的,并且没有可靠的方法在页面中定位它.对页面的更改可能会破坏您的代码.
The problem with this is that the script tag offset is hard-coded and there is not a reliable way to locate it within the page. Changes to the page could break your code.
原始答案
与其尝试对数据进行屏幕抓取,您还可以从 http://www.nasdaq.com/quotes/nasdaq-100-stocks.aspx?render=download.
Rather than try to screen scrape the data, you can download a CSV representation of the same data from http://www.nasdaq.com/quotes/nasdaq-100-stocks.aspx?render=download.
然后使用 Python csv 模块进行解析处理它.这不仅更方便,而且是一种更有弹性的解决方案,因为对 HTML 的任何更改都可能很容易破坏您的屏幕抓取代码.
Then use the Python csv module to parse and process it. Not only is this more convenient, it will be a more resilient solution because any changes to the HTML could easily break your screen scraping code.
否则,如果您查看实际的 HTML,您会发现页面内的数据在以下脚本标记中可用:
Otherwise, if you look at the actual HTML you will find that the data is available within the page in the following script tag:
<script type="text/javascript">var table_body = [["ATVI", "Activision Blizzard, Inc", 20.92, 0.21, 1.01, 6182877, .1, "N", "N"],
["ADBE", "Adobe Systems Incorporated", 66.91, 1.44, 2.2, 3629837, .6, "N", "N"],
["AKAM", "Akamai Technologies, Inc.", 57.47, 1.57, 2.81, 2697834, .3, "N", "N"],
["ALXN", "Alexion Pharmaceuticals, Inc.", 170.2, 0.7, 0.41, 659817, .1, "N", "N"],
["ALTR", "Altera Corporation", 33.82, -0.06, -0.18, 1928706, .0, "N", "N"],
["AMZN", "Amazon.com, Inc.", 329.67, 6.1, 1.89, 5246300, 2.5, "N", "N"],
....
["YHOO", "Yahoo! Inc.", 35.92, 0.98, 2.8, 18705720, .9, "N", "N"]];
这篇关于获取 Python 中脚本标签内的变量数据或从 js 添加的内容的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,WP2