Scrapy - Crawls for Scraping AJAX Pages


Here is the code of a simple spider that would use Crawls for Scraping AJAX Pages.

Comments

Post a Comment

Popular posts from this blog

How to scrape a website that requires login first with Python Scrapy-framework (Filling login forms automatically)

We often have to write spiders that need to login to sites, in order to scrape data from them. Our customers provide us with the site, username and password, and we do the rest. The classic way to approach this problem is: 1.      launch a browser, go to site and search for the login page 2.      inspect the source code of the page to find out:                       I.         which one is the login form (a page can have many forms, but usually one of them is the login form)                      II.         which are the field names used for username and password (these could vary a lot)                     III.         if there are other fields that must be submitted (like an authentication token) 3.      write the Scrapy spider to replicate the form submission using   FormRequest Being fans of automation, we figured we could write some code to automate point 2 (which is actually the most time-consuming) and the result is   login form, a library to automatically fi
Read more

Import CSV in Postgress using Python Panda , compare two csv files and compare two db table using python

import pandas as pd from sqlalchemy import create_engine import psycopg2 import csv def importCSV(): engine = create_engine('postgresql://credr:credr@localhost/credr_db1') df = pd.read_csv('/Users/ranvijay/Desktop/data_sanity_21082015/Katta_data.csv') df.to_sql('data_anlytics', engine, if_exists='replace') df = pd.read_csv('/Users/ranvijay/Desktop/data_sanity_21082015/Data_sanity_21082015.csv') df.to_sql('data_bd', engine, if_exists='replace') # df = pd.read_csv('/Users/ranvijay/Downloads/BikeSheet.csv') # df.to_sql('bikesheet_dump', engine, if_exists='replace') def comapre_two_table(): # execute our Query conn_string = "host='localhost' dbname='credr_db1' user='credr' password='credr'" # print the connection string we will use to connect print "Connecting to database\n ->%s" % (conn_string) # get
Read more

User Model Test Case

# Hi, if you are writing model level test cases then you can try something like this from django.test import TestCase from django.contrib.auth import get_user_model from s3boto.models import Resource import tempfile class UserTestCase(TestCase): def _create_image(self): from PIL import Image # path='/Users/Mac/Downloads/' with tempfile.NamedTemporaryFile(suffix='.png', delete=False) as f: image = Image.new('RGB', (200, 200), 'white') image.save(f, 'PNG') return open(f.name, mode='rb') def setUp(self): self.image = self._create_image() self.name = self.image.name.split('.')[0] self.ext = self.image.name.split('.')[1] self.resource = Resource( name=self.name, ext=self.ext, bucket='test', data_source_type=0, type=1, descr
Read more