You cannot see this page without javascript.



[파이썬] scrapy 로 웹 사이트 크롤링


Crawl a website with scrapy

Written by Balthazar


In this article, we are going to see how to scrape information from a website, in particular, from all pages with a common URL pattern. We will see how to do that with Scrapy, a very powerful, and yet simple, scraping and web-crawling framework.

For example, you might be interested in scraping information about each article of a blog, and store it information in a database. To achieve such a thing, we will see how to implement a simple spider using Scrapy, which will crawl the blog and store the extracted data into a MongoDB database.

We will consider that you have a working MongoDB server, and that you have installed the pymongo and scrapy python packages, both installable with pip.

If you have never toyed around with Scrapy, you should first read this short tutorial.

First step, identify the URL pattern(s)

In this example, we’ll see how to extract the following information from each blogpost :

  • title
  • author
  • tag
  • release date
  • url

We’re lucky, all posts have the same URL pattern: These links can be found in the different pages of the site homepage.

What we need is a spider which will follow all links following this pattern, scrape the required information from the target webpage, validate the data integrity, and populate a MongoDB collection.

Building the spider

We create a Scrapy project, following the instructions from their tutorial. We obtain the following project structure:

├── isbullshit
│   ├──
│   ├──
│   ├──
│   ├──
│   └── spiders
│       ├──
│       ├──
└── scrapy.cfg

We begin by defining, in, the item structure which will contain the extracted information:

from scrapy.item import Item, Field

class IsBullshitItem(Item):
    title = Field()
    author = Field()
    tag = Field()
    date = Field()
    link = Field()

Now, let’s implement our spider, in

from scrapy.contrib.spiders import CrawlSpider, Rule
from scrapy.contrib.linkextractors.sgml import SgmlLinkExtractor
from scrapy.selector import HtmlXPathSelector
from isbullshit.items import IsBullshitItem

class IsBullshitSpider(CrawlSpider):
    name = 'isbullshit'
    start_urls = [''] # urls from which the spider will start crawling
    rules = [Rule(SgmlLinkExtractor(allow=[r'page/\d+']), follow=True), 
    	# r'page/\d+' : regular expression for URLs
    	Rule(SgmlLinkExtractor(allow=[r'\d{4}/\d{2}/\w+']), callback='parse_blogpost')]
    	# r'\d{4}/\d{2}/\w+' : regular expression for URLs
    def parse_blogpost(self, response):

Our spider inherits from CrawlSpider, which “provides a convenient mechanism for following links by defining a set of rules”. More info here.

We then define two simple rules:

  • Follow links pointing to
  • Extract information from pages defined by a URL of pattern, using the callback method parse_blogpost.

Extracting the data

To extract the title, author, etc, from the HTML code, we’ll use the scrapy.selector.HtmlXPathSelector object, which uses the libxml2 HTML parser. If you’re not familiar with this object, you should read the XPathSelector documentation.

We’ll now define the extraction logic in the parse_blogpost method (I’ll only define it for the title and tag(s), it’s pretty much always the same logic):

def parse_blogpost(self, response):
    hxs = HtmlXPathSelector(response)
    item = IsBullshitItem()
    # Extract title
    item['title'] ='//header/h1/text()').extract() # XPath selector for title
    # Extract author
    item['tag'] ="//header/div[@class='post-data']/p/a/text()").extract() # Xpath selector for tag(s)
    return item

Note: To be sure of the XPath selectors you define, I’d advise you to use Firebug, Firefox Inspect, or equivalent, to inspect the HTML code of a page, and then test the selector in a Scrapy shell. That only works if the data position is coherent throughout all the pages you crawl.

Store the results in MongoDB

Each time that the parse_blogspot method returns an item, we want it to be sent to a pipeline which will validate the data, and store everything in our Mongo collection.

First, we need to add a couple of things to

ITEM_PIPELINES = ['isbullshit.pipelines.MongoDBPipeline',]

MONGODB_SERVER = "localhost"
MONGODB_DB = "isbullshit"

Now that we’ve defined our pipeline, our MongoDB database and collection, we’re just left with the pipeline implementation. We just want to be sure that we do not have any missing data (ex: a blogpost without a title, author, etc).

Here is our file :

import pymongo

from scrapy.exceptions import DropItem
from scrapy.conf import settings
from scrapy import log
class MongoDBPipeline(object):
    def __init__(self):
        connection = pymongo.Connection(settings['MONGODB_SERVER'], settings['MONGODB_PORT'])
        db = connection[settings['MONGODB_DB']]
        self.collection = db[settings['MONGODB_COLLECTION']]
    def process_item(self, item, spider):
    	valid = True
        for data in item:
          # here we only check if the data is not null
          # but we could do any crazy validation we want
       	  if not data:
            valid = False
            raise DropItem("Missing %s of blogpost from %s" %(data, item['url']))
        if valid:
          log.msg("Item wrote to MongoDB database %s/%s" %
                  (settings['MONGODB_DB'], settings['MONGODB_COLLECTION']),
                  level=log.DEBUG, spider=spider) 
        return item

Release the spider!

Now, all we have to do is change directory to the root of our project and execute

$ scrapy crawl isbullshit

The spider will then follow all links pointing to a blogpost, retrieve the post title, author name, date, etc, validate the extracted data, and store all that in a MongoDB collection if validation went well.

Pretty neat, hm?


This case is pretty simplistic: all URLs have a similar pattern and all links are hard written in the HTML code: there is no JS involved. In the case were the links you want to reach are generated by JS, you’d probably want to check out Selenium. You could complexify the spider by adding new rules, or more complicated regular expressions, but I just wanted to demo how Scrapy worked, not getting into crazy regex explanations.

Also, be aware that sometimes, there’s a thin line bewteen playing with web-scraping and getting into trouble.

Finally, when toying with web-crawling, keep in mind that you might just flood the server with requests, which can sometimes get you IP-blocked :)

Please, don’t be a d*ick.

See code on Github

The entire code of this project is hosted on Github. Help yourselves!

번호 제목 글쓴이 날짜 조회 수
467 [엑셀로 웹 스크래핑3] Excel VBA Web Scraping Tutorial file 졸리운_곰 2016.10.09 10
466 [엑셀로 웹 스크래핑2] Scrape webpage data using Excel & VBA 졸리운_곰 2016.10.09 8
465 [엑셀로 웹 스크래핑] Web Scraping - Basics 졸리운_곰 2016.10.09 10
464 Web Scraping Tutorial by ms excel 엑셀로 웹 스크래핑 file 졸리운_곰 2016.10.09 16
463 게임기획자를 위한 엑셀VBA 강좌 자료 파일 업로드 file 졸리운_곰 2016.10.03 5
462 마크다운에 관하여 file 졸리운_곰 2016.08.28 17
461 마크다운(Markdown)으로 글을 써보자 file 졸리운_곰 2016.08.28 36
460 Windows에서 텐서플로우 (tensorFlow)설치 file 졸리운_곰 2016.08.21 28
459 Top 50 open source web crawlers for data mining 졸리운_곰 2016.08.10 8
458 RESTful API를 설계하기 위한 디자인 팁 졸리운_곰 2016.08.09 7
457 무료로 배우는 공부 및 강좌 사이트 모음 정리 file 졸리운_곰 2016.08.07 62
456 Sending and Receiving Binary Data 졸리운_곰 2016.08.06 7
455 Sending binary data along with a REST API request 졸리운_곰 2016.08.06 9
454 BSON 이해하기 졸리운_곰 2016.08.06 8
453 칸반과 큰 시각화 차트(Kanban Boards and Big Visible Charts) file 졸리운_곰 2016.07.19 82
452 [번역] 잘 가요 스크럼, 반가워요 칸반 졸리운_곰 2016.07.19 10
451 개인 Todo List를 애자일로 실행하기 file 졸리운_곰 2016.07.19 12
450 [펌] 만화로 보는 칸반보드 file 졸리운_곰 2016.07.19 12
449 HTTP 프로토콜 집중탐구[1] 졸리운_곰 2016.07.18 7
448 HTTP 프로토콜 분석 졸리운_곰 2016.07.18 16
대표 김성준 주소 : 경기 용인 분당수지 U타워 등록번호 : 142-07-27414
통신판매업 신고 : 제2012-용인수지-0185호 출판업 신고 : 수지구청 제 123호 개인정보보호최고책임자 : 김성준