-
Notifications
You must be signed in to change notification settings - Fork 0
/
scraper.py
45 lines (34 loc) · 1.62 KB
/
scraper.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
# This is a template for a Python scraper on morph.io (https://morph.io)
# including some code snippets below that you should find helpful
import scraperwiki
import lxml.html
# Read in a page
html = scraperwiki.scrape("http://www.lavanguardia.com/")
# Find something on the page using css selectors
root = lxml.html.fromstring(html)
bylines = root.cssselect("span.story-author-name")
for byline in bylines:
print lxml.html.tostring(byline)
print byline.text.encode('utf-8')
for byline in bylines:
record = { "byline" : byline.text } # column name and value
scraperwiki.sqlite.save(["byline"], record) # save the records one by one
# Find something on the page using css selectors
root = lxml.html.fromstring(html)
bylines = root.cssselect("a.story-header-title-link")
for title in titles:
print lxml.html.tostring(title)
print title.text.encode('utf-8')
for title in titles:
record = { "title" : title.text } # column name and value
scraperwiki.sqlite.save(["title"], record) # save the records one by one
# # Write out to the sqlite database using scraperwiki library
# scraperwiki.sqlite.save(unique_keys=['name'], data={"name": "susan", "occupation": "software developer"})
#
# # An arbitrary query against the database
# scraperwiki.sql.select("* from data where 'name'='peter'")
# You don't have to do things with the ScraperWiki and lxml libraries.
# You can use whatever libraries you want: https://morph.io/documentation/python
# All that matters is that your final data is written to an SQLite database
# called "data.sqlite" in the current working directory which has at least a table
# called "data".